HPlogo ALLBASE/ISQL Reference Manual: HP 9000 Computer Systems > Chapter 4 ISQL Commands

LIST SET

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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:

 

   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]

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

@

indicates all SET command options. If @ is the line-kill character on your system, you must precede the @ with the current HP-UX escape character.

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:
    
         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]
    
       Set option or @> @;
    

Example

 

   isql=> LIST SET ECHO;



   ec[ho]            - OFF



   isql=> LIST SET @;



   autoc[ommit]      - OFF

   autol[ock]        - OFF

   autos[ave]        - 5

   c[ontinue]        - ON

   conv[ert]         - OFF

   ec[ho]            - OFF

   echo_[all]        - OFF 

   ed[itor]          - /usr/bin/vi

   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

   pa[gewidth]       - 32767

   pr[ompt]          - isql=>



   isql=>
Feedback to webmaster