Ora_Xfr_seq- Date conversion

[reddysrc]

Hi All,

I am trying to convert date format 20070331 24.2xxx to YYYYMMDD getting blanks in my target seq files.

using ds7.5.2 server jobs

i am pulling data from Oracle and loading into sequential file .

tried with Oconv(Iconv( input, "D/YMD[4,2,2]","D YMD[4,2,2]")

but not seeing any dates in my target.

let me know how to make conversion.

Thanks
Chandu

[ray.wurlod]

Welcome aboard. :D

Try it with no conversion at all, and see what you get in the target file. Post that result here, then we'll offer advice.

You will probably need to apply an Iconv() function before using the Oconv() function, but exactly what form the second argument of each needs to take depends upon the format delivered from Oracle.

[chulett]

The answer depends on the datatype of the field in your job and if you are generating sql or have rolled your own.