DSXchange

The issue with the above error in the job is related to Oracle connector issue, Contacted IBM reagarding this issue and installed the patch. I ran the job and the job finished successfully.

PROBLEM: JR35357 The latest patch for Oracle connector.

How about checking in the Director.

thanks Kunal ....I am glad you found the solution.

source ACD_ID( NULL) TARGET ACD_ID( NULL)

In datastage it should say YES on both source and target ................. not NO

"ACT_ID" to field "ACT_ID": Implicit conversion from source type "decimal[38,10]" to result type "string[12]": Not enough room in string for decimal[38,10]. >##E TFSR 000019 10:24:43(002) <main_program> Could not check all operators because of previous error(...

error says you have a null in the source. and target is not nullable.

source ACT_ID(NULL) Target ACT_ID(Not Null)

It seems you have decimal(38,10) in Datastage though your
source is char(12)

also you have a null in the source but your target appers to be NOT NULL , so you have to make it null
check datatypes you defined in the source stage and target stage in datastage.

try using Varchar in the source, it looks like you specified your source as decimal and target is varchar.... try changing the source to varchar and target as varchar.

has any one come across this error .?


Thanks.

Screen shot of the job http://picasaweb.google.com/kbsuryadev/OracleConnector_ERROR# Oracle connector: partioned reads ( ENABLED) on table a partioned read method: Rowid hash Custom sql: joining 2 tables( one of which is temp table) transformer: No transformations. target: dataset and creating a tab...

it says your target column is not nullable, so make it null and try

source>>>>>>trn( in transformer UPCASE(INDEX(Inputcolumn,'string',1))<>0 Then _________ else ______________ ) and then do a look up on the source row.

use upcase depending on your requirement.

Check the INDEX function in DataStage

You can read a non partioned table in parallel using Oracle Connector Stage, by chosing the option enable parallel read- option and chosing the partioned read method -option So when you chose Oracle connector stage it will read the oracle table in parallel depending on your node configuration. Corre...