Search found 2 matches

by umasatyam
Tue Sep 07, 2004 11:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connection
Replies: 5
Views: 3771

Hi,

Check the location of the orchoracle.so. It is normally located in PXEngine/lib. Change LD_LIBRARY_PATH env variable to add this path in the dsenv . Stop and restart the engine...it should work...

Alternatively add this path to the library search path applicable to all users at the OS level.
by umasatyam
Tue Sep 07, 2004 11:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp Trx in DS-PX
Replies: 1
Views: 1639

Timestamp Trx in DS-PX

I am trying to insert record into a Oracle table with Timestamp field. I have 'StringToTimestamp' function in the transformer stage to convert the Varchar data to Timestamp. Transformer is happy with the function but records not loaded to the table and job does not complain either! Job finishes succ...