Conversion of CCYY-DD-MM to CCYYDDMM

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ashwin141
Participant
Posts: 95
Joined: Wed Aug 24, 2005 2:26 am
Location: London, UK

Conversion of CCYY-DD-MM to CCYYDDMM

Post by ashwin141 »

Hi

I am new to this forum.

Can anbody help me with conversion of CCYY-DD-MM to CCYYDDMM.
I am tring to do this but the 0 of MM is getting truncated.

Please let me know about any soultion for this.

Thanks
Ashwin
dls
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 09, 2003 5:15 pm

Post by dls »

Try using a 'date mask' to define each field. DS390 will then generate the necessary COBOL statements to carry out the conversion.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Hi,
can readily use date to string conversion and leter to the required output.
But i couldnt get much information about
DS390 will then generate the necessary COBOL statements to carry out the conversion.
dls can you help me out???

regards
kumar
dls
Premium Member
Premium Member
Posts: 96
Joined: Tue Sep 09, 2003 5:15 pm

Post by dls »

Please confirm that you're using DS390.

Tell me about your source/target stuctures; e.g., sequential, relational, etc.

Thanks.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I think that Ashwin is using DS/390 and will understand about date masks in mainframe jobs, and that Kumar is not using DS/390 and will not.

Kumar, we're talking something like the date masks you see in parallel jobs (for example "%yyyy-%mm-%dd"). However, they are specified differently in mainframe jobs, because these have to generate COBOL rather than C.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Yes :roll:
I should have observed the job type in the post correctly.....

regards
kumar
Post Reply