Issue regarding DB2 bulk stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Locked
sirisha
Participant
Posts: 6
Joined: Wed Jun 06, 2007 4:23 am

Issue regarding DB2 bulk stage

Post by sirisha »

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 that need to be defined for Bulk stage.
sirisha.chandana
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Are you at the same site and with the same problem as recently opened in this thread? If yes, this thread should continue there as it has already been responded to.
Last edited by ArndW on Tue Aug 03, 2010 6:12 am, edited 1 time in total.
sirisha
Participant
Posts: 6
Joined: Wed Jun 06, 2007 4:23 am

Trim Problem wid Bulk stage

Post by sirisha »

Yes ArndW we r facing the same issue .
sirisha.chandana
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

<click>
-craig

"You can never have too many knives" -- Logan Nine Fingers
Locked