Client version installed on DS-Server is 8.1.7.0.0
I've tried using a transformer between oracle stages. same prob.
and I've reported to Ascential.
They have reproduced the scenario, But it has been almost a week, and no further updates.
Search found 3 matches
- Thu Aug 05, 2004 2:00 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01461: if there is more than 1 VARCHAR2(2000) field
- Replies: 10
- Views: 9162
- Wed Aug 04, 2004 3:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01461: if there is more than 1 VARCHAR2(2000) field
- Replies: 10
- Views: 9162
Re: ORA-01461: if there is more than 1 VARCHAR2(2000) field
table defintion for both source and target tables are the same: e..g CREATE TABLE test1_ALL ( LINE_ID NUMBER NOT NULL, HEADER_ID NUMBER NOT NULL, SHIPPING_INSTRUCTIONS VARCHAR2(2000 ), PACKING_INSTRUCTIONS VARCHAR2(2000 ) ) in DS job, the 2 fields are defined as SQLType=VARCHAR Length=2000 I've tri...
- Tue Aug 03, 2004 3:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-01461: if there is more than 1 VARCHAR2(2000) field
- Replies: 10
- Views: 9162
ORA-01461: if there is more than 1 VARCHAR2(2000) field
Hi I've a datastage job Loading directly from Oracle to Oracle. Source DB: Oracle8i Enterprise Edition Release 8.1.7.4.0 Target DB: Oracle9i Enterprise Edition Release 9.2.0.1.0 Problem encountered: The job fails with the following error if target table has more than 1 field with VARCHAR2(2000), OR...