StringToDate function

Mike3000 · Post by **Mike3000** » Wed May 30, 2007 8:10 am

Job configuration:
SeqFile->Transf->SeqFile

DSLink6.stdate is "Varchar(6)" in input-tab and "Date"
in output-tab of Transformer

In Transformer i defined variable "v_stdate" as
StringToDate(Trim(DSLink6.stdate),"%yy-%mm-%dd")
to be mapped to output "Date"-format column

i can not compile it and DS var record is in a red colour?

Could you tell me please what's wrong with my syntax?
I already spent a while, trying different syntaxes.

Thanks

DSguru2B · Post by **DSguru2B** » Wed May 30, 2007 8:14 am

StringToDate() is a parallel job function and not a server job function. Use ICONV/OCONV to get your desired result. If your date is already in YY-MM-DD format and that is what you require then leave it as it is. Server jobs are not fussy about datatypes. You can directly map a varchar to a date field.

Mike3000 · Post by **Mike3000** » Wed May 30, 2007 9:51 am

Thanks DSGuru2B, somehow i was sure that i can use it in Server Edition.
I'll use ICONV/OCONV