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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is timing concept in mainframe?

1652


Explain the hierarchy levels in jcl?

1110


write a jcl to execute a job by 7:00 am on jan 20,1986?

683


is there any way to execute more than one proc in the same exec statement at the same time..?

2100


Is there any command to check wether the ps file is in sorted order?

2419






1) SORT FIELDS=(20,4,CH,D,10,3,CH,D) OUTREC FIELDS=(7:20,4,C' FUTURE ',20,2,10,3,1Z,1,9,13,7, 24,57,TRAN=LTOU,6X'FF') This example illustrates how a fixed-length input data set can be sorted and reformatted for output. The SORTIN LRECL is 80 bytes. The reformatted output records are fixed length with a record size of 103 bytes. SOLRF (the IBM-supplied default) is in effect, so unless the SORTOUT LRECL is specified or available, it will automatically be set to the reformatted record length of 103. in the above example i have some doubts that a) sort fields=(20,4,CH,D,10,3,CH,D) -what exactly it does and this fields related to output record fields or input record fields b)outrec used to refprmat the records after sorting that means could please reply me as soon as possible Thanks. Venkat

7070


Is their any limit for data sets?

693


Brief description of inline procedure of jcl.

670


What are the jcl procedures?

635


Explain the purpose of dd * statement in jcl?

628


What do you understand by the term job time – out and how can you overcome that?

593


What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?

9200


which utility is used to run a cobol-db2 program?

795


which parameter is use to declare the name of dataset in dd statement?

720


what is the JCL statement consists of?

689