The column PRC_MSTR_ID is char(20)
I am trying to unload some data from db2 using ikject01 util.
While doing so
I first tried with
in the output file only one byte is replaced and rest of the 19 bytes are nulls.
this gives all the 20 byte as spaces.
One of my friend suggested like
both the statement resulted in all the 20 bytes as spaces.
- My doubt is
- 1)if I give CHAR(' ') only one byte has to converted to character,but how come all the 20 bytes are converted to spaces. I asked him but he is also not aware of how this is happening.
Thanks in Advance