DSkkk wrote:Hi Sam..
There is one possible reason for the Low values. When u put a varchar field into a Char(N) Field, then EE Stage by default appends the remaning length with Lower values.
Kiran.
Hi Kiran,
My source fields are not only VARCHAR but also integer and others and this logic will not work if it is integer.
What if you view the file from unix using vi <filename> or
cat -e <filename>?
Are the dots comming up?
Was your requirement to convert space into to null charcters?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
kumar_s wrote:What if you view the file from unix using vi <filename> or
cat -e <filename>?
Are the dots comming up?
Was your requirement to convert space into to null charcters?
Hi Kumar
When i am doing the cat -e <filename>, i am getting ^@ symbols.I need to convert this to space.
on second thought ^@ is control character for NULL. Convert null to some value like space.
You know what, easiest way. Perform a sed operation on it and replace the nulls with a pipe instead of a space so that you can actually see that it did get converted.
Something like
Got that from a previous post. But the sed command there just gets rid of all the non-printable characters. But the command above has been tweaked to replace the non-printable characters with a space.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
^@ is a representation of 0x00 (the ASCII NUL character). You could trim these, you could set APT_PAD_CHARACTER to space (" "), you could pre-process with sed or awk as DSGuru2B suggests.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.