Hi Folks !
I have an issue with the odbc stage, when I want to upsert in a db2 table.
If I use the insert then update then I get the error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]INSERT/UPDATE INVALID; INDEX IDX44 RESTRICTS COLUMNS WITH SAME VALUES. 0000004201
Followed by this fatal error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver]Value has not been specified for parameter 21.
But If I use the update then insert then it works fine,
Any clue ?
Thanks in advance
odbc problem with DB2 cannot upsert
Moderators: chulett, rschirm, roy
Re: odbc problem with DB2 cannot upsert
Hi Kjaouhari,
Can you please share the steps you executed to setup the ODBC for DB2.
I get SMEC error when I try to bind DB2 ODBC database.
./bind19 XXXXXX(ODBC)
User Name: abcdef
Password: xxxxxx
Package creation failed!: SECMEC value not supported, check for missing user/password.
Package creation failed!: SECMEC value not supported, check for missing user/password.
Can you please share the steps you executed to setup the ODBC for DB2.
I get SMEC error when I try to bind DB2 ODBC database.
./bind19 XXXXXX(ODBC)
User Name: abcdef
Password: xxxxxx
Package creation failed!: SECMEC value not supported, check for missing user/password.
Package creation failed!: SECMEC value not supported, check for missing user/password.
kjaouhari wrote:Hi Folks !
I have an issue with the odbc stage, when I want to upsert in a db2 table.
If I use the insert then update then I get the error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]INSERT/UPDATE INVALID; INDEX IDX44 RESTRICTS COLUMNS WITH SAME VALUES. 0000004201
Followed by this fatal error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver]Value has not been specified for parameter 21.
But If I use the update then insert then it works fine,
Any clue ?
Thanks in advance
Re: odbc problem with DB2 cannot upsert
Hi Kjaouhari,
Can you please share the steps you executed to setup the ODBC for DB2.
I get SMEC error when I try to bind DB2 ODBC database.
./bind19 XXXXXX(ODBC)
User Name: abcdef
Password: xxxxxx
Package creation failed!: SECMEC value not supported, check for missing user/password.
Can you please share the steps you executed to setup the ODBC for DB2.
I get SMEC error when I try to bind DB2 ODBC database.
./bind19 XXXXXX(ODBC)
User Name: abcdef
Password: xxxxxx
Package creation failed!: SECMEC value not supported, check for missing user/password.
kjaouhari wrote:Hi Folks !
I have an issue with the odbc stage, when I want to upsert in a db2 table.
If I use the insert then update then I get the error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for OS/390 and z/OS]INSERT/UPDATE INVALID; INDEX IDX44 RESTRICTS COLUMNS WITH SAME VALUES. 0000004201
Followed by this fatal error message :
ODBC_Enterprise_108,0: [DataDirect][ODBC DB2 Wire Protocol driver]Value has not been specified for parameter 21.
But If I use the update then insert then it works fine,
Any clue ?
Thanks in advance