DSXchange

Is that different from the characterset of the source DB2 database? We are using "ccsid" on the source DB2 database How are you determining that they are wrong in the target, how exactly are you checking? Something outside of 'view data' I hope. yes we are checking outside on 'View data', ...

Thank you for Quick response Craig, The character set used in ORACLE Database is "AL32UTF8"

We have a parallel job which is taking the source data from DB2 --> Writing into a dataset --> Loading into Oracle Enterprise. The issue is special characters like "acute a", "e" are getting converted into boxes after getting inserted into ORACLE. But in the DB2, the view data sh...

Hi, i am getting the following message . * Tokens were replaced below as follows: * Pin%%V0S8P1.Column%%1 <= DSLink3.EMPNO * Pin%%V0S8P1.Column%%2 <= DSLink3.ENAME * Pin%%V0S8P1.Column%%3 <= DSLink3.JOB * Pin%%V0S8P1.Column%%4 <= DSLink3.MGR * Pin%%V0S8P1.Column%%5 <= DSLink3.HIREDATE * Pin%%V0S8P1....

Hi saravanan , i removed my table definitions and imported again then it works fine. and regarding my anther issue i could nt find anything . :( i am getting the following: * Tokens were replaced below as follows: * Pin%%V0S8P1.Column%%1 <= DSLink3.EMPNO * Pin%%V0S8P1.Column%%2 <= DSLink3.ENAME * Pi...

Hi saravanan , i removed my table definitions and imported again then it works fine. and regarding my anther issue i could nt find anything . :( i am getting the following: * Tokens were replaced below as follows: * Pin%%V0S8P1.Column%%1 <= DSLink3.EMPNO * Pin%%V0S8P1.Column%%2 <= DSLink3.ENAME * Pi...

Hi saravanan , that issue was rsolve d.My another issue is while i am using the oci9 stage as a source and a target i am getting the following error message. From previous run DataStage Job 4 Phantom 1956 Program "JOB.368353998.DT.1375338332.TRANS1": Line 62, Exception raised in GCI subrou...

arndw,


still i am trying to find trhe possible cause.

regards
qmbs.

hi arndw, i am getting the following message. From previous run DataStage Job 4 Phantom 1956 Program "JOB.368353998.DT.1375338332.TRANS1": Line 62, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage case4_oci_oci..Transformer_8 Program &...

arndw, i am not using any derivations or constrains in the transformer stage. i just load the sourceoci9 data to targetoci9 thats all. and if i not use the transformer stage between the source and targetoci9 i am getting the following warning and the job gets aborted. Attempting to Cleanup after ABO...

thank q arndw.


My another issue is while i load data from oci9stage to oci 9stage it give the following error message.

Attempting to Cleanup after ABORT raised in stage case4_oci_oci..Transformer_2
pls help me to resolve.

regards
qmbs

Hi, i have a problem while using the odbc stage.My problem is, I am using odbc as a source and target also an odbc. when i load an emp table from source to target, in the target table the ename column and job colum no data is present insted of the data ???????? is available in the two colums columns...