Nullable warning
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
But with sequential (text) files you need to specify how NULL is represented. Text files don't really have data types - they only contain text. And with fixed-width format text files, the representation of NULL must have the same number of characters as any non-null value in that particular field (subset of character positions).
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.
-
Ultramundane
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
That is a limitation of Datastage. I use a few of the bulk loader utilites directly and these can use sequential files without corrupting my data. I can use Datastage as well, but I have to change chars to varchars because it thinks my data needs to be how it needs to represent it. WRONG. I don't want to corrupt my data so that I must de-corrupt it later. A waste of computer resources.