Hi,
In seqential file ....Edit columm metadata there is a property called Nullable what length and value I have to give for Null field length and Null field value . I am writing to a sequential file with columms that contain decimal(7,4) length and some records have null value so to catch null values with out warning can I use Null field value and Null field length in sequential file . If so what are the values I need to provide for those two properties. Plz help me
Thanks,
Somaraju.
Edit columm metadata in Sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Null field value must be precisely the same length as non-null data if the file is fixed-width format. Null field length allows you to specify how long the representation of null is in a variable-width format column. I believe they are mutually incompatible. Click on Help with the Edit Column Metadata dialog open and you will be able to ascertain more.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Fixed-width or delimited format?
If it's delimited format, null value can be anything you like.
If it's fixed-width format, null value can be anything you like provided it's the correct length (for example "#######" is seven characters long), in which case you don't need to set the null field length property. Or it can start in the start position of that column and be exactly the number of characters indicated by the null field length property.
You should have been able to abstract that information from the Help.
If it's delimited format, null value can be anything you like.
If it's fixed-width format, null value can be anything you like provided it's the correct length (for example "#######" is seven characters long), in which case you don't need to set the null field length property. Or it can start in the start position of that column and be exactly the number of characters indicated by the null field length property.
You should have been able to abstract that information from the Help.
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.
-
- Participant
- Posts: 107
- Joined: Wed Sep 29, 2004 10:15 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The precise length is the width of the column in which the decimal number is stored. This can be ascertained using the Edit Row capability in the Columns grid. It is stored as the Display Width for that column.
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.