Search found 47 matches

by raulravi
Thu Oct 11, 2012 5:02 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Checking Header & Trailer
Replies: 12
Views: 14816

Checking Header & Trailer

I have a CSV file, and i want to check if there a Header & Trailer is there in that file. Else i will have to abend the job.

Can we do it in DFSORT?

Raul
by raulravi
Mon Jan 02, 2012 6:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Addition using DFsort
Replies: 1
Views: 3003

Addition using DFsort

Hello Frank,

Code: Select all

My file looks like

----+--
*******
1501   
1588   
1598   
1600   


I want to add the position1 + position2 +position3 +position4.
Eg:
1+5+0+1 = 7
1+5+8+8 = 22==> 2+2 = 4.
1+5+9+8 = 23==> 2+3 = 5.
1+6+0+0 = 7
Can we do this kind of operation in DFSORT?

Raul
by raulravi
Thu Jul 28, 2011 9:34 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing Two Records in the same file & Replacing Value
Replies: 1
Views: 4170

Comparing Two Records in the same file & Replacing Value

Frank, I have a input file as below. Code: Input file: Date feild2&3custid FLD-1 FLD-2 FLD-3 20110101 111111 london Real Fraud 20101201 111111 Madrid Real Fraud 20101101 111111 london Real Fraud 20101001 111111 london Ceal Fraud 20100901 111111 london Ceal Secur 20110101 222222 Madrid Real Fraud 201...
by raulravi
Wed Jul 27, 2011 5:52 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Merging & Joining REcords in Five Files
Replies: 5
Views: 10511

Hello Frank, When i am running the below JOb. It is working //S1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN1 DD DSN=TTYA.GONUGRK.CUSTPER.UNLOAD,DISP=SHR //IN2 DD DSN=TTYA.GONUGRK.CUSTPER.UNLAD22,DISP=SHR //OUT DD DSN=TTYA.GONUGRK.CUSTPER.FINAL,DISP=MOD //TOOLIN DD * COPY FROM&#...
by raulravi
Wed Jul 27, 2011 10:57 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Frank, I have a input file as below. Input file: Date feild2&3custid FLD-1 FLD-2 FLD-3 20110101 111111 london Real Fraud 20101201 111111 Madrid Real Fraud 20101101 111111 london Real Fraud 20110101 222222 Madrid Real Fraud 20101201 222222 london Real Fraud 20101101 222222 Madrid Real Fraud 20101101 ...
by raulravi
Mon Jul 25, 2011 9:24 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

starting position of Cust-id = 26, Field-1 = 36 and Field-2 =51 and so on till 308 in file1. Can we take it as one string ( from 36 to 308) ? starting position of Cust-id = 20, Field-1 = 30 and Field-2 =46 and so on till 301 in file2. Can we take it as one string ( from 30 to 301) ? the files are sa...
by raulravi
Fri Jul 22, 2011 1:30 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

For example File1: Date time Operatorid Cust-id Field-1 Field-2 01/01/201111:11:11 aaaaaa 111111 asa sas 01/01/201011:11:11 aaaaaa 111111 asa sas File2: Date time Cust-id Field-1 Field-2 01/01/200911:11:11 111111 asa sas 01/01/200811:11:11 222222 asa sas Output file: Date time Operatorid Cust-id Fie...
by raulravi
Fri Jul 22, 2011 11:31 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Hello Frank, I have two files with different record length. Management class . . : TESTSTD Storage class . . . : STANDARD Volume serial . . . : TTQ1Z0 + Device type . . . . : 3390 Data class . . . . . : DB2CLASS Organization . . . : PS Record format . . . : FB Record length . . . : 308 Block size . ...
by raulravi
Fri Jul 22, 2011 11:25 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Thanks a lot frank, it worked.
by raulravi
Thu Jul 21, 2011 9:06 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Dear Frank, I am still getting the error, OPTION COPY OUTFIL REMOVECC,NODETAIL, SECTIONS=(20,256,276,26, HEADER3=(1,301)) £ ICE223A F REPORT FIELD ERROR ICE751I 0 C5-K51707 C6-K51707 C7-K54603 C8-K51707 E7-K51707 ICE052I 3 END OF DFSORT What i am trying to do is ... ----+----1----+--...
by raulravi
Wed Jul 20, 2011 4:42 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Also please find the File details General Data Current Allocation Management class . . : TESTSTD Allocated cylinders : 4,153 Storage class . . . : STANDARD Allocated extents . : 1 Volume serial . . . : T0Q1T4 + Device type . . . . : 3390 Data class . . . . . : DB2CLASS Organization . . . : PS Curren...
by raulravi
Wed Jul 20, 2011 1:23 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Hi Frank, I am trying to run this JOb, becos i have to check the record from coloumn 20 to 301. //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file (FB/301) //SORTOUT DD DSN=... output file (FB/301) //SYSIN DD * OPTION COPY OUTFIL REMOVECC,NODETAIL, SECTIONS=(2...
by raulravi
Thu Jul 14, 2011 11:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

I Have a three files. File1: custid Name email club 1 Ravi gmail real 1 Ravi yahoo real 2 kiran gmail fcb 2 kiran gmail fcb 3 arun yahoo manu 4 raja rediff fcb File2: Email Id Code Gmail 1111G Yahoo 2222Y Rediff 3333R inbox 4444I File3: club Code real aaa1 fcb bbb2 manu ccc3 I want to replace the Em...
by raulravi
Wed Jul 13, 2011 10:45 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Hi Frank, i am removed duplicates as below. //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file (FB/300) //SORTOUT DD DSN=... output file (FB/300) //SYSIN DD * OPTION COPY OUTFIL REMOVECC,NODETAIL, SECTIONS=(1,40, HEADER3=(1,300)) /* But now i have ...
by raulravi
Wed Jul 06, 2011 9:36 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comapare Two Records in the same File
Replies: 27
Views: 40406

Terrific, it's working as i need........ Thanks a lot frank.