Problem:
Cannot connect to database configuring TDI JDBC connector. Getting CTGDIJ037E error or SQLCODE=-204, SQLSTATE=42704 (which means 'no such table').
Here's an example:
or another one:Answer:
Both errors mean 'Wrong schema name'. Let's see. Username is LCUSER. Then default schema name is LCUSER. But my actual schema name is EMPINST. That means I should specify my schema name somewhere. In second case I tried to give it in a table name field but that didn't work. I also cannot do it using connection string. But lower there's a field for Extra Provider Paramaters. There I point real schema name like this:
and press Connect. The problem is solved.


