sql default schema

Hello,

when using embedded SQL in JVM-Cobol I do have the problem that most of the existing Cobolsources (> 8000) do not have the "FullQualified"  Tablename in the FROM Clause of their SQL-Statements.

With "native" Cobol it takes the username as the default Schema Qualifier. And if this is not sufficent it is possible to set QUALIFIER (as an SQL-Compiler Option).

This is not working with managed Cobol anymore. 

I do want to avoid the need to change all SQL-Statements to fully qualify the tablename. 

Does anybody have the same problem and if yes .... maybe a solution ?

Kind regards

Michael

Parents
  • I have tested this with pure Java using the following Connection. Same Results. I do have to specify test.<tablename> in Cobol.

    public void setUp() throws Exception {

    Class.forName("com.ibm.db2.jcc.DB2Driver");
    connection = DriverManager.getConnection(
    "jdbc:db2://dbserver:50003/vvst1:currentSchema=test;", "user",
    "passwordt");

    }

    Can you provide me with your test sources. To perform some further tests.

Reply
  • I have tested this with pure Java using the following Connection. Same Results. I do have to specify test.<tablename> in Cobol.

    public void setUp() throws Exception {

    Class.forName("com.ibm.db2.jcc.DB2Driver");
    connection = DriverManager.getConnection(
    "jdbc:db2://dbserver:50003/vvst1:currentSchema=test;", "user",
    "passwordt");

    }

    Can you provide me with your test sources. To perform some further tests.

Children
No Data