HP 3000 Manuals

Invoking ISQL [ ALLBASE/ISQL Reference Manual ] MPE/iX 5.0 Documentation


ALLBASE/ISQL Reference Manual

Invoking ISQL 

You invoke ISQL by issuing the following command:

     : RUN ISQL.PUB.SYS 

You can also invoke ISQL by using the ISQL UDC:

     : ISQL [ProfileFileName] [,SynonymFileName] 

The profile and synonym files are described further under "Using ISQL
Files and Buffers." ISQL displays a banner followed by an input prompt. 

      IIIIIIII    SSSSSSSS     QQQQQQQ      LL
         II      SS           QQ     QQ     LL
         II      SS           QQ     QQ     LL
         II        SSSSSS     QQ     QQ     LL
         II              SS   QQ     QQ     LL
         II              SS   QQ     QQ     LL
      IIIIIIII    SSSSSSS       QQQQQQ QQ   LLLLLLLLL
     [REV BEG]
      MON, JAN 13, 1992,  9:55 AM
     HP36216-02A.F0.00          Interactive SQL/3000         ALLBASE/SQL
     (C)COPYRIGHT HEWLETT-PACKARD CO. 1982,1983,1984,1985,1986,1987,1988,
     1989,1990,1991,1992. ALL RIGHTS RESERVED.[REV END]

     isql=>

ISQL interacts with several files each time it is invoked:

   *   ISQLPRO--the profile file.
   *   ISQLSYN--the synonym file.
   *   SQLCT000--the message file.
   *   SQLWL000--the welcome file.

The profile and synonym files are discussed later in this chapter under
"Using ISQL Files and Buffers." The message file contains ISQL and other
ALLBASE/SQL messages.

The welcome file contains the ISQL banner and prompt to be displayed when
ISQL is invoked, as shown above.  The ISQL prompt is defined on the the
first line of the welcome file, although you can override this prompt
with a SET PROMPT command submitted either from a profile file or
interactively. 



MPE/iX 5.0 Documentation