Search found 18 matches
- Tue Dec 31, 2013 10:14 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT to compare TWO PS files and replace
- Replies: 4
- Views: 6164
Sample input and required output : ---------------------------------------- File A : LRECL - 221 , RECFM=FB AField1 AFiled2 AFiled3 AFiled4 AFiled5 <-- Just for information AA........BB........MM.........XX..........11MB AA........BB........NN.........MM..........22MB AA........BB........YY............
- Mon Dec 30, 2013 11:27 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT to compare TWO PS files and replace
- Replies: 4
- Views: 6164
DFSORT to compare TWO PS files and replace
Hi, i have two files, File A - LRECL - 221 File B - LRECL - 999 File A AField1 - Column(50:4) AField2 - Column(55:10) AField3 - Column(1:21) AField4 - Column(23:21) AField5 - Column(67:25) File B BField1 - Column(51:4) BField2 - Column(124:10) BField3 - Column(180:21) BField4 - Column(215:25) I want...
- Thu Mar 21, 2013 11:59 am
- Forum: JCL
- Topic: concatenate 3 input records in different ds into one record
- Replies: 5
- Views: 7253
- Thu Mar 21, 2013 11:21 am
- Forum: JCL
- Topic: concatenate 3 input records in different ds into one record
- Replies: 5
- Views: 7253
concatenate 3 input records in different ds into one record
I want to concatenate 3 input records in different dataset into one record in output dataset:
input1:
99abcdefghijklmno
input2:
123456789
input3:
987654321
Required output:
99abcdefghijklmno 123456789 987654321
input1:
99abcdefghijklmno
input2:
123456789
input3:
987654321
Required output:
99abcdefghijklmno 123456789 987654321
- Wed Mar 13, 2013 10:28 am
- Forum: JCL
- Topic: Need a 1step JCL to seperate header and detail records
- Replies: 3
- Views: 5661
- Wed Mar 06, 2013 3:19 pm
- Forum: JCL
- Topic: Need a 1step JCL to seperate header and detail records
- Replies: 3
- Views: 5661
Need a 1step JCL to seperate header and detail records
input -
00header-record
01Sub-header-record
10d1
10d2
10d3
10d4
10d5
98Sub-trailer-record
99Trailer-record
need output as -
output1-
00header-record
01Sub-header-record
98Sub-trailer-record
99Trailer-record
output2-
10d1
10d2
10d3
10d4
10d5
Can we do this in one step in JCL ??
00header-record
01Sub-header-record
10d1
10d2
10d3
10d4
10d5
98Sub-trailer-record
99Trailer-record
need output as -
output1-
00header-record
01Sub-header-record
98Sub-trailer-record
99Trailer-record
output2-
10d1
10d2
10d3
10d4
10d5
Can we do this in one step in JCL ??
- Tue May 15, 2012 7:24 pm
- Forum: FILE-AID
- Topic: FILEAID - IF ORIF , REPALL not checking all conditions
- Replies: 3
- Views: 10092
FILEAID - IF ORIF , REPALL not checking all conditions
//FILEAID1 EXEC PGM=FILEAID //SYSPRINT DD SYSOUT=* //DD01 DD DSN=input file,DISP=SHR //DD01O DSN=Output file,DISP=SHR //SYSIN DD * $$DD01 COPYALL IF=(10,EQ,C'AAAA'), ORIF=(10,EQ,C'BBBB'), REPLALL=(5,9,C'DDDD',C'EEEE') /* the problem im facing here is : Even if i give two conditional if . It is check...
- Wed Nov 09, 2011 8:08 pm
- Forum: JCL
- Topic: JCL to get only selected records from a ds --- without key
- Replies: 6
- Views: 9123
JCL to get only selected records from a ds --- without key
I have a file in which there are 20 records.
I want to extract only the 7th, 11th and 16th record.
Is it possible to get these records without any key characters in those records.
Can anyone please suggest me a JCL to do the above.
I want to extract only the 7th, 11th and 16th record.
Is it possible to get these records without any key characters in those records.
Can anyone please suggest me a JCL to do the above.
- Fri Oct 14, 2011 8:14 pm
- Forum: JCL
- Topic: Jcl to replace characters in a DS
- Replies: 4
- Views: 8059
- Thu Oct 13, 2011 10:32 pm
- Forum: JCL
- Topic: Jcl to replace characters in a DS
- Replies: 4
- Views: 8059
- Thu Oct 13, 2011 7:27 pm
- Forum: JCL
- Topic: Jcl to replace characters in a DS
- Replies: 4
- Views: 8059
Jcl to replace characters in a DS
I/p ds :
HEADERxxxx1234xxxx
xxxxx
xxxxx
xxxxx
TRAILERxxxx1234xxxx
o/p :
HEADERxxxx5678xxxx
xxxxx
xxxxx
xxxxx
TRAILERxxxx5678xxxx
can anyone pls suggest me a JCL to get the above ....
HEADERxxxx1234xxxx
xxxxx
xxxxx
xxxxx
TRAILERxxxx1234xxxx
o/p :
HEADERxxxx5678xxxx
xxxxx
xxxxx
xxxxx
TRAILERxxxx5678xxxx
can anyone pls suggest me a JCL to get the above ....
- Sat Sep 24, 2011 8:18 am
- Forum: JCL
- Topic: sorting using jcl
- Replies: 5
- Views: 8369
I receive 6 files daily . Each having around few records . The trailer of each file has the seq number and record count in different position . example : in File 1 : The Trailer record consists of : FTAXENCRCM1898520110915093313001000084137560000 from this reocrd in file1 i have to extract and displ...
- Fri Sep 23, 2011 2:36 pm
- Forum: JCL
- Topic: sorting using jcl
- Replies: 5
- Views: 8369
********************************* Top of Data ********************************** NAME OF THE FILE SEQ COUNT FILE1 9002 000123449 ............................ FILE2 9003 000971349 ............................ FILE3 9004 000999949 ............................ FILE4 9005 000976543 ........................
- Thu Sep 22, 2011 3:52 pm
- Forum: JCL
- Topic: Quality JCL to send a data set as a email
- Replies: 2
- Views: 5394
Quality JCL to send a data set as a email
Can anyone suggest a Quality JCL (simple and effiient JCL to send a results in a data set as a email) .
- Thu Sep 22, 2011 3:44 pm
- Forum: JCL
- Topic: how to merge two or more jcl jobs into one job
- Replies: 2
- Views: 5438
how to merge two or more jcl jobs into one job
i have 5 different jobs(JCLs) in 5 different ds .
i want to know the syntax and job how to merge them into one job .
so that on submitting that one merged job i should be able to run all the above 5 different jobs.
Please adivse?
i want to know the syntax and job how to merge them into one job .
so that on submitting that one merged job i should be able to run all the above 5 different jobs.
Please adivse?