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
Search found 47 matches
- Thu Oct 11, 2012 5:02 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Checking Header & Trailer
- Replies: 12
- Views: 14816
- Mon Jan 02, 2012 6:20 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Addition using DFsort
- Replies: 1
- Views: 3003
Addition using DFsort
Hello Frank,
Can we do this kind of operation in DFSORT?
Raul
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
Raul
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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 . ...
- Fri Jul 22, 2011 11:25 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 40406
- Thu Jul 21, 2011 9:06 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 40406
- 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...
- Wed Jul 20, 2011 1:23 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 40406
- 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...
- Wed Jul 13, 2011 10:45 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 40406
- Wed Jul 06, 2011 9:36 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 40406