DSXchange

Thanks, all. Decided on a work-around.
IConv(Input.TRANS_DT,'D/mdY[2,2,4]') for the transform, and then a stored procedure to write it in the proper format.

Much appreciation to all who responded.
Thanks
john

[quote="Sainath.Srinivasan"]Small correction, it must be OConv(IConv(YourDate, 'D/MDY[2,2,4]'), 'D-DMY[2,A3,4]') (for a 4 digit year part as given in the example)[/quote] How very odd ! javascript:emoticon(':?') Confused I edited the transform, saved, recompiled, ran this, (and this I cut ...

[quote="ketfos"]Hi, As mentioned earlier OConv(IConv(YourDate, 'D/MDY[2,2,2]'), 'D-MDY[2,A3,4]') the above routine returns date as 02/09/2005 if YourDate = 02092005 Ketfos[/quote] Thanks for the response...fyi...I tried your idea before I sent my question, and I retried it....I just cut an...

[quote="ray.wurlod"]If it's accepting Date() then it appears that the stage is expecting a date in DataStage internal format. Try using just the Iconv(), omitting the Oconv() from your derivation.[/quote] Greetings, all. Ray, your suggestion to drop the Oconv() solved my problem as well. I...

[quote="throbinson"]p_date = passed date OCONV(ICONV(p_date,"D-DMY[2,3,2]"),"D/MDY[2,2,4]")[/quote] Greetings, throbinson I would appreciate your feedback on a similar situation I encountered to the issue from Bobby. I thank you in advance for any advice you may provide...

[quote="ray.wurlod"]You are trying to load the entire folder contents into a single text file. Is this text file in the folder in question? (Eek!!) Try [b]FolderStage > TransformerStage > OraOciStage [/b]as a preferred design. This is what I mean earlier when I suggested that you "los...