Search found 19 matches

by 4ubobby
Thu Jul 22, 2010 8:24 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool for finding matching records from two files
Replies: 1
Views: 4310

icetool for finding matching records from two files

Hi, I want a icetool jcl which can find matching records from two files and write them into a third file. Here is the layout of both the files input file 1 lrecl = 168 ******************* the key field starts from 9 position and it is 19 bytes long . input file 2 lrecl = 80 ****************** the ke...
by 4ubobby
Fri Mar 12, 2010 10:31 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: any option with icetool
Replies: 1
Views: 3093

any option with icetool

Hi , I have a requirement where i need to count the records in a file based upon a field value. My input record is 80 characters the field that needs to be considered for counting is 21:2 (two bytes from 21 position) example of input data 11111111111111111111EA 22222222222222222222EA 333333333333333...
by 4ubobby
Wed Jan 06, 2010 2:00 am
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

yes you are correct

correct
by 4ubobby
Tue Jan 05, 2010 11:55 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

files

all the files are in FB Format.

any order is fine. if match found it should be written.


ICE201I F RECORD TYPE ... July, 2008 DFSORT
by 4ubobby
Tue Jan 05, 2010 11:47 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

example

Input file 1
*********
from input file 1 i want from 24 bytes starting from 17 and 9 bytes from 79 position.

input file 2
********
complete record which is 100 bytes.

outfile
*******
the length of the output file is 133 bytes 100 bytes from input file 2 and 33 bytes of input file 1.
by 4ubobby
Tue Jan 05, 2010 12:00 am
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

example

input1
*****
************1111*********test
************2222*********pest
************3333*********guest


input2
*****
1111testdata
2222aasdfas
3333adsfsafa
1111adfasdfs


output
*****
1111testdatatest
2222aasdfaspest
3333adsfsafaguest
1111adfasdfstest
by 4ubobby
Mon Jan 04, 2010 11:57 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

icetool

I Need to compare two files on a key field which is at different positions and if matching record is found some part of the record from file 1 and complete record from file 2 needs to be written to the output file input file 1:- lrecl 215 with key at position 1 length 7 input file 2:- lrecl 100 with...
by 4ubobby
Mon Jan 04, 2010 7:08 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool with splice
Replies: 10
Views: 16565

icetool with splice

HI, I Need to compare two files on a key field which is at different positions and if matching record is found some part of the record from file 1 and complete record from file 2 needs to be written to the output file input file 1:- lrecl 215 with key at position 1 length 7 input file 2:- lrecl 100 ...
by 4ubobby
Wed Dec 23, 2009 12:12 am
Forum: DFSORT , ICETOOL & Utilities
Topic: searching for a special character through sort
Replies: 9
Views: 15954

input file 1 lrecl 80 **************** 1234 test 2345 host 3456 also input file 2 lrecl 80 *************** 1234 bobby 1234 frank 2345 adam 3456 john my output file should look like output file ******** 1234 test bobby 2345 host adam 3456 also john if input file-1 first four bytes matches with the fi...
by 4ubobby
Tue Dec 22, 2009 7:32 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: searching for a special character through sort
Replies: 9
Views: 15954

dfsort icetool

Hi,

My shop as Dfsort icettol however frank was asking for some specific message ice201I G which i don't find in the icetool messages..
by 4ubobby
Mon Dec 21, 2009 11:44 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: searching for a special character through sort
Replies: 9
Views: 15954

dfsort

hi frank,

From next time, i would open a new topic for a new question. i don't have ICE201I G in my shop....
by 4ubobby
Mon Dec 21, 2009 9:07 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: searching for a special character through sort
Replies: 9
Views: 15954

Hi frank, I have two input files and require a output format based on the following conditions. input file 1 lrecl 80 **************** 1234 test data 2345 sample 3456 test sample input file 2 lrecl 80 *************** 1234 bobby 1234 frank 2345 adam 3456 john my output file should look like output fi...
by 4ubobby
Fri Nov 13, 2009 12:12 am
Forum: DFSORT , ICETOOL & Utilities
Topic: icetool
Replies: 1
Views: 3189

icetool

Hi frank, I am trying to get the number of records in an input file using icetool This is the jcl i am trying to run. //STEP1 EXEC PGM=ICETOOL //IN1 DD DSN=input file //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //TOOLIN DD * //SYSIN DD * COUNT FROM(IN1) /* i am not able to get any information nor the...
by 4ubobby
Tue Nov 10, 2009 12:39 am
Forum: DFSORT , ICETOOL & Utilities
Topic: icetol with splice
Replies: 1
Views: 3270

icetol with splice

hi frank,

both files do not have duplicate records and i want only the records which are present in both the files into a output file

input file-1
********
1111
2222

input file-2
**********
1111
2222
3333

output file
*********
1111
2222

the records should be present in both the files.
by 4ubobby
Mon Nov 09, 2009 7:00 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: searching for a special character through sort
Replies: 9
Views: 15954

searching for a special character through sort

hi,

I have a requirement where in my jcl sort needs to search for a special character like *.

the sample data would be like this

1234545*
1*32345
1234*11
1234555
2343566


My sort jcl needs to pick only the first three records which contains *

thanks in advance