DSXchange

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

This is a perennial problem of users not understanding fixed-width data.

Read the error message carefully and Search DSXchange for the solution.