Search found 47 matches

by raulravi
Tue Jul 05, 2011 4:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 29829

Dear Frank, Thanks a lot, i am able to get the desired output. Frank a column in the output file is blank, and i want to fill it with a unique number, like 1 , 2 3 Input Custid Name Unique No email  Salary  date  111  Frank   gmail 60000  20110514  111  Frank   yahoo 60000  20110501  111  Frank   gm...
by raulravi
Fri Jul 01, 2011 10:11 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 29829

Input: Custid Name email Salary date 111 Frank gmail 60000 20110514 111 Frank yahoo 60000 20110501 111 Frank gmail 60000 20110301 111 Frank gmail 60000 20110201 111 Frank gmail 60000 20110101 222 Raul gmail 60000 20110101 Output: Custid Name email Salary date 111 Frank gmail 60000 20110514 111 Fran...
by raulravi
Thu Jun 23, 2011 1:31 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging & Joining REcords in Five Files
Replies: 5
Views: 7871

Merging & Joining REcords in Five Files

Hi, I have five different file, with Cust-Id & Date as Key for all. When ever the Cust-ID & Date in all the five Files is same i have to join all the five records to one single record in the output file. Eg: If the Cust -ID & date is available in all the files then i will have to merge all the recor...
by raulravi
Thu Jun 23, 2011 11:23 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 29829

Yes the input records were actually already in sorted order. And i dont want to delete the 3rd record. I just want to delete the 4th and 5th records. Because I am trying to capture the changes done to the Customer details. In the first record it is Gmail , and in the 2nd it is Yahoo, so there is a c...
by raulravi
Wed Jun 22, 2011 1:29 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 29829

Dear Frank, Sorry to confuse you... PLease find the example below Merged File: Custid Name email Salary date 111 Sandeep gmail 60000 14-May-11 111 Sandeep yahoo 60000 01-May-11 111 Sandeep gmail 60000 01-Mar-11 111 Sandeep gmail 60000 01-Feb-11 111 Sandeep gmail 60000 01-Jan-11 222 Raul gmail 60000 ...
by raulravi
Wed Jun 15, 2011 9:34 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Filling Blank feilds with Values
Replies: 7
Views: 6930

//SYSIN DD * JOINKEYS F1=IN1,FIELDS=(1,13,A) JOINKEYS F2=IN2,FIELDS=(1,13,A) JOIN UNPAIRED,F1 REFORMAT FIELDS=(F1:1,53,F2:14,10) OPTION COPY OUTREC BUILD=(1,13,14:24,10,24:54,10,44:44,10) /* Hi Frank can you plz explain me the above JOin keys actions ? Regards, Raul
by raulravi
Fri Jun 10, 2011 9:16 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Filling Blank feilds with Values
Replies: 7
Views: 6930

File A: F1NUM1 F1NAME F1SALARY F1CLUB F1DEPT F1DATE 3/NUM 10/AN 10/AN 10/AN 10/AN 10/AN (1-3) (4-13) (14-23) (24-33) (34-43) (44-53) 1------- 2--------- 3--------- 4--------- 5--------- 6------- 000001 1 RAVI REAL 19031984 000002 1 RAVI REAL 19031985 0...
by raulravi
Thu Jun 09, 2011 11:18 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Filling Blank feilds with Values
Replies: 7
Views: 6930

Dear Frank, Ya you are right , date does not matter here, i am sorry for the confusion. Cust-Id is the Key. 1) File A contains all the Customer Details, except Salary & email feilds. 2) File B conatains Salary Details for a customer. 3) File c conatains email Details for a customer. Rules: 1) Suppos...
by raulravi
Wed Jun 08, 2011 9:43 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Filling Blank feilds with Values
Replies: 7
Views: 6930

Filling Blank feilds with Values

Hi I have a file 'A' with 100 records of customer details with Key as Customer-ID and date. And i also have two more file 'B' & 'C' with same key (Customer-ID & Date). File B have dept details. And File C have email address details. I want to put the Salary details from B and email address details i...
by raulravi
Fri Apr 29, 2011 10:47 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 29829

Comapare Two Records in the same File

S.no Name dept salary dept 1 Raul Real 2000 S&F 2 Raul ACM 1000 R&D 3 Raul ACM 1000 K&P I have to read the first recoed and comapre fields in it with the fields in the second record. When ever there is a mis match i have have to write it to the output recoed and set a indicator. For example, When i...
by raulravi
Thu Apr 21, 2011 2:07 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Rearrage the Feilds - DF SORT
Replies: 13
Views: 14732

Hi Frank, I trie dto run the below job & i got some syntax error, //TTYASAS3 JOB ,CLASS=3,MSGCLASS=0,NOTIFY=&SYSUID //* RUN THROUGH JCLPREP ON 21/04/2011 AT 08:58:17 BY GONUGRK FOR QBOS //* //JKE1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTJNF1 DD DSN=TTYA.GONUGRK.JOIN1,DISP=SHR //SORTJNF2 DD DSN=TTYA...
by raulravi
Wed Apr 20, 2011 4:01 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Rearrage the Feilds - DF SORT
Replies: 13
Views: 14732

Hello Frank, My Requirement: I have three DB2 Table Unload Files with different record length. The Files are real big, We might have 20, 30 million records. I have to pick 50 columns from file1, 30 from the 2nd and 20 from the third one, and write all these in to a new Output file in respective posi...
by raulravi
Wed Apr 20, 2011 10:54 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Rearrage the Feilds - DF SORT
Replies: 13
Views: 14732

Dear Frank,

Thank you very much..

1)Do we need to set up symbols like this for all the 100 feilds in the
INREC?

2) How to paste my Mainframe Screen here in this message, to explain
you better?

Raul[/img]
by raulravi
Tue Apr 19, 2011 3:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Rearrage the Feilds - DF SORT
Replies: 13
Views: 14732

Thanks A lot Anuj,

1) Can you explain this INREC FIELDS=(1:5,5,6:1,5,11:11,90)?

2) How to insert image in the message? As you did Mainframe code...

Raul
by raulravi
Tue Apr 19, 2011 1:55 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Rearrage the Feilds - DF SORT
Replies: 13
Views: 14732

Input File INSTRING1 INSTRING2 INSTRING3 INNUM1 INNUM2 INNUM3 INNUM4 5/AN 10/AN 5/AN 5/NUM 5/NUM 3/PS 5/PS (1-5) (6-15) (16-20) (21-25) (26-30) (31-33) (34-38) ***************************** TOP OF DATA ****************** ABCDE QRSTUVWXYZ !@#$% 123.45 12345 123.45 123.45678 FGHIH QWERTY1234 ASDFG 568...