Sequential_File

fleurlisalu · Post by **fleurlisalu** » Fri Jul 27, 2007 9:52 am

in ODS, the field is nullable, and when i load in a sequential file,i have a warning in director:

Sequential_File_119: When checking operator: When validating export schema: At field "HORAIRE_CONTRAT": Exporting nullable field without null handling properties

i can't modify the field, because it's nullable, thank you for your answer

ray.wurlod · Post by **ray.wurlod** » Fri Jul 27, 2007 4:02 pm

Sequential files do not have data types. Export is the process of converting data to human-readable format. You need to do this when writing to a sequential file.

Because they have no data types, sequential files don't have a NULL. Therefore you have to tell it how to represent NULL. You do this through the Null Field Value property of each column (since you may want to represent NULL differently for different fields).

Bonne chance!

velayuthan · Post by **velayuthan** » Sat Jul 28, 2007 12:58 am

In the edit column metadata of the sequential file, set the Null field values= %default Values % in the Nullable Properties Panel.

This warining will be elimated.

xch2005 · Post by **xch2005** » Fri Sep 19, 2008 9:35 am

Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

xch2005 · Post by **xch2005** » Fri Sep 19, 2008 9:35 am

Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

ambasta · Post by **ambasta** » Fri Sep 19, 2008 10:14 pm

Do the null handling in column meta data ..it will remove the warning