Hi
How to handle nulls in sequential file?
How to handle any other invalid data in Sequential file?
How to handle nulls in date in transformer?
Thanx in advance
Null handling
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
1. Specify how null is (or is to be) represented in the sequential file. If the format is fixed width, the null field value must have the same number of characters as the field's width.
2. Data that do not match the record schema can be captured on a reject link, or the row simply dropped, or the job aborted. This is configured through the Reject Mode property.
3. Make sure no function receives a null argument. Make sure that any column marked as "not nullable" does not receive a null value. Intercept null as early as possible (stage variables?) and convert to a known other value.
2. Data that do not match the record schema can be captured on a reject link, or the row simply dropped, or the job aborted. This is configured through the Reject Mode property.
3. Make sure no function receives a null argument. Make sure that any column marked as "not nullable" does not receive a null value. Intercept null as early as possible (stage variables?) and convert to a known other value.
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.