Sripping Null Char in DB2
Posted: Wed Jul 25, 2007 12:14 pm
Hi all,
The APT_STRING_PADCHAR has been initially set to 0x00 and when data is loaded to DB2, DB2EE stage has padded weird boxes for each Char field.
![Image](http://www.uploadgeek.com/uploads123/2/NullChar.JPG)
We have changed the value to 0x20. But we need to correct existing data. Can any one of you suggest an option (may be SQL or DataStage) to trim these the charecters without reprocessing data.
The APT_STRING_PADCHAR has been initially set to 0x00 and when data is loaded to DB2, DB2EE stage has padded weird boxes for each Char field.
We have changed the value to 0x20. But we need to correct existing data. Can any one of you suggest an option (may be SQL or DataStage) to trim these the charecters without reprocessing data.