DSXchange

Hi,

I have a DB2 SQL Stored procedure. while executing the job its throwing the following error.

"Error occurred in call to ORPHCallActivePluginInitialize()."
How do I call the stored procedure in DataStage using the STP stage?

Thanks

Hi, i have developed a Parallel job in DataStage. Two links are going to Lookup Stage. In my job ORDER_PACK_UNIT is the main link and In_LKP_ORDER_PACK_UNIT_Ref is the reference link. It throws no error while compiling the job. During execution is throws the following error. "main_program: Data...

hi, i have created a parallel job. The job basically extracts data from an SQL database and writes it to a dataset. when i tried to run, the job aborted due to this fatal error "Parallel job reports failure (code 139)". This message appeared in the Director. Does anyone have an idea of wha...

hi all,

in my job i have to check for Isnumeric funtion for a column. but no such function avaiable in DataStage 8.0 version. is there any other way to use this function???

HI, In my job designDataSet and ODBC are the two input links to the CDC stage. New data will be coming from Dataset and Old data wil be coming from ODBC stage. CDC actually captures the changes coming onli from dataset. i want the old data also from the ODBC which i use for updating the table. Thanks.

hi all, i used a Change Data Capture Stage in my job which captures the changes from the After link. i have included one more link from ODBC stage which is a refrence link to the CDC stage. i need to capture the changes from the OBBC stage also. but i think there is no option in CDC to capture the c...

hi all,

does anybody have a routine for CHECKSUM for a parallel job and also i need to know how to use this routine in the parallel jobs.

hi, this is the output obtained from the Dataset Result First Second 0 () () 0 () () 0 () () 0 () () and the warning i viewed in the Director is After_DataSet: When checking operator: When binding output schema variable "outRec": When binding output interface field "bcol1" to fie...

hi,

i have checked the two things.
still the same is repeating.
how to view the data now in the target dataset.

hi,
when i try to view the data in Tools/DataManagement and the output from the Dataset viewer is the same as when i try to view the data from the viewdata tab in dataset stage.

record
( result: int8;
first: subrec
( );
second: subrec
( );
)

hi, as u said i have used all the output columns such as bcol1,bcol2,bcol3,bcol4(keycolumn) in the output page of compare stage. But again while viewing the data its showing the following warning. Error Executing view command: ###E IIS DSEE - topk-00007 17:34:49(008) <-PEEK_IDENT_> Input dataset doe...

I used four input columns. They are bcol1 integer,bcol2 integer, bcol3 integer, bcol4 varchar.
In the ouput page there are three columns Result varchar, First integer, Second integer.
Here bcol4 is the key column

hi all, i used compare stage in a parallel job. The job is finished and the data is moving into the target dataset. but the problem is when i try to view the data it cant view it. Its showing the following error. After_DataSet: When checking operator: When binding output schema variable "outRec...

hi all, i used compare stage in a parallel job. The job is finished and the data is moving into the target dataset. but the problem is when i try to view the data it cant view it. Its showing the following error. After_DataSet: When checking operator: When binding output schema variable "outRec...