Search found 6 matches

by Rajeshk.sakthivel
Wed Oct 05, 2011 8:14 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing packed date fields with current date
Replies: 1
Views: 4216

Comparing packed date fields with current date

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.
by Rajeshk.sakthivel
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...
by Rajeshk.sakthivel
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 /* ...
by Rajeshk.sakthivel
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...
by Rajeshk.sakthivel
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
by Rajeshk.sakthivel
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...