а я вообще не пользуюсь такими плюшками. Легче просто явно указывать схему
при запросе.
select * from mylib1.table1
select * from mylib2.table1

Posted via ActualForum NNTP Server 1.3

а вообще, может это поможет:
Information Center
CHGCURLIB (Change Current Library) Command Description
Purpose

The Change Current Library (CHGCURLIB) command replaces the current library
entry of the library list.

Note: If the current library entry of the library list is
changed from a menu or program that has a current library associated with
it, then the current library changes are only in effect during the call
level of the menu or program from which it was changed.

Required Parameter

CURLIB
Specifies the library that replaces the current library entry in the job's
library list.
*CRTDFT: No library is the current entry of the library list. If objects
are created into the current library, the QGPL library is used as the
default.

library-name: Specify the name of the library that replaces the current
library entry in the job's library list.

Note: QTEMP cannot be specified for this parameter.

Example for CHGCURLIB

CHGCURLIB CURLIB(ULIB10)
This command changes the current library entry of the current job's library
list to contain library ULIB10.

Error messages for CHGCURLIB

*ESCAPE Messages

CPF2106
Library list not changed.
CPF2110
Library &1 not found.
CPF2113
Cannot allocate library &1.
CPF2133
First product library on library list destroyed.
CPF2134
Second product library on library list destroyed.
CPF2137
Current library on library list destroyed.
CPF2176
Library &1 damaged.
CPF2182
Not authorized to library &1

q
select * from mylib1.table1
select * from mylib2.table2

потом если нужно перед стартом программы можно переопределить mylib1.table1 и mylib2.table2 командой ovrdbf

не понял - для чего? у него таблицы под одним и тем же именем, но в разных либах находятся. Для чего делать chgcurlib или ovrdbf, если можно достучаться до них по полному имени?