Bulk Load with DB2 connector

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

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Are you certain your target field is 4 characters? I'll wager it's actually 4 bytes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What you posted doesn't answer the question. I don't know DB2 syntax but Oracle supports both byte and character 'semantics' so saying VARCHAR(25) isn't the whole story. It can mean either 25 characters or 25 bytes depending on the semantics setting. Perhaps something similar is happening in DB2. I'd suggest you double-check with your DBA to verify this, one way or the other.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
harikhk
Participant
Posts: 64
Joined: Tue Jun 04, 2013 11:36 am

Post by harikhk »

Thanks Craig,
I need to verify this on my own as I do not have a dedicated DBA currently
Will post my findings
Thanks,
HK
*Go GREEN..Save Earth*
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”