Page 2 of 2
Posted: Thu Feb 08, 2007 4:59 pm
by us1aslam1us
As you might be aware that PX is too pricky about the Datatypes. A simple solution will be to analyze your Source file at row 90 and you will understand why this row is giving problem. It might be possible that you are passing a Empty value for that field or It is not matching with the length(26).
This might be a typo i guess:
Code: Select all
Jan 10 2007 10:30:31:246AM
should be
Jan 10 2007 10:30:31.246AM
Posted: Thu Feb 08, 2007 6:41 pm
by DSguru2B
I think the timestamp format is ok. Dont read it as timestamp. Read it as varchar. Feed it to the C routine and let it take care of the rest. Once you get it into correct format and apply StringToTimestamp() to it, it will be fine.
Again, Read it as varchar. The C routine expects a string as its input variable.
Thanks
Posted: Mon Feb 12, 2007 3:10 pm
by jherr22
Thanks, it is now working.
-- john
Posted: Mon Feb 12, 2007 3:23 pm
by ray.wurlod
Please mark thread as resolved.
Posted: Mon Feb 12, 2007 3:23 pm
by DSguru2B
Good to know. Make sure you add more comments to the routine if required. C is such a language that a few days down the road you wont know what the code is doing.
You can mark the post as Resolved now.