Hi,
I have the following problem,
In my input file the fields 1-4 contains date stored as a packed field.
P'0011273C'
YYDDD format
I want to select all the records where the value in this field is equal to the current date.
Thanks for your help in advance.
Thanks.
Search found 6 matches
- Wed Oct 05, 2011 8:14 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comparing packed date fields with current date
- Replies: 1
- Views: 4216
- Mon Jul 18, 2011 5:06 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Substring
- Replies: 3
- Views: 5892
Substring
Hi all, It would be really helpful if someone could direct me on how to approach this wierd requirement.. Input File.. ABCDEFGHI...ABC AAAAAAAAA...ABC ABCDEFGHI...DEF ABCDEFGHI...GHI BBBBBBBBB...ABC Output File.. ABCDEFGHI...ABC ABCDEFGHI...DEF ABCDEFGHI...GHI I need to extract all the records in wh...
- Thu Mar 17, 2011 9:02 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Split the data between headers
- Replies: 2
- Views: 4805
I have somehow managed to do this with the code mentioned below, //S1 EXEC PGM=ICEMAN //SYSOUT DD SYSOUT=* //SORTIN DD * HEADER-AAA 1234567890 1234567890 1234567890 HEADER-BBB 0987654321 0987654321 0987654321 HEADER-CCC 1111111111 2222222222 3333333333 HEADER-AAA AAAAAAAAAA BBBBBBBBBB CCCCCCCCCC /* ...
- Thu Mar 17, 2011 7:37 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Split the data between headers
- Replies: 2
- Views: 4805
Split the data between headers
Hi, Please find below my requirement, Input: (Record Length : 10) Header-AAA 1234567890 1234567890 1234567890 Header-BBB 0987654321 0987654321 0987654321 Header-CCC 1111111111 2222222222 3333333333 Header-AAA aaaaaaaaaa bbbbbbbbbb ccccccccccc My expected output is - FileA: Header-AAA 1234567890 1234...
- Thu Mar 17, 2011 7:04 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT Count string occurence
- Replies: 2
- Views: 7948
Thanks Frank.
Thanks Frank. That worked perfectly.
Regards,
Rajesh
Regards,
Rajesh
- Wed Mar 16, 2011 8:30 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT Count string occurence
- Replies: 2
- Views: 7948
DFSORT Count string occurence
I have the following requirement, I have a file of Record length 10 and the I have to find the number of occurences of a string within the file. The string could occur more than once with in the same record and can be in any position. Eg: AAABBBAAAC 111AAABBBB 11111AAA22 I need to find for the strin...