DSXchange

Thanks Ray for the quick reply.. We manually exported/imported the .dsx from SUN Solaris/DS 7.5.1 to AIX/DS 7.5.3. We have all the necessary Config Files created on the new AIX server and the other code is working fine. This was the only job which has a Basic Transformer with a server routine in it ...

I have a Job Design which was migrated from SUN Solaris/DS 7.5.1 to AIX/DS 7.5.3 Job Design is as below: ORacle-Transformer(4 Links Coming out) ----Funnel---Seq File In the Transformer i have a Server Routine which had 4 arguments..job name, table name, source name and file name Here we capture the ...

Hi , When I am executing the parallel routine I am getting below error..can some one help me to fix this error.. Transformer_1: Failed to load the library "V0S1_jbTestPralleRoutine_Transformer_1.o"; either the directory containing the library file is not on the library search path, or the...

It may depend on what is being used in the External Source Stage...sounds like a program to bring in the file is being used, as opposed to "ls" (unix list). Bottom line --- the "safe" bet is to use ls and send just the filename into the XMLInput Stage. Then there will be no EOL ...

ray.wurlod wrote:We don't even bother trying to diagnose errors from APTCombinedOperatorController. ...

If you have a Timestamp feild, which you might be reading as a String.
And you are not using StringToTimestamp conversion function.
Please check your data and use the Conversion function.

What do the jobs that do not run have in common? What is different between them and the ones that do work without error? ... The jobs which are running and which are not running are: Oracle Read | ORACLE Read -lookup-- Oracle Write All the parameters in jobs are same. The Params are: DATABASE NAME ...

What do the jobs that do not run have in common? What is different between them and the ones that do work without error? ... The jobs which are running and which are not running are: Oracle Read | ORACLE Read -lookup-- Oracle Write All the parameters in jobs are same. The Params are: DATABASE NAME ...

The name of the stage appear to imply a "Read" rather than "Write". Is this different from your previous query? Can you post the SQL. Sorry my Mistake. Update Query is : UPDATE ITEM SET COST_A = ORCHESTRATE.COST_A WHERE (ITEM_I = ORCHESTRATE.ITEM_I). The same works in 7.5.1/Sun ...

While Exporting the Job, You can check Job Executables and select the job from the list. Once you import, you will see the job in compiled state.

The name of the stage appear to imply a "Read" rather than "Write". Is this different from your previous query? Can you post the SQL. Sorry my Mistake. Update Query is : UPDATE ITEM SET COST_A = ORCHESTRATE.COST_A WHERE (ITEM_I = ORCHESTRATE.ITEM_I). The same works in 7.5.1/Sun ...

The message is telling you that it is unable to INSERT. Check your update action property. ... Hi Ray, Is it possible that, we are not able to insert or update a record to a Oracle Database on AIX box due to NLS setting. My Oracle database NLS is US7ASCII. What should be NLS setting in my jobs. Do ...

The message is telling you that it is unable to INSERT. Check your update action property. ... Hi Ray, Is it possible that, we are not able to insert or update a record to a Oracle Database on AIX box due to NLS setting. My Oracle database NLS is US7ASCII. What should be NLS setting in my jobs. Do ...

What happens when you try to insert the records? Did you check if there is a record in the table with the same keys as the update record? Yes, the record is already existing. We just update the updt_ts field with the latest date based on the key column which is item_i. I tried for inserts and even ...

Hi, We are currently on migrating Datastage jobs(7.5.1) from Sun Solaris to AIX box. We migrated few jobs and testing them. We have a simple job with Dataset--Transformer-OCI I am not able to insert/update any record to the Database(oracle). Error: Unable to use a record for update. Operator termina...

HI All, I have a date field coming from source file which has values like: 2/28/2009 8:03 PM Mchen 2/28/2009 8:03 PM Philip Law My target is a DB2 Database which is TimeStamp value. I have searched the forum. Tried IsValid, Left, Right, Field, StringToTimeStamp but unable to convert the value to a T...