"DSD.BCIPut call to SQLExecute failed"

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
venki
Participant
Posts: 35
Joined: Wed Feb 28, 2007 5:09 am
Location: mumbai,

"DSD.BCIPut call to SQLExecute failed"

Post by venki »

Hi All,
While loading data from Sequential file to RACE AS/200 Tables using ODBC we get warnings for each row. Source file is fixed width file (Source and target is having inly one Column). The error message is

EP_lodins_popf0027and0102..MapToPopf0027DbTgt.Popf0027DbTgt: DSD.BCIPut call to SQLExecute failed.
SQL statement:INSERT INTO RAC56031.POPF0027(RECORD) VALUES (?)
SQLSTATE=S1000, DBMS.CODE=-7008
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]POPF0027 in RAC56031 not valid for operation.

RECORD = "H 20070816"

Can someone help with this problem
venki
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What is your 'work around'? :?
-craig

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