Page 1 of 1

Sequential_File

Posted: Fri Jul 27, 2007 9:52 am
by fleurlisalu
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

Posted: Fri Jul 27, 2007 4:02 pm
by ray.wurlod
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!

Posted: Sat Jul 28, 2007 12:58 am
by velayuthan
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.

Posted: Fri Sep 19, 2008 9:35 am
by xch2005
Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

Posted: Fri Sep 19, 2008 9:35 am
by xch2005
Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

Posted: Fri Sep 19, 2008 10:14 pm
by ambasta
Do the null handling in column meta data ..it will remove the warning