topic Re: DB2 input OK / DB2 output KO in Talend Studio

DB2 input OK / DB2 output KO

Fernandez — Wed, 19 Sep 2018 08:40:31 GMT

Hi,

With same parameters for DB2 connection, it's OK when I use the component tDB2Input but I get an error when I use the component tDB2Output :

com.ibm.db2.jcc.am.SqlSyntaxErrorExceptionB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=idutil.DOC_OBJ, DRIVER=4.17.29

The user has access to insert into database.

I see a precedent post about this subject (https://www.talendforge.org/forum/viewtopic.php?id=2197), that indicates to put into Database field:

context.DB_Database+":currentSchema="+context.DB_Schema

But I get also an error...

Can somebody help me please ?

Thanks

Re: DB2 input OK / DB2 output KO

fdenis — Wed, 19 Sep 2018 08:57:16 GMT

it's a db2 error check your configuration.
http://www-01.ibm.com/support/docview.wss?uid=swg21613531

Re: DB2 input OK / DB2 output KO

Fernandez — Wed, 19 Sep 2018 09:31:11 GMT

Hi,

I don't think it's a problem of DB2 configuration because we don't get any issues whith the same configuration when we insert datas with another technology (for example C#).

Re: DB2 input OK / DB2 output KO

fdenis — Wed, 19 Sep 2018 09:42:23 GMT

this error is returned by ibm bd2 driver.
if you read c# you may read java an check it on debug mode.
first question are you on db2 or on an as400 db2?
did you try using an other driver ODBC or jdbc?
Regards,

Re: DB2 input OK / DB2 output KO

Fernandez — Wed, 19 Sep 2018 11:28:20 GMT

I am on db2 and I'm using IBM DB2 ODBC Driver.

As explained, when i'm using tDB2Input with same configuration, it works fine...

Regards,

Re: DB2 input OK / DB2 output KO

Anonymous — Wed, 19 Sep 2018 12:46:44 GMT

Can you show us your config for the component that does work? Also, do you actually have a table called "MyTable" in your database and does your user have access to it?

Re: DB2 input OK / DB2 output KO

fdenis — Wed, 19 Sep 2018 12:55:23 GMT

tdbInput use select queries it all time work fine.
for tDboutput it's insert and or update queries with use of parameters with sometime validation or conversion to use db charset and nls.

you can try to use tDB2row and write an insert query it will work but it's not optimized.

can you or your dba check db configuration.

Re: DB2 input OK / DB2 output KO

Fernandez — Wed, 19 Sep 2018 15:46:33 GMT

Hi,

Thanks François.

It's working fine with tDB2row:

I am not a db specialist, so for my information what do you mean with "...to use db charset and nls" ?

Re: DB2 input OK / DB2 output KO

fdenis — Wed, 19 Sep 2018 16:00:53 GMT

your db store your data.
but when the db retrieve data they are formated with nls languages
(samples: for fr date are dd/mm/yyyy for us date are mm.dd.yyyy)

when db store Strin it may be ascii UTF8 UTF16 or any ISO charset
your db is configured to store what you nead.

in our case tdbOuput use insert into tb (field1,field2) values (?,?)
then it just have to send the two parameters(represented by ?) to be inserted.
driver have to support this type of insert.

Re: DB2 input OK / DB2 output KO

fdenis — Wed, 19 Sep 2018 16:01:48 GMT

are you using insert with parameters in c#?

Re: DB2 input OK / DB2 output KO

Fernandez — Wed, 19 Sep 2018 16:27:38 GMT

I don't develop in C# but according to my colleagues, yes.