DataStage Support Oracles DDSPTH

sankar18 · Post by **sankar18** » Tue Dec 24, 2002 4:57 am

Hi All,

Merry Christmas.

Assume I have a Date 25-OCT-2002.I require the Output as
"Twenty fifth October Two Thousand Two".Which DSFunction has to be used in DataStage to get the above output.

If I need the same result in oracle.I will use the follwing Function.

Select sysdate,to_char(sysdate,'DDSPTH FMMONTH YEAR') From dual.

Where To_Char Format mask ('DDSPTH FMMONTH YEAR') will give me desired output.

Thanks in Advance,
T Sankar & K S Rajan

chulett · Post by **chulett** » Tue Dec 24, 2002 9:24 am

As far as I know, you'll need to either write the routine yourself (if your source is not Oracle) or make use of the 'to_char' format when selecting the data from Oracle.

-craig

ray.wurlod · Post by **ray.wurlod** » Tue Dec 24, 2002 4:26 pm

In spite of Oracle users' fervent hopes, DataStage is not Oracle, and does not follow Oracle conventions.
As Craig said, given that Oracle has the facility, and DataStage can invoke that facility, why reinvent the wheel (particularly for something that is not going to be used often)?
It CAN be done in DataStage BASIC; I have a routine that outputs positive integers as their word equivalents but, again, why would you bother?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518