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 |
how to override PROC? please give answer in details. Please mention how to write it in JCL. Thanks in advance.
diff bw SB37,SD37,SE37 ?( bcz these 3 belongs Space related abends only)
Define concatenating?
What are the jcl procedures?
How to execute only th 15th step of JCL consisting of 50 steps?
Explain about SYSVAR
How we can code in a jcl to execute a job in a particular time and date without using any job shudular?. (Eg) i want to execute a particular job at 8 am on 01/01/2010.
Can you give the sort card to arrange the specific column in the version of GDG.
How to execute step2,step1, step3 if step1,2,3 are in order
In JCL..for TIME Parameter was specified both JOB & STEP..which one is overrides
Hi, all Suppose i have 10 step in a job (s1,s2,s3,...s10) i want to execute step9 first and then step3 and i used the DPRTY for these steps. so what will happen to other steps? Will the get executed or only these two steps get executed?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?