datastage not padding spaces in db2 stage!!urgent!!

zulfi123786 · Post by **zulfi123786** » Thu Jan 15, 2009 8:50 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Jan 15, 2009 1:25 pm

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.

stefanfrost1 · Post by **stefanfrost1** » Fri Jan 16, 2009 12:51 am

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.

miwinter · Post by **miwinter** » Sat Jan 17, 2009 12:49 am

You state you are reading from DB2. So what is your target?