Oracle Enterprise stage Load method

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
mc_harsha
Premium Member
Premium Member
Posts: 32
Joined: Mon Mar 06, 2006 5:44 am
Location: bangalore

Oracle Enterprise stage Load method

Post by mc_harsha »

Hi all,

Running one job with Oracle load method with following properties:
Method: Append
$APT_oracle_load_delimited = ,

Able to insert the records into the table.
I checked the control file of oracle also.

But Getting the following warnings for date and decimal columns only:
TLOHB_LGCY_ORD_HDR_BFR_IMG_T: When checking operator: When validating export schema: At field "APV_IN_DC_DT": "null_field" length (0) must match field's fixed width (10)

Please help me out if you know the solution.
Do i need to set any other environment variables.
With regards,
MCH
harshakumar mc
John Smith
Charter Member
Charter Member
Posts: 193
Joined: Tue Sep 05, 2006 8:01 pm
Location: Australia

Post by John Smith »

Check your job for the metadata (column) definitions and making sure you are not passing NULL values to the target.Your target field does not accept a null field that's being passed to it.
Post Reply