Search found 6 matches

by sirisha
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 .
by sirisha
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...
by sirisha
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...
by sirisha
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...
by sirisha
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.,