I have two input SORTIN files and We need to create one
SORTOUT file which contains data of both input files. What
is the SortCard for this?. Suppose the length of the both
files are different, then How we do it? Please reply ASAP
Answers were Sorted based on User's Feedback
Answer / srk
//jobname job .......
//stepname1 exec pgm=sort
//sysprint dd sysout=*
//sortin01 dd dsn=file1,disp=shr
//sortin02 dd dsn=file2,disp=shr
//sortout dd dsn=mergefile,.......
//sysout dd sysout=*
//sysin dd *
merge fields=(starting field,length,merge-sequence,format)
/*
*above is the merge condition
//
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / vikas pujar
1) Sortcard to merge two files will be
//Sysin dd *
Sort fields=copy
/*
2) When try two merge two files using sort, first thing to see is they are of same length. If they are not, change the length of one equal to other in one more step which come prior to sort step.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vikas pujar
Continuation to last answer. If the input files are of VB, even if length vary, files will be merged. The file with Max
RECFM and BLKSIZE will be used for output. But for FB files RECFM should be same.
| Is This Answer Correct ? | 2 Yes | 2 No |
What are the utility programs in jcl?
I have Job A and Job B. I want to trigger Job B from Job A. Please advise.
How to pass data to a program that is coded in an exec statement?
A job has 90 steps i want to execute only step7 and step15
What statement marks the beginning of a job step; assigns a name to the step; identifies the program or catalogued or in-stream procedure to be executed in the step?
How can i execute 5th step without executing first 4 steps?
mainframe questions like basic&depth
What are s0c1, s0c4, s0c5, s0c7 and socb?
can any one plzzzzzz tell the jcl code for creating ps using idcams
What is the purpose of include statement in a JCL?
What is a GDG? How is it referenced? How is it defined? What is a MODELDSCB?
Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.