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
StringToDate function
Moderators: chulett, rschirm, roy
StringToDate function
Edited by Mike3000
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.