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.
Sequential File - Warning Message - Null
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Sequential File - Warning Message - Null
Thanks
Karthick
Karthick
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
Ray,
Just to make sure I understood you or not.
you want me to use blank space for the null values?
for example if i have a column (creation_date) with date as data type. then in the columns tab of the sequential file stage click on the column number and go to the edit column meta data windo and in the Nullable properties specify the null field value as 19 spaces?
like Null Field value = ' '
Could you please tell, what im doing is right.
Just to make sure I understood you or not.
you want me to use blank space for the null values?
for example if i have a column (creation_date) with date as data type. then in the columns tab of the sequential file stage click on the column number and go to the edit column meta data windo and in the Nullable properties specify the null field value as 19 spaces?
like Null Field value = ' '
Could you please tell, what im doing is right.
Thanks
Karthick
Karthick
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Wrap your expression in Code tags, otherwise multiple spaces get compressed by the software. Yes, I mean that you need 19 spaces if the Field Width is 19.
Code: Select all
NullFieldValue = " "
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 151
- Joined: Fri Feb 13, 2009 4:19 pm
ray.wurlod wrote:Wrap your expression in Code tags, otherwise multiple spaces get compressed by the software. Yes, I mean that you need 19 spaces if the Field Width is 19.Code: Select all
NullFieldValue = " "
That is really awsome. Thanks Ray.
Thanks
Karthick
Karthick