DSXchange

Hi all,

Job is running fine after I have included the path name of "dscapiop.o" for the particular job alone.

Thanks for your suggestions.

Commit/Rollback Implementation for Database transaction from ETL scripts. The current implementation is not able to rollback database transactions in case there is a error in DB. we have set the 0 it is not doing the rollback. Can you guys help in solving the issue. Hi Raghu, Information provided i...

hi,

try without brackets,
length col_name =2

or else
try to handle it in source query itself.

Hi all,

Is anyone faced similar type of error.

Kindly share your views to overcome the mentioned error.

thanks in advance

Hi All, I am getting unknow error SQLCODE 536631.. the job is getting aborted after 2 million records processed whereas source query has to fetch 5 million records.. source query is fetching 5 million records when executed in db2 toad. job design is as follows., ODBC--->MODIFY--->TRF---->ODBC modify...

Hi All, I am getting unknow error SQLCODE 536631.. the job is getting aborted after 2 million records processed whereas source query has to fetch 5 million records.. source query is fetching 5 million records when executed in db2 toad. job design is as follows., ODBC--->MODIFY--->TRF---->ODBC modify...

Hi craig,

Its PivotPX stage

I had designed the sample job like

ODBC-->TRF--->PIVOT---->Dataset

the job got aborted with the same message above posted.


whereas it is successful for
ODBC-->TRF--->Dataset

Hi all, I think, I had misguided you all by the words cluster environment I am correcting it to HIGH AVAILABILITY... Also I have noticed that pivot stage seems to have problem... Tested for keeping the pivot stage and populating record to dataset -- It aborts with same warnings.. After that I tested...

Hi ray, other jobs are working fine only one particular job gets aborted(whereas the job structure like ODBC-->TRANSFORMER--->PIVOT---->MODIFY---->FILTER---->ODBC ) before the change in odbc file everything was running fine. for example odbc file was changed to virtual ip 20.300.140.73 (which will p...

Hi all, I am getting following error message(job aborts) for only one job whereas other jobs are running fine. main_program: orchgeneral: loaded orchsort: loaded orchstats: loaded main_program: PATH search failure: main_program: Error loading "@dscapiop": Could not load "dscapiop"...

Hi all,

where can i find basic transformer in parallel job palette only one transformer stage is viewed?

Is there any way to change the parallel transformer to basic transformer?

can anyone reveal this..

thanks in advance

Use a Sequential File stage to capture rejects, not a Hashed File, you could be losing records due to the 'destructive overwrite' nature of hashed files depending on the keys you've defi ... Hi chulett, all the rejected records got in the HASH FILE are inserted successfully to the same target table...

Applicable only if you are DB2 WIRE PROTOCOL or you have ISERIES to access the database.

Hi all, Can anyone give me any idea to move my files from AS/400 to unix box because for a single file i can move using ajob ftp stge->hash file, we don't want to hit as/400 box for every file we want to use .i should pull all the as/400 libraries into unix box ,so from this unix box i will import ...

Hi all, Can anyone give me any idea to move my files from AS/400 to unix box because for a single file i can move using ajob ftp stge->hash file, we don't want to hit as/400 box for every file we want to use .i should pull all the as/400 libraries into unix box ,so from this unix box i will import ...