Search found 18 matches

by bhargavi_ns
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............
by bhargavi_ns
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...
by bhargavi_ns
Thu Mar 21, 2013 11:59 am
Forum: JCL
Topic: concatenate 3 input records in different ds into one record
Replies: 5
Views: 7252

I am able to do this using SAS.
But need to try using ICETOOL or SORT.
by bhargavi_ns
Thu Mar 21, 2013 11:21 am
Forum: JCL
Topic: concatenate 3 input records in different ds into one record
Replies: 5
Views: 7252

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
by bhargavi_ns
Wed Mar 13, 2013 10:28 am
Forum: JCL
Topic: Need a 1step JCL to seperate header and detail records
Replies: 3
Views: 5660

//S1 EXEC PGM=SORT //SYSUDUMP DD SYSOUT=* //SYSOUT DD SYSOUT=* //SORTIN DD DSN= input.. //SORTOF1 DD DSN= output1.. //SORTOF2 DD DSN= output2.. //SYSIN DD * SORT FIELDS=COPY OUTFIL FILES=1,INCLUDE=(1,2,SS,EQ,C'00,01,98,99') OUTFIL FILES=2,INCLUDE=(1,2,SS,EQ,C'10') /* Thanks.
by bhargavi_ns
Wed Mar 06, 2013 3:19 pm
Forum: JCL
Topic: Need a 1step JCL to seperate header and detail records
Replies: 3
Views: 5660

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 ??
by bhargavi_ns
Tue May 15, 2012 7:24 pm
Forum: FILE-AID
Topic: FILEAID - IF ORIF , REPALL not checking all conditions
Replies: 3
Views: 10087

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...
by bhargavi_ns
Wed Nov 09, 2011 8:08 pm
Forum: JCL
Topic: JCL to get only selected records from a ds --- without key
Replies: 6
Views: 9121

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.
by bhargavi_ns
Fri Oct 14, 2011 8:14 pm
Forum: JCL
Topic: Jcl to replace characters in a DS
Replies: 4
Views: 8059

All Thanks to you Frank ..
I learnt Overlay parameter :D
by bhargavi_ns
Thu Oct 13, 2011 10:32 pm
Forum: JCL
Topic: Jcl to replace characters in a DS
Replies: 4
Views: 8059

I have a dataset in which there are 5 input records .
i want to replace the characters 1234 in the header record and trailer record (topmost and bottom record) by 5678 characters , in the same position.

i want a jcl which will replace the specified characters in the approriate position.
by bhargavi_ns
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 :?: ....
by bhargavi_ns
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...
by bhargavi_ns
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 ........................
by bhargavi_ns
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) .
by bhargavi_ns
Thu Sep 22, 2011 3:44 pm
Forum: JCL
Topic: how to merge two or more jcl jobs into one job
Replies: 2
Views: 5437

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?