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 |
what is the Difference between SYSIN and PARM ?
What is a Dummy Utility and what it does ?
What are the rules employed while naming the steps in a job?
Is there GOTO and SWITCH-CASE available in JCL ? Is IF-THEN-ELSE available in JCL also just like it is available for VSAM datasets under Model Commands category ?
My Question is 1. How to cound no. of records in JCL. Please explain with an example. 2. How to execute only odd steps in JCL? I know EDIT TYPE = Inculde, Step Name = 1,3,5 and COND code for all even step. Anyone knows other than this.
In my job I have 6 steps. Step01,02,03...step06. after executing step02 i want to skip step03 and want to execute step04. and once step04 is done then I want to go back and execute step03. once step03 is completed I want execute step05, 06 and so on... can any one tell me how do i do that???
How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you
Can we DELETE all the Generations of a GDG at once, WITHOUT deleting the GDG itself ?
mainframe questions like basic&depth
I have a job called careerride and some steps in it as step1,step2. But I want to execute step2 before step1 ? How do I do that?
Name some of the JCL statements that are not allowed in procs.?
A job has 150 steps i want to execute only 57th step