Hi,
can you please tell me how to handle nullable field in seq file.
when i running a job in parallel.i am getting the following warning.
Null field handling without nullable properties
Thanks for u r help in advance
How to Hnadle NUllable Field in SEQ file
Moderators: chulett, rschirm, roy
Re: How to Hnadle NUllable Field in SEQ file
You will need to find out what the biz rule for defaulting NULLs is.
THen In the Transformer stage based on the null default write a IF THEN ELSE clause as -
If NULL THEN <default value> ELSE column.
THen In the Transformer stage based on the null default write a IF THEN ELSE clause as -
If NULL THEN <default value> ELSE column.
jagadish9 wrote:Hi,
can you please tell me how to handle nullable field in seq file.
when i running a job in parallel.i am getting the following warning.
Null field handling without nullable properties
Thanks for u r help in advance
Those who throw objects at crocodiles should be asked to retreive 'em.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Go to the Columns grid and edit the extended metadata for the Nullable column. Set its Null Field Value property (in the Nullable folder). If the sequential file is fixed width then the number of characters in the Null Field Value property must exactly match the number of characters in the field itself.
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.