Search found 11 matches
- Tue Dec 05, 2006 8:10 pm
- Forum: JCL
- Topic: PROCEDURE's
- Replies: 2
- Views: 7350
- Fri Nov 24, 2006 9:42 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
- Thu Nov 23, 2006 11:58 am
- Forum: JCL
- Topic: Need a jcl for sending email and SMS.
- Replies: 3
- Views: 12938
- Thu Nov 23, 2006 10:22 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
- Tue Nov 14, 2006 5:22 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
- Fri Nov 10, 2006 11:29 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
Code: File 1 a/c loc name age add ------------------------ F1R1 01 F1R1 01 F1R1 05 F1R1 10 F1R1 10 F1R1 10 F1R1 15 F1R1 20 F1R1 20 File2 a/c status loc ------------- F1R1 S1 01 F1R1 S2 10 F1R1 S3 15 F1R1 S4 18 Output a/c loc name age add ----------------------- F1R1 05 F1R1 20 FILEA =COLS> ----+----...
- Fri Nov 10, 2006 1:06 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
Frank, please find the answeres to your queries. 1. What is the RECFM and LRECL of each input file? LRECL for FILEA is 478 and the for the other is 435.RECFM is FB for both the files. 2.What is the length and format of the field in each input file you want to compare? Format is ZD and the length is ...
- Thu Nov 09, 2006 1:02 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: To compare two files (SSN fields)
- Replies: 20
- Views: 55087
need help:comparing two datasets
Frank, I have a similar requirment, but the LRECL for both the input files are different. for FILEA its 478 and for FILEB its 435. Comparision Criteria: The field is of length 14, but the position of the key in FILEA is col# 13th and in FILEB its on col# 23. Now, I have to compare FILEA & FILEB and ...
- Thu Nov 09, 2006 11:32 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing two flat files
- Replies: 11
- Views: 27256
comparing two flat files
Hi, I want to compare two files for which the senerio is: The comapre field in the first file is at col.no 13 and in the other file its on the col.no 23.(both have same length and same format) Now, I want to compare the two file based on these field and remove the duplicate records. Is this possible...
- Wed Nov 08, 2006 5:06 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Reg:DFSORT
- Replies: 1
- Views: 5996
Reg:DFSORT
Hi, The Senerio is: I have a flat file of 400 record length and has 1000 record. from the 13th col. th date and time starts. The date format is DD.MM.YYYY and time format is HH:MM:SS. Now I want the Date and time in YYYYMMDD and HHMMSS format respectively, also the data present in the rest of the co...