IASQL Files [ Information Access SQL/iX ] MPE/iX 5.0 Documentation
Information Access SQL/iX
IASQL Files
A user can enter MPE commands in a file and have them executed at the
start of an Information Access session. This file, called an IASQL file,
can be a local file residing in the user's logon group and account or a
global file residing in PPC.SYS. A global IASQL file is processed before
a local IASQL file.
Access SQL/iX software includes an IASQL file, IASQL.PPC.SYS, that
contains one command:
SETVAR ORACLE_LIB "ORACLEXL.PUB.ORACLE"
This command tells Access SQL/iX where the ORACLE library resides. If
you install ORACLE in an account other than the ORACLE account, you must
modify IASQL.PPC.SYS to reflect that account. If you delete the file,
then the default is "ORACLEXL.PUB.ORACLE".
If you are not using Information Access to retrieve ORACLE data, you can
remove this command from IASQL.PPC.SYS.
Other uses for an IASQL file are described under "Granting Privileges to
Access ORACLE Tables" and "Setting Isolation Levels" in Chapter 4.
MPE/iX 5.0 Documentation