datastage not padding spaces in db2 stage!!urgent!!
Posted: 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
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