Hi,
I have a column of length 3 of type char in a db2 table but the field contains only one aphabet. i am reading using db2 stage into a field defined as char(3) but surprisingly Datastage is not padding the spaces even if the APT_STRING_PADCHAR is set to 0x20. What is the reason behind this ? need urgent help
datastage not padding spaces in db2 stage!!urgent!!
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you need urgent help sign up with your support provider for premium service and learn just how much "urgent" costs. DSXchange is an all-volunteer site, whose members post as and when they can. Specifically, we do not "do" urgent and, indeed, react negatively when such demands are made.
Further, posting the same question more than once adds to the negativity.
Further, posting the same question more than once adds to the negativity.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
Maybe your field in the database is not just one character after all. Try a SQL on that table with HEX(colname) to see if it is already padded before datastage fetches it.
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles