warring while loading the data from oracle to Sequ file

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
K.A.R.PAULSON
Participant
Posts: 23
Joined: Sun Aug 01, 2004 2:33 am
Location: Dubai
Contact:

warring while loading the data from oracle to Sequ file

Post by K.A.R.PAULSON »

Hi,

While loading a data from oracle to sequential file I am getting the following error.

The error in log files as:

When checking operator: When validating export schema: At field "EMP_ID": Exporting nullable field without null handling properties

What will be the solution? Please can any one help me solve this issue?

By

Regi
richdhan
Premium Member
Premium Member
Posts: 364
Joined: Thu Feb 12, 2004 12:24 am

Post by richdhan »

Hi Regi,

Pls search the forum. This has already been dealt with.

In the sequential file stage you right click on the column and select properties. From the Grid properties select Field Properties check box and save this setting. After which you will have the field properties column. Double clicking the column you can set how nullablity can be handled for that particular field.

HTH
--Rich

Pride comes before a fall
Humiliy comes before honour
Post Reply