Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: yadutektips
- Order by date
-
CurrentSchema in db2cli.ini file
THere is no other table with the same name in other schemas. What I cannont understand from the event monitor output is that the query is executed twice. In the first instance, the SQLCODe and sqlstate both are zeros. As there is only one row in the table, I presume, the SQLCODE 100 is...- yadutektips
- Post #7
- Forum: IBM: DB2
-
CurrentSchema in db2cli.ini file
Juliane, I've tried setting it up from the GUI as well. I tried with both SQLID and CLISCHEMA as well but the response remains the same. I tried running a trace on ODBC. Nothing was generated from the trace. I had an event monitor running on the data and I'm pasting the contents below...- yadutektips
- Post #5
- Forum: IBM: DB2
-
CurrentSchema in db2cli.ini file
when i remove the schema name from the ini file, i get an exception in my code as in windows odbc, the schema will be defaulted to the user id.- yadutektips
- Post #3
- Forum: IBM: DB2
-
CurrentSchema in db2cli.ini file
Hi, I'm trying to query a table from my message broker. As the schemas are different, Earlier, without the schema name, I was getting exceptions by my message flow. To avoid this, I had to hard code the schema name in my code. In order to avoid the hard coding, I added the CurrentSchema...- yadutektips
- Thread
- Replies: 7
- Forum: IBM: DB2
