Search found 19 matches
- 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...
- 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...
- Wed Jan 06, 2010 2:00 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: icetool with splice
- Replies: 10
- Views: 16565
yes you are correct
correct
- 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
any order is fine. if match found it should be written.
ICE201I F RECORD TYPE ... July, 2008 DFSORT
- 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.
*********
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.
- 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
*****
************1111*********test
************2222*********pest
************3333*********guest
input2
*****
1111testdata
2222aasdfas
3333adsfsafa
1111adfasdfs
output
*****
1111testdatatest
2222aasdfaspest
3333adsfsafaguest
1111adfasdfstest
- 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...
- 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 ...
- 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...
- 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..
My shop as Dfsort icettol however frank was asking for some specific message ice201I G which i don't find in the icetool messages..
- 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....
From next time, i would open a new topic for a new question. i don't have ICE201I G in my shop....
- 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...
- 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...
- 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.
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.
- 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
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