Sequential File - Warning Message - Null
Posted: Wed Apr 15, 2009 1:14 pm
Hi
I had some problem while loading data into a sequential file, especially in the date fields. The DS Director log gave me lots of warning message and the job was aborting. But later i used the following environment variable and it worked, I was able to supress all the wasrning messages.
Warning message:
Sequential_File_1: When checking operator: When validating export schema: At field "DECEASED_NOTIFICATION_DATE": "null_field" length (0) must match field's fixed width (19)
Sequential_File_1: When checking operator: When validating export schema: At field "DECEASED_NOTIFICATION_DATE": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field
Fix:
use the following environment variable, (this one is not available in the DS env variable list so u need to define it in the DS admin --> user defined section and set it to true.
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL.
Thanks to Ray.
I had some problem while loading data into a sequential file, especially in the date fields. The DS Director log gave me lots of warning message and the job was aborting. But later i used the following environment variable and it worked, I was able to supress all the wasrning messages.
Warning message:
Sequential_File_1: When checking operator: When validating export schema: At field "DECEASED_NOTIFICATION_DATE": "null_field" length (0) must match field's fixed width (19)
Sequential_File_1: When checking operator: When validating export schema: At field "DECEASED_NOTIFICATION_DATE": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field
Fix:
use the following environment variable, (this one is not available in the DS env variable list so u need to define it in the DS admin --> user defined section and set it to true.
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL.
Thanks to Ray.