Reject file
Moderators: chulett, rschirm, roy
Reject file
Hi,
I have a job which loads data from a sequential file into a oracle table.
In the Oracle Enterprise stage,I am using the write method as upsert.
I have the option Output Reject records set to True.
I am directing the rejects into a sequential file.
I have set the Null Field value as \123 in the format column.
All the 10 columns in the sequential file are Nullable.
But i am getting a warning for a decimal column as
below
When checking operator: When validating export schema: At field "XXX": "null_field" length (1) must match field's fixed width (8)
since this is a reject file i cannot modify the Null field value for each column.
How can i get around this error.
Thanks
I have a job which loads data from a sequential file into a oracle table.
In the Oracle Enterprise stage,I am using the write method as upsert.
I have the option Output Reject records set to True.
I am directing the rejects into a sequential file.
I have set the Null Field value as \123 in the format column.
All the 10 columns in the sequential file are Nullable.
But i am getting a warning for a decimal column as
below
When checking operator: When validating export schema: At field "XXX": "null_field" length (1) must match field's fixed width (8)
since this is a reject file i cannot modify the Null field value for each column.
How can i get around this error.
Thanks
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
Do avoid this warning,I have a Reject link from the Oracle Enterprise stage which is Input into a transformer and than from the transformer I have a sequential file where the rejects are landed (where it allows me to manipulate the Null by Field value).
Is there a better way to handle Null fields in a reject link.Any other suggestions on how to do this.
Thanks
Is there a better way to handle Null fields in a reject link.Any other suggestions on how to do this.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The value that represents null must, for certain data types and for fixed-width format records, have the same number of characters as defined for the column. For example, for a date in %yyyy-%mm-%dd format (ten characters) the null-equivalent value must have ten characters, though it does not have to be a valid date. 0000-00-00 would be a suitable choice.
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.
Yes,Ray agree with you that it should have same format and size of characters or numbers to represent a null.
My question is as a Sequential file (which stores rejects from a Oracle Enterprise stage) does not allow Null field value to be edited,I am placing a transformer in between a Oracle Enterprise stage and sequential file which stores rejects(where in i am entering a Null field vale for columns which are Nullable in Oracle Enterprise stage).
I want to know if what i am doing is right.
Thanks
My question is as a Sequential file (which stores rejects from a Oracle Enterprise stage) does not allow Null field value to be edited,I am placing a transformer in between a Oracle Enterprise stage and sequential file which stores rejects(where in i am entering a Null field vale for columns which are Nullable in Oracle Enterprise stage).
I want to know if what i am doing is right.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ray, If it is a reject link from a Oracle Eneterprise stage ,it is not allowing null field value for individual column in the sequential file.It allows a Null Field value only in the Format tab of the sequential file.So I gave Null field value as " " in the format tab,but since some of the columns are dates ,some are decimals and others are characters,I am getting an error.
How do you overcome this error.
Thanks
How do you overcome this error.
Thanks
Ray, I just tried this and it seems that a sequential file hanging off a DB2 reject link does not allow editing of the field properties.
All the fields are shown in grey and seem to be read only.
I suspect the best option here is to include a transformer in the stream and perform null handling there.
All the fields are shown in grey and seem to be read only.
I suspect the best option here is to include a transformer in the stream and perform null handling there.
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA