selecting table name with _ in the name in ODBC stage

tiozzo · Post by **tiozzo** » Thu Feb 28, 2008 1:04 pm

I'm having problem with selecting data using ODBC stage when the table name has _ in the name. I'm OK when the name is without the _. For example when I select #schema#.lpb - I get the data, but when I select #schema#.apl_policy - then I get following error
main_program: Could not check all operators because of previous error(s)
Basically, I don't get any output from the stage.

I've tried different scenarios by adding quotes.

Is this a problem with the setup or something else?

Thanks for help in advance

chulett · Post by **chulett** » Thu Feb 28, 2008 1:10 pm

What database? What drivers? I don't think I have a table name that doesn't have an underscore in it and haven't seen this problem.

tiozzo · Post by **tiozzo** » Thu Feb 28, 2008 1:16 pm

It's UDB database. The only change in my stage I make is the table name itself.

chulett · Post by **chulett** » Thu Feb 28, 2008 1:25 pm

UDB? Sorry, can't help you there.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 28, 2008 1:55 pm

DB2/UDB (universal database) - according to certain IBM sales folk I've met, the only database you'll ever need.

Check (using a different db2 client) that the table actually exists and does not need to be qualified with a different schema (owner) name.