Search found 6 matches
- Tue Aug 03, 2010 5:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue regarding DB2 bulk stage
- Replies: 3
- Views: 1581
Trim Problem wid Bulk stage
Yes ArndW we r facing the same issue .
- Tue Aug 03, 2010 12:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting an error while using DB2 Bulk stage as target
- Replies: 4
- Views: 4322
Re: Getting an error while using DB2 Bulk stage as target
Thanks Michael .We approached our DBA and it worked .
- Mon Aug 02, 2010 11:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue regarding DB2 bulk stage
- Replies: 3
- Views: 1581
Issue regarding DB2 bulk stage
The issue is we are trimming the data in our job and our target stage is DB2 bulk stage , when data is loaded in database it is not trimmed .It is loaded with spaces for Char columns .With API stage we are able to load the data porperly .. Is there any additional property or environmental variable t...
- Thu Jul 29, 2010 12:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting an error while using DB2 Bulk stage as target
- Replies: 4
- Views: 4322
Getting an error while using DB2 Bulk stage as target
We are facing issues while using DB2 bulk stage as target stage . ERROR occurred : loading table, SQLCODE -3015 SQL3015N An SQL error "-551" occurred during processing. We are facing the above errors .Please help me in solving in this issue , if any one has faced this before .Anpther thing...
- Mon Jul 05, 2010 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Facing error while using DB2 bulk load stage .
- Replies: 1
- Views: 1000
Facing error while using DB2 bulk load stage .
we r facing an error regarding db2 bulk stage Error occurred while opening command file .It runs fine for first intial set of jobs .Then suddenly we face this error and all the jobs in the sequence starts aborting with same above mentioned error .Did any one face this error before while using the DB...
- Mon Sep 17, 2007 4:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: fatal error
- Replies: 8
- Views: 2985
fatal error
The call to sqlldr failed; the return code = 256;
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,
please see the loader logfile: /opt/product/Ascential/DataStage/OnePercent/Scratch/ora.8497.14949d.2.log for details.,