DSXchange

Do you see spaces in your target table? What is the length defined in this table? I am getting warnings as below when inserting into Target table and job getting aborted after 50 warns. [DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-12899: value too ...

Not sure how you get extra anything in a one character field, can you be more specific as to exactly what it is you are seeing? :? Is the version of your Oracle client different in production? This is what I am seeing. I cut and paste the actual value from DS View into notepad, applied single quote...

Hi, I am getting a wierd problem here. In one of our job (which ran successfully on DEV and QA) all of a sudden Datastage started inserting extra spaces in one of the columns. The part of SQL which is brining back extra spaces ias follows : , CASE When (o2.ORG_DATE_CLOSED IS NULL or o2.ORG_DATE_CLOS...

Hello,

Has anyone used an MD5 encryption in the Datastage server routine or have done anything like this. Kindly share.

Thanks

Hello,

Has anyone used an MD5 encryption in the Datastage server routine or have done anything like this. Kindly share.

Thanks

Hi

I would appreciate your help if somebody has successfully attempted to call EJB or HTTP procedures using Datastage. What are the pre-requisites to perform this task. An example would be highly appreciated.

Many thanks in advance

wasimus

Hi,

Can anybody show me how do you define or handle ARRAYs in Datastage witha simple example.

Thanks