> When your connecting to an RDBMS, you'll pass a database(url),userid
> and pasword to the connection of JDBC. For oracle an SQL-server thats
> no problem. We make a database on the server and give it a USER,
> password specific for that database. When where coding the SQL the
> databasename is not required as a prefix of the tablename. So no
> problem.
> When i connect to DB2 on OS390 via db2-connect i have to give
> databasename which is the same as the OS390 system-name. All our views
> will be created as YIPYIP.tablename . The tables are created with
> SQLID set to TB1 (Systemname) a create "tablename". In COBOL os390 whe
> don't prefix the views in the dml. In the plan where using is the
> SQLID set to YIPYIP.
> DB2-connect connects through DDF to DB2. A virtual plan is used
> (DISTSERV). It is not in the plantable. I want DISTSERV to use SQLID
> 'YIPYIP' so that i don't have to prefix the views wich i refer to via
> JDBC. Or better let DDF use my own specific (DDF/JDBC) plan. The same
> as DISTSERV (whatever it may contain??) but with my extension.
> When I don't prefix the view in my code, the given userid will be used
> for prefixing. But that means that i have to make a userid on the
> mainframe wich is called YIPYIP.

> A solution would be that i prefix the views in my coding depending if
> i'm connecting to DB2 or the other DBMS'es. But i want my JAVA-code
> clean and not dbms-specific.
> Does anyone know a other/better solution ?

> Thanks in advance,
> Pierre.

> When your connecting to an RDBMS, you'll pass a database(url),userid
> and pasword to the connection of JDBC. For oracle an SQL-server thats
> no problem. We make a database on the server and give it a USER,
> password specific for that database. When where coding the SQL the
> databasename is not required as a prefix of the tablename. So no
> problem.
> When i connect to DB2 on OS390 via db2-connect i have to give
> databasename which is the same as the OS390 system-name. All our views
> will be created as YIPYIP.tablename . The tables are created with
> SQLID set to TB1 (Systemname) a create "tablename". In COBOL os390 whe
> don't prefix the views in the dml. In the plan where using is the
> SQLID set to YIPYIP.
> DB2-connect connects through DDF to DB2. A virtual plan is used
> (DISTSERV). It is not in the plantable. I want DISTSERV to use SQLID
> 'YIPYIP' so that i don't have to prefix the views wich i refer to via
> JDBC. Or better let DDF use my own specific (DDF/JDBC) plan. The same
> as DISTSERV (whatever it may contain??) but with my extension.
> When I don't prefix the view in my code, the given userid will be used
> for prefixing. But that means that i have to make a userid on the
> mainframe wich is called YIPYIP.

> A solution would be that i prefix the views in my coding depending if
> i'm connecting to DB2 or the other DBMS'es. But i want my JAVA-code
> clean and not dbms-specific.
> Does anyone know a other/better solution ?

> Thanks in advance,
> Pierre.

> Not sure it this will help but here it goes.

> I know that in the CCA (client side, Client configuration assistant)
> you can set odbc/cli variables. (jdbc is over odbc if i remember
correctly)
> CURRENTSQLID (set current sqlid)
> DBNAME (specifies the db name)
> may be of interest here.

> PM