DSXchange

Hi William, I tried to change the input to 'YYYY-MM-DD HH:MM' format but no luck. I am liking Idea of creating a routine and then incorporate it in each job instead of putting the logic in all jobs. can you please throw some light on the custom routine or probably an example will definitely help me....

I use Netezza stage to load data into table. so bascially job loks simple as in: Seq file--> Transformer--> Netezza stage to load table. Now netezza stage doesn;t give option to change or apply some transformation while loading also the function to_timestamp() doesn't exists in Netezza. When I said ...

sorry about that,
month will be fixed <3 char> only

kwwilliams wrote:

chulett wrote:Still think it would help if you answered my questions.

Agreed that's why I stated in addition to what you were asking.

Thanks everyone for replying. some facts 1) I am getting data like this<in Date time format and not as a string> from Files and need to read the file into the Table<NETEZZA> by using datastage job. 2) I have almost 30-40 jobs where I need to read the data, 3) right now I am resding the Input data by...

HI there,
Need to change the date time Input "Jul28 2010 12:30PM" to Timestamp <without seconds format>

I have tried all functions present in Transformer but NO Luck..

Please advise.

Thanks
Ravi