B
Brian K. Maher
Guest
Stefan, When using SQL-92 via either ODBC or JDBC you have the option of creating tables with “PUB” as the owner or with another owner. For example, if you login using Squirrel using XZY as your userid and you do a simple “CREATE TABLE FRED” the table will actually be XZY.FRED and will only be seen via the SQL-92 side. ABL based applications can only see tables that have an owner name of “PUB”. This is standard behavior and has been this way ever since SQL-92 was introduced. If you want the tables you create to be accessible by the ABL then your create statement must use the PUB. in the CREATE statement. PDS shows the tables because PDS uses a SQL-92 connection to the database. Brian
Continue reading...
Continue reading...