HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

LIST SET 

The LIST SET command displays any or all of the current SET option
values.

Scope 

ISQL only.

ISQL Syntax 

LI[ST] S[ET] {Option}
             {@     }
Parameters 

Option                  names one of the following SET command options:
                        [REV BEG]

                             AUTOC[OMMIT]
                             AUTOL[OCK]
                             AUTOS[AVE]
                             C[ONTINUE]
                             CONV[ERT]
                             EC[HO]
                             ECHO_[ALL]
                             ED[ITOR]
                             ES[CAPE]
                             EXIT[_ON_DBERR]
                             EXIT_ON_DBWARN
                             FL[AGGER]
                             F[RACTION]
                             N[ULL]
                             LOAD_B[UFFER]
                             LOAD_E[CHO]
                             OU[TPUT]
                             OW[NER]
                             PA[GEWIDTH]
                             PR[OMPT]
                        [REV END]

                        Refer to the SET command for a complete
                        explanation of each option.

@                       indicates all SET command options.

Description 

   *   In prompting mode, ISQL prompts you for an option:

            isql=> LIST; 

            Option (s[et], f[ile], i[nstall], or h[istory])> SET; 
            Valid set options are:[REV BEG]
              autoc[ommit]    autol[ock]      autos[ave]     cont[inue]
              conv[ert]       ec[ho]          echo_[all]     ed[itor]
              es[cape]        exit[_on_dberr] exit_on_dbwarn fl[agger]
              f[raction]      load_b[uffer]   load_e[cho]    n[ull]
              ou[tput]        ow[ner]         pa[gewidth]    pr[ompt][REV END]
            Set option or @> @; 

Example 

     isql=> LIST SET ECHO; 

     ec[ho]            - OFF

     isql=> LIST SET @; 
     [REV BEG]
     autoc[ommit]      - OFF
     autol[ock]        - OFF
     autos[ave]        - 5
     c[ontinue]        - ON
     conv[ert]         - OFF
     ec[ho]            - OFF
     echo_[all]        - OFF
     ed[itor]          - EDITOR.PUB.SYS
     es[cape]          - \
     exit[_on_dberr]   - OFF
     exit_on_dbwarn    - OFF
     fl[agger]         -
     f[raction]        - 2
     n[ull]            -
     load_b[uffer]     - 16384
     ou[tput]          - ISQLOUT
     ow[ner]           - LINDA@HPSQL
     pa[gewidth]       - 32767
     pr[ompt]          - isql=>[REV END]

     isql=>

MPE/iX 5.0 Documentation