Do you know how to do odi put double quotation marks on the owner or tables / fields?
I have an Owner called Abc-tes [/ u], and at the time of the temporary tables, it gives an error.
CREATE TABLE abc-tes.tabelax
CREATE TABLE "abc-tes".tabelax
CREATE TABLE abc-tes.tabelax
CREATE TABLE "abc-tes".tabelax
%CATALOG.%SCHEMA.%OBJECT
"%CATALOG".%SCHEMA.%OBJECT
create table "newgraph-tst".dbo.C$_0TESTE_ODI_COMPK
(
C1_NUM INT NULL,
C2_FIRSTNAME VARCHAR(20) NULL
)
readTrg = stmtTrg.executeQuery("select * from "newgraph-tst".dbo.I$_TESTE_ODI_COMPK where 1=2") '))
Users browsing this forum: No registered users and 4 guests