We are using the schema file as below:
record
{record_delim ='
', final_delim=none, delim=none}
(
CTL1:nullable int32 {width=2, null_field=' '};
CTL2:nullable int32 {width=4, null_field=' '};
CTL3:nullable int32 {width=4, null_field=' '};
CTL4:nullable int32 {width=4, null_field=' '};
}
While reading there is no issue. But when writing into the Oracle DB the below warning is appearing.
Oralce_DB: When checking operator: When validating export schema: At field "FIELD_NAME": "null_field" length (5) must match field's fixed width (4)
There is no issue in loading data.
Regards,
Manju
Oracle_DB: "null_field" length (5) must match fiel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
This is a perennial problem of users not understanding fixed-width data.
Read the error message carefully and Search DSXchange for the solution.
Read the error message carefully and Search DSXchange for the solution.
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.