Edit columm metadata in Sequential file

somu_june · Post by **somu_june** » Sun Apr 16, 2006 10:56 am

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.

ray.wurlod · Post by **ray.wurlod** » Sun Apr 16, 2006 3:03 pm

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.

somu_june · Post by **somu_june** » Sun Apr 16, 2006 3:47 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 17, 2006 12:25 am

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.

rkdatastage · Post by **rkdatastage** » Mon Apr 17, 2006 1:06 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Apr 17, 2006 2:36 pm

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.