Hi All,
I have a fixed width input record, am using column import to split that single column into 10 columns.
If my input data is having null and empty string for some columns, will column import split those (null/emptystring) values correctly according to the length?
Please help me on this.
Thanks,
Senthil P
Column Import - Fixed width file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, provided you have specified accurately how NULL is represented in each of those fields. In fixed-width format they can not actually be empty or null - there will be something in that fixed width.
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.