getting warnings when i am inserting records.

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
sreddy
Participant
Posts: 144
Joined: Sun Oct 21, 2007 9:13 am

getting warnings when i am inserting records.

Post by sreddy »

Hi

The existing job is designed like this. Force source sequential files are club using Funel stage and insert in to target table.

it is through warnings. That is why i was modifed the jobs after Funel stage
i used change capture and insert the records to the target table.

Sequential files -- Funel stage -- change capture -- Transformer -- DB2 target table.

Now i am getting the warning like this.

Copy_of_DB2_LOAD_SRK,0: Warning: CopyOfRNESD18L.DB2_LOAD_SRK: UNIQUE_ID_VAL = 207341_6_10_2008-07-31_1_1_NS_NULL_NULL_NULL_NULL_NULL_NULL TBL_SRKEY = 1430854 TBL_NM = TN1ODAPD SRC_SYS = EFF_DTE = 8-09-18 END_DTE = NULL
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

That definitely cannot be the complete unedited message.

Post in full.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Right, that's your problem row not your actual problem which will be logged separately. Post your problem.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply