problem when inserting records into DB2 table
Moderators: chulett, rschirm, roy
problem when inserting records into DB2 table
Hi all,
I facing a problem when data got loaded into a DB2 table.
The job has Dataset as a source and it laods into a DB2 table. There is a column of Char datatype with 8 as length , which gets populated inthe table as 8 boxes.( i could not paste it over here).
When i viewed the data, it is neither null nor space, it was just empty. From the source, which is again a DB2 table, the value is space.
Please help me solving this issue.
I facing a problem when data got loaded into a DB2 table.
The job has Dataset as a source and it laods into a DB2 table. There is a column of Char datatype with 8 as length , which gets populated inthe table as 8 boxes.( i could not paste it over here).
When i viewed the data, it is neither null nor space, it was just empty. From the source, which is again a DB2 table, the value is space.
Please help me solving this issue.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Send it to a text file and use a hex editor to find out what the box character represents. My guess would be the character specified by APT_STRING_PADCHAR environment variable, used to pad Char fields to their correct length. In a hex editor this will probably be displayed as 00 or, in the viewable area, as ^@.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
Hex code for space is 20. Try using 0x20 instead of ' '
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>