HP NEOVIEW 544530-001 Manuel d'utilisateur Page 86

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 142
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 85
Current setting (on or off) of the elapsed time. By default, the elapsed time is off.
For more information, see “Displaying the Elapsed Time” (page 54) and “SET
TIMING Command” (page 113).
TIMING
User name that you entered when logging in to the database platform. For more
information, see “Logging In to the Database Platform” (page 45).
USER
Examples
This ENV command displays the attributes of the current session:
SQL>env
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 30 min(s)
LIST COUNT 0 [All Rows]
LOG OFF
LOOK AND FEEL BTEQ
MARKUP RAW
MODE SQL
PROMPT SQL>
SCHEMA USR
SERVER neo0101.acme.com:18650
SQLTERMINATOR ;
TIME OFF
TIMING OFF
USER role.dbaSQL>
This ENV command shows the effect of setting various session attributes:
4:16:43 PM >env
COLSEP " "
DATASOURCE TDM_Default_DataSource
HISTOPT ALL
IDLETIMEOUT 0 min(s) [Never Expires]
LIST COUNT 0 [All Rows]
LOG c:\mydir\examples.log
LOOK AND FEEL BTEQ
MARKUP RAW
MODE SQL
PROMPT 4:16:49 PM >
SCHEMA PERSNL
SERVER sys0101.mylab.mycorp.net:18650
SQLTERMINATOR .
TIME ON
TIMING ON
USER dba1
4:16:49 PM >
EXIT Command
The EXIT command disconnects from and exits the Neoview Script interface.
Syntax
EXIT [IF ERRORCODE{=|<|>|<=|>=|<>}error-code]
86 Neoview Script Interface Commands
Vue de la page 85
1 2 ... 81 82 83 84 85 86 87 88 89 90 91 ... 141 142

Commentaires sur ces manuels

Pas de commentaire