Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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



I have DATE filed like DD-MM-YYYY, So I want output should be MM/DD/YYYY using JCL? Can anybody..

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

I have DATE filed like DD-MM-YYYY, So I want output should be MM/DD/YYYY using JCL? Can anybody..

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

I have DATE filed like DD-MM-YYYY, So I want output should be MM/DD/YYYY using JCL? Can anybody..

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

I have DATE filed like DD-MM-YYYY, So I want output should be MM/DD/YYYY using JCL? Can anybody..

Answer / raghuvanshi

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

Post New Answer

More JCL Interview Questions

what is the Difference between SYSIN and PARM ?

5 Answers   IBM,


What is a Dummy Utility and what it does ?

3 Answers  


What are the rules employed while naming the steps in a job?

0 Answers  


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 ?

1 Answers   IBM,


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.

0 Answers  


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???

10 Answers   Perot Systems,


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

0 Answers  


Can we DELETE all the Generations of a GDG at once, WITHOUT deleting the GDG itself ?

7 Answers   IBM,


mainframe questions like basic&depth

0 Answers   TetraSoft,


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?

0 Answers  


Name some of the JCL statements that are not allowed in procs.?

1 Answers  


A job has 150 steps i want to execute only 57th step

3 Answers   Cognizant,


Categories