I have DATE filed like DD-MM-YYYY, So I want output should be
MM/DD/YYYY using JCL?
Can anybody post the answer for above requirement?
Answers were Sorted based on User's Feedback
Answer / harsha
12345678910
DD-MM-YYYY
Above is the date and column numbers.
//STEP1 EXEC PGM=SORT
// .
// .
// .
OPTION COPY
OUTFILE FNAMES=SORTOUT
OUTREC=(4,2,C'/',1,2,C'/',7,4)
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / mfgan
When DD-MM-YYYY is the first field of input record,
Then use the below code,
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,2,
3:C'/',
4:4,2,
6:C'/',
7:7,4)
/*
//
When others,
Change the position numbers occordingly.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pranay
OUTREC FIELDS=(4,2,C'/',1,2,C'/',7,4)
The above Sort card is working perfectly fine for me.
Please recheck.
| Is This Answer Correct ? | 2 Yes | 0 No |
When I am using
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(4,2,C'/',1,2,C'/',7,4)
/*
//
I am getting the same output as input!
Can someone please through some light on it.
| Is This Answer Correct ? | 1 Yes | 1 No |
Explain about LMFREE�free data set from its association with data ID
i want to see the jobs in skeleton queue in diff region. (eg. 7 regions are running means , i want to see all the jobs in 7 regions which are in skel queue using 1 command)
jcl is like a complier....?
what disp parameter we mention for creation of temporary dataset so that we can use it in later steps?
In Job, there are 10 steps. If I want to execute the first 6 steps and don't want to execute from 7th to 10th step. What is the solution for this ?
Explain about LMMLIST�list a library's members
What is a GDG? Why do we go for a GDG ? utility used to create GDG?
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.
What are the 4 fields in dd statement?
by using cond parameter maximum 8 cond can be coded in single cond means ?explain
what modification we need to do in jcl if we use sort in cobol? I mean whether we need to include temporary file used for sorting in assign statement?
We have two PS files,want to compare those files and put the duplicate records in one file. Input file 1 contains(1,2,4,9,10) Input file 2 contains (1,4,5,11,12,14,16). Help me with jcl.