DSXchange

Hi

Can somebody please guide me that what will be the simplest way of converting a Date from ccyy-mm-dd format to dd-mon-yy format.
For example

2006-02-12 as 12-feb-06.
It can be done in transformer, using some stage variables and if-else loop, I wish to know if there is any function or combination of functions which can make this task simple.

Thanks a lot

Regards
Ashwin

The easiest way is to let DataStage do it for you:

1) Define your input column as Character 10. Choose a date format of CCYY-MM-DD.
2) Define your output column as Character 9. Choose a date format of DD-MON-YY.
3) Move input column to output column. DataStage will do the conversion for you.

Mike

Thanks Mike, I dint know that I was gonna say no other way other than substring and if then else.
Will this solution work in other jobs like server/parallel also?

It's a mainframe job feature. Server/parallel jobs provide a much richer set of transform functionality.

Mike

Mike wrote:The easiest way is to let DataStage do it for you:

1) Define your input column as Character 10. Choose a date format of CCYY-MM-DD.
2) Define your output column as Character 9. Choose a date format of DD-MON-YY.
3) Move input column to output column. DataStage will do the conversion for you.

Mike

Hi Mike

Thanks a lot for the reply, even I thought about using this approach.
But I guess we don't have DD-MON-YY format in MVS, or is it there?

Please let me know.

Regards
Ashwin

Thanks

I got it. I hadn't changed the datatype to Character

Regards
Ashwin