DSXchange

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.

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.

Hi Ray,

If there is a Decimal(7,4) then how to provide null field length and value. Is it possible for decimal values.





Thanks,
Somaraju.

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.

Hi Ray

What would be a precise Length if i had to populate data into a sequential file which is of Fixed width format , consider if there is a Decimal(7,4).

Please guide me

Thanks in advance

RK

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.