error while using DB@ stage

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
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

error while using DB@ stage

Post by ramesh_inform »

My job looks like this...

DATASET--->DB2


HOGAN_DDA_DLY_DMND_DEP is my table.

error is as follows:

HOGAN_DDA_DLY_DMND_DEP,0: Error Idx = 12;
DB2 Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not
valid. Reason code "106". If a host variable or SQLVAR in the SQLDA is
invalid then: host variable/SQLVAR number = "19", SQLTYPE = "484", SQLLEN =
"3330", host variable/SQLVAR type = "INPUT". SQLSTATE=07002
;
sqlcode = -804;
sqlstate = 07002 [db2utils.C:221]
Execute failed [db2utils.C:245]
the runLocally() of operator [HOGAN_DDA_DLY_DMND_DEP], partition 0 of 1, processID 5,337,312 on edwddb1 failed. [api/operator_rep.C:4050]
ramesh.n.
ramesh_inform
Participant
Posts: 57
Joined: Mon Dec 03, 2007 12:43 am
Location: hyderabad

Post by ramesh_inform »

this is a a showstopper......can anyone help?[:)]
ramesh.n.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Let's see - you waited a whole minute before asking for quicker help?

What DB2 stage and options are you using? What have you checked? Do other tables have write errors? What does Google for "DB2 Reason Code 106" return? Or sqlcode -804 and SQLSTAT 07002?
Post Reply