Conference orarep::nomahs::dbintegrator_public_public

1157.0. "SYS$TEST:LDB2$IVP.COM vs /USER sql$database" by ORAREP::NYOSS1::TJIONAS (OK=<�la Kal�>[Gk]=All Correct) Fri Apr 18 1997 16:34

Alpha  Rdb 6.0-16 DB2 Gateway 3.1

I looked in SYS$TEST:LDB2$IVP.COM the section that attempts to run
SQL with SQL$DATABASE defined as a /user logical and I see it gives
some trouble. This may be an SQL problem but LDB2$IVP.COM should
probably take notice of it not alter it to use /process logical.

Here it is with a string defined.

.....//.....
$ define sql$database "/TYPE=DB2/USER=VIDA/PASS=VIDA/NODE=PDCST/TIDCS=DEC2/TABLES=AQDEV.*/LOGON_MODE=DECLU62/ACCESS_NAME=VIDA"
$   sql :== $sql$
$   !
$   sql
set verify
show tables
exit
$
.....//.....

The problem:
------------

SQL fails to translate the SQL$DATABASE logical when this is define as
/user mode and gives the following errors.

%SQL-F-ERRATTDEF, Could not use database file specified by SQL$DATABASE
-RDB-E-BAD_DB_FORMAT, SQL$DATABASE does not reference a database known to Rdb
-RMS-E-FNF, file not found

If the SQL$DATABASE logical is other than user mode e.g. /process SQL
can translate it. It seems to me that since /user logicals are for the
the duration of one image this should actually fail because entering
SQL we are actually entering a new image and the /user logical should
not be seen. I guess SQL is right and SYS$TEST:LDB2$IVP.COM is wrong.


Same behavor on a VAX. Is there anything I am missing?

George