Oracle_DB: "null_field" length (5) must match fiel

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
FDW_CITI
Participant
Posts: 13
Joined: Sun Aug 31, 2008 10:18 pm

Oracle_DB: "null_field" length (5) must match fiel

Post by FDW_CITI »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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

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.
Post Reply