Search found 3 matches

by Maxhouston
Fri Oct 02, 2015 2:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IADataRule stage - data type + max length for checked cols
Replies: 0
Views: 1880

IADataRule stage - data type + max length for checked cols

Hi all, my problems are : 1) in every job I use a IADataRule stage I have to convert the datatype of the columns from Numeric to Varchar in order to avoid a warning message that tells me that the automatic conversion could cause a possible data truncation. This happens in every job where the data ru...
by Maxhouston
Thu Nov 05, 2009 5:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Maximum sql length in OCI
Replies: 6
Views: 7619

I wonder if the following link would help ^_^
http://www-01.ibm.com/support/docview.w ... wg1JR33236
by Maxhouston
Thu Aug 27, 2009 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle SQL LOADER not working for direct path
Replies: 4
Views: 4943

Is it because we are uysing a lower version of Oracle. The datastage version is 7.5.1 and the oracle version is 8i. You have to point your attention on Oracle client versions. If your ETL Oracle client version is higher than your DATA Oracle Client version then you CAN'T load data in Direct path, c...