I have a simple job contain only one Dataset stage and one Sequential File stage, what I want to do is DS --> SF. And I would like to make this job reuseable for all file layout. So I use the "Schema File" property to setup the schema in Sequential File stage.
However, there is no null field handling in Sequential File stage because of no specific column was loaded, when the input Dataset has null value, then the sequential file stage will reject all the records that with null value.
How to solve the problem ? Can we specify the null field handling within Schema File ?
Thanks in advance !
Null field handling within Schema file ?
Moderators: chulett, rschirm, roy
Hi,
You can try solving this in the sequential file's stage configuration.
this was covered extensivly please search this forum.
IHTH,
You can try solving this in the sequential file's stage configuration.
this was covered extensivly please search this forum.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The word "nullable" would be a good start.
Code: Select all
record
(
lastname: string[max=16];
middlename: nullable string[max=16];
firstname: string[max=16];
)
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.
That means "Null Field Value" can be setup within Schema file ? If yes, that is great.
I got the answer.
I got the answer.
Code: Select all
record
(
lastname: string[16];
middlename: nullable string[3] {null_field='\xFF\xFF\xFF'};
firstname: string[16];
)
ray.wurlod wrote:The word "nullable" would be a good start.Code: Select all
record ( lastname: string[max=16]; middlename: nullable string[max=16]; firstname: string[max=16]; )
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: