Can any body resolve this ?

balu124 · Post by **balu124** » Thu Jul 26, 2007 5:58 am

Hi

My source table has one column date in the format of ddmmyyyy,I need the target table with three columns as dd ,mm,yyyy separately.

Maveric · Post by **Maveric** » Thu Jul 26, 2007 6:18 am

Give a more descriptive subject next time. Use substring function in transformer in the field derivation like Inputfield[1,2], Inputfield[3,2], Inputfield[5,4].

ray.wurlod · Post by **ray.wurlod** » Thu Jul 26, 2007 1:54 pm

Look at the date conversion functions either in the Modify stage chapter or for the Transformer stage in Appendix A in the Parallel Job Developer's Guide - there are functions for extracting date components.

rumu · Post by **rumu** » Thu Aug 16, 2007 7:04 am

Use substring function in stage variable/field level derivation for the 3 out put fileds.

abc123 · Post by **abc123** » Thu Aug 16, 2007 8:32 am

Maveric, there is no such function as InputField in Datastage 7.5.1A.
Rumu, there is no such function as substring in Datastage 7.5.1A.
Ray, from what I see in the transformer's date functions, none of them will do what he is trying to do.

It seems like this is his best option:

Left(IncomingCol,2): ' ,' : Right(Left(IncomingCol,4),2) : ',' : Right(IncomingCol,4)

Let me know what you guys think.

chulett · Post by **chulett** » Thu Aug 16, 2007 8:51 am

InputField isn't a function but a generic field name used in the example. And the square brackets *are* the substring operators in both PX and Server jobs.

You couldn't find the 'date component' functions Ray mentioned? He meant Appendix B, at least that holds the Functions in my 7.5.1A version:

MonthDayFromDate
MonthFromDate
YearFromDate

Etc.