 |
» |
|
|
|
A- aborting commands, Aborting Commands
- application program
- using SQL statements, Installing a Module
- application programmers, ISQL Users
- authorization, Authorization
- AUTOCOMMIT option, Parameters
- and INPUT, Using SQL SAVEPOINT and ROLLBACK WORK Statements, Using the INPUT Command, INPUT, Parameters
- and INSTALL, Using SQL SAVEPOINT and ROLLBACK WORK Statements, INSTALL
- and LOAD, Using SQL SAVEPOINT and ROLLBACK WORK Statements, Setting the AUTOCOMMIT Option
- AUTOLOCK option, Parameters
- automatic DBE session termination, How ISQL Manages Transactions
- automatic transaction management, How ISQL Manages Transactions
- AUTOSAVE option, Parameters
- and INPUT, Using the INPUT Command
- and LOAD, Setting the AUTOCOMMIT Option
C- CHANGE
- and command buffer, The Command Buffer
- and special characters, Special Characters in Commands, CHANGE
- syntax, CHANGE
- changing
- command history buffer contents, The Command History Buffer
- files, EDIT
- changing commands
- with CHANGE, CHANGE
- with REDO, REDO
- check constraint
- in CREATE TABLE, Check Constraint (Table Level)
- column definition, INFO
- column names
- and INFO, Using the INFO Command, INFO
- in CREATE TABLE, Column Definition
- columns
- maximum allowed in tables, Column Definition
- command
- entry, Using ISQL Files and Buffers
- errors, Command Errors
- Manager, ISQL, Using ISQL Files and Buffers
- router, Using ISQL Files and Buffers
- sources, Using ISQL Files and Buffers
- termination, Terminating Commands
- terminator, Special Characters in Commands
- command buffer, The Command Buffer
- and command files, RECALL
- and command history buffer, The Command Buffer
- and HOLD, ISQL SYNTAX
- and parameters, Using ISQL Files and Buffers
- displaying current contents of, RECALL
- editing contents of, CHANGE
- executing commands in, START
- filled from command history buffer, RECALL
- ISQL commands that fill, RECALL, Description
- ISQL commands that operate on, Example
- putting commands in, ISQL SYNTAX
- related ISQL commands, The Command Buffer
- storing contents in a file, STORE
- command file, Files Containing Commands
- and EDIT, Files Containing Commands
- and parameters, Parameters in Commands
- and STORE, Files Containing Commands
- comments in, Files Containing Commands
- creating, Files Containing Commands, Description
- creating from command buffer, STORE
- displaying, LIST FILE
- error messages, Files Containing Commands
- executing, Files Containing Commands, Description
- executing commands in, START
- line limit, Files Containing Commands
- maintenance, Files Containing Commands
- pausing to review query result, SELECTSTATEMENT
- SELECT in, Files Containing Commands
- command history buffer, The Command History Buffer
- and LIST HISTORY, LIST HISTORY
- related ISQL commands, The Command History Buffer
- size of, The Command History Buffer
- commands
- from a command file, Running ISQL in the Background
- from command file, Files Containing Commands
- from profile file, Creating a Profile File
- from the command buffer, The Command Buffer
- from the command history buffer, The Command History Buffer
- comment marker, Special Characters in Commands
- comments, Special Characters in Commands, Files Containing Commands
- COMMIT WORK
- and DBEnvironment termination, Unexpected ISQL or DBEnvironment Termination
- and END, END
- and EXIT, EXIT
- and INPUT, Using the INPUT Command, INPUT
- and ISQL termination, Unexpected ISQL or DBEnvironment Termination
- and LOAD, Setting the AUTOCOMMIT Option
- by ISQL, Leaving ISQL, Using SQL SAVEPOINT and ROLLBACK WORK Statements
- use, Managing Transactions
- concurrency, Using SQL SAVEPOINT and ROLLBACK WORK Statements
- CONNECT, Starting a DBE Session
- CONTINUE option, Parameters
- and command files, Files Containing Commands
- CONVERT option, Parameters
- converting data
- and LOAD, Description
- IBM mainframe format, Description, Parameters
- creating files, The Command History Buffer, EDIT, UNLOAD
- current
- command, The Command Buffer
- edit line, REDO
- language, Native Language Support
- current language
- native language, Native Language Support
D- data
- external format, External Format, Internal Format
- internal format, Internal Format, Internal Format
- loading, Using the LOAD Command, External Format, INPUT
- unloading, Using the UNLOAD Command
- data control language, Controlling Access to Objects
- data definition, INFO
- language, Creating Objects
- data manipulation language, Manipulating Data
- data types, INFO
- database administrators, ISQL Users
- DBE session, Starting a DBE Session, Leaving ISQL
- DBEnvironment
- access, Purpose of ISQL
- during ISQL use, Unexpected ISQL or DBEnvironment Termination
- errors, DBEnvironment Errors
- decimal digits, Using the SELECT Statement
- decimal places
- and SELECT, Using the SELECT Statement
- defaults
- native language, Native Language Support
- DELETE
- ISQL support of, Manipulating Data
- delimiter, Special Characters in Commands
- description file, External Format, Parameters
- diskless environment, Purpose of ISQL
- displaying files
- and LIST FILE, Files Containing Commands
- and RECALL, RECALL
- DO, DO
- syntax, DO
- double slash, Aborting Commands
- DOWN, Using the SELECT Statement
- dropping modules, EXTRACT, INSTALL
E- EBCDIC
- converting, Parameters, Description
- option in SET CONVERT, Parameters
- ECHO option, Parameters
- and command files, Files Containing Commands
- ECHO_ALL option, Parameters
- EDIT, EDIT
- and command files, Files Containing Commands
- and maintaining command files, Files Containing Commands
- and profile file, Creating a Profile File
- SYNTAX, EDIT
- edit mode, REDO
- editing commands:
- CHANGE, CHANGE
- REDO, REDO
- editing files, EDIT
- editor, Using the System Editor
- EDITOR option, Parameters
- and command files, Files Containing Commands
- and EDIT, EDIT
- and SELECT, Using the SELECT Statement
- END, END
- SYNTAX, END
- use of, Leaving ISQL, END
- end users, ISQL Users
- entering commands, Using ISQL Files and Buffers
- equating commands, Using a Synonym File
- ERASE, ERASE
- and maintaining command files, Files Containing Commands
- SYNTAX, ERASE
- error handling, Handling Errors
- command buffer, Command Errors
- interactive commands, Command Errors
- errors:
- command, Command Errors
- DBEnvironment, DBEnvironment Errors
- semantic, Command Errors
- syntax, Command Errors
- types of, Handling Errors
- escape character
- and HOLD, The Command Buffer
- and SET, Special Characters in Commands
- example of use of, Setting Command Options
- ESCAPE option
- escape characters, Special Characters in Commands
- of SET, Parameters
- use of, Special Characters in Commands
- EXECUTE statement, Installing a Module
- executing
- command buffer contents, The Command Buffer
- executing a module, Installing a Module
- executing HP-UX commands from ISQL, SYSTEM
- executing ISQL
- in background, Running ISQL in the Background
- EXIT, EXIT
- after using SYSTEM, Using System Commands and Programs
- and RELEASE, Leaving ISQL
- SYNTAX, EXIT
- exit status
- setting, Checking the Exit Status
- EXIT_ON_DBERR option
- of SET, Parameters
- EXIT_ON_DBWARN option
- of SET, Parameters
- external data files
- use of, External Format
- value loading criteria, Description
- external data files:
- creation, UNLOAD
- length of data values in, Parameters
- location of data in, Parameters
- null indicators, Parameters, Description
- EXTRACT, EXTRACT
- SYNTAX, EXTRACT
- use of, Installing a Module
- extracting modules, EXTRACT
F- files
- and LIST FILE, LIST FILE
- and RECALL, RECALL
- creating, Files Containing Commands, EDIT
- creating external, UNLOAD
- creating internal, UNLOAD
- displaying, Files Containing Commands
- editing, Files Containing Commands, EDIT
- listing, RECALL
- removing, Files Containing Commands
- renaming, Files Containing Commands, RENAME
- FLAGGER option
- of SET, Parameters
- FRACTION option
- and SELECT, Using the SELECT Statement, Description
- setting, Parameters
H- handling errors, Handling Errors
- HELP, HELP
- SYNTAX, HELP
- use of, Getting Help
- history buffer, The Command History Buffer
- HOLD, ISQL SYNTAX
- and command buffer, The Command Buffer
- and special characters, Special Characters in Commands, Parameters
- CMDSYNOPSIS, ISQL SYNTAX
- HP-UX commands, SYSTEM
- and leaving ISQL, Using System Commands and Programs
- hpsqlcat, Native Language Support
I- INFO
- syntax, INFO
- use of, Using the INFO Command
- INPUT, INPUT
- and AUTOCOMMIT option, INPUT, Parameters
- and AUTOSAVE option, INPUT
- and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements, INPUT
- and ROLLBACK WORK, INPUT
- syntax, INPUT
- use of, Using the INPUT Command
- INSERT
- and INPUT, Description
- ISQL support of, Manipulating Data
- inserting rows
- and INPUT, Using the INPUT Command, INPUT
- from a file, LOAD
- INSTALL, INSTALL
- and AUTOCOMMIT option, INSTALL
- and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements, INSTALL
- and DROP option, INSTALL
- syntax, INSTALL
- use of, Installing a Module
- installable module
- and EXTRACT, EXTRACT
- and INSTALL, INSTALL
- and LIST INSTALL, Installing a Module, LIST INSTALL
- installing
- applications, Installing a Module
- modules, Installing a Module, INSTALL
- internal data file
- and LOAD, Internal Format
- and UNLOAD, Internal Format
- creation, UNLOAD
- interrupt character, Using System Commands and Programs
- invalid module, INSTALL
- invalid sections, Description
- invoking
- ISQL, Invoking ISQL
- SQLGEN, SQLGEN
- SQLUtil, SQLUTIL
- ISQL
- banner, Invoking ISQL
- environment options, SET
- invoking, Invoking ISQL
- ISQL commands:
- CHANGE, CHANGE
- DO, DO
- EDIT, EDIT
- END, END
- ERASE, ERASE
- EXIT, EXIT
- EXTRACT, EXTRACT
- HELP, HELP
- HOLD, ISQL SYNTAX
- INFO, INFO
- INPUT, INPUT
- INSTALL, INSTALL
- LIST FILE, LIST FILE
- LIST HISTORY, LIST HISTORY
- LIST INSTALL, LIST INSTALL
- LIST SET, LIST SET
- LOAD, LOAD
- purpose, Purpose of ISQL
- RECALL, RECALL
- REDO, REDO
- RENAME, RENAME
- SELECT, SELECTSTATEMENT
- SELECTSTATEMENT, SELECTSTATEMENT
- SET, SET
- size, ISQL Commands
- SQLGEN, SQLGEN
- SQLUtil, SQLUTIL
- START, START
- STORE, STORE
- structure, Authorization
- summary of, ISQL Commands
- SYSTEM, SYSTEM
- UNLOAD, UNLOAD
- ISQL session
- and END, END
- and EXIT, EXIT
- and SET, Setting Command Options
- terminating, Leaving ISQL
- isqlout
- and query result, Using the SELECT Statement
- and SELECTSTATEMENT, Description
- isqlpro, Creating a Profile File
- isqlsyn, Using a Synonym File
L- LANG variable
- setting and resetting, Native Language Support
- language
- current language, Native Language Support
- native language support, Native Language Support
- setting and resetting, Native Language Support
- leaving ISQL
- and END, Leaving ISQL, END
- and EXIT, Using System Commands and Programs, EXIT
- LEFT, Using the SELECT Statement
- line-continuation prompt, Terminating Commands
- line-kill character, Setting Command Options
- LIST FILE, LIST FILE
- and maintaining command files, Files Containing Commands
- syntax, LIST FILE
- LIST HISTORY, LIST HISTORY
- and command history buffer, The Command History Buffer
- syntax, LIST HISTORY
- LIST INSTALL, LIST INSTALL
- syntax, LIST INSTALL
- use of, Installing a Module
- LIST SET, LIST SET
- and SET commands, Setting Command Options
- in prompting mode, Description
- syntax, LIST SET
- listing files
- and LIST FILE, LIST FILE
- and RECALL, RECALL
- LOAD, LOAD
- and AUTOCOMMIT option, Description
- and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements
- EXTERNAL option, External Format
- improving performance, Description
- INTERNAL option, Internal Format
- PARTIAL option, Description
- purpose of, Using the LOAD Command
- syntax, LOAD
- using a command file, External Format
- using prompting mode, External Format
- LOAD PARTIAL
- in prompting mode, Description
- when to use, Description
- with AUTOCOMMIT, Description
- LOAD_BUFFER option
- setting, Parameters
- LOAD_ECHO option
- setting, Parameters
- loading data
- and INPUT, INPUT
- and LOAD, LOAD
- from an external data file, LOAD, Parameters
- in IBM mainframe format , External Format, Description, Parameters
- ways of, Using the LOAD Command
- with a command file, External Format
N- n-computer
- defined, Native Language Support
- native language
- and special characters, Special Characters in Commands
- setting and resetting, Native Language Support
- native language support
- overview, Native Language Support
- null indicator, Parameters
- NULL option
- and SELECT, Using the SELECT Statement, Description
- setting, Parameters
- null values
- and INFO, Using the INFO Command, INFO
- and SELECT, Using the SELECT Statement
O- options:
- in prompting mode, Example
- initial values, Setting Command Options, SET
- listing, LIST SET
- use of, Setting Command Options
- OUTPUT option
- effect with SELECT, Using the SELECT Statement, Parameters, Description
- setting, Parameters
- OWNER option, Parameters
P- PACKED DECIMAL
- converting, Description
- PAGEWIDTH option
- and SELECT, Using the SELECT Statement, Description
- setting, Parameters
- parameter indicator, Special Characters in Commands
- parameters
- and START, START
- assigning values, Parameters in Commands
- use of, Parameters in Commands
- valid values, START
- PARTIAL option, Parameters, Description
- passing values, Description
- PAUSE option
- and command files, Files Containing Commands
- performance
- of LOAD, Description
- PREPARE statement, Installing a Module
- PRINT
- query result, Using the SELECT Statement, Parameters
- profile file, Creating a Profile File
- PROMPT option, Parameters
- prompting mode, Prompting Mode
- and parameters, Parameters in Commands
- use of, Prompting Mode
- purging files
- and ERASE, Files Containing Commands
- and ROLLBACK WORK, END
Q- query result
- browsing through, Using the SELECT Statement
- definition of, Invoking ISQL
- maximum length, Description
- printing, Parameters
- scrolling through, SELECTSTATEMENT, Parameters
- quotation marks
- and NULL option, Parameters
- and parameters, START, Description
- and synonym files, Using a Synonym File
- embedded, Special Characters in Commands
R- re-executing commands, The Command History Buffer
- RECALL, RECALL
- and command buffer, The Command Buffer
- syntax, RECALL
- RECALL CURRENT, The Command Buffer
- RECALL FILE
- and command buffer, The Command Buffer
- and maintaining command files, Files Containing Commands
- RECALL HISTORY
- and command history buffer, The Command History Buffer
- REDO, REDO
- and command history buffer, The Command History Buffer
- syntax, REDO
- RELEASE
- and END, END
- and EXIT, EXIT
- by ISQL, Leaving ISQL
- removing files
- and ERASE, Files Containing Commands
- and ROLLBACK WORK, END
- RENAME, RENAME
- and maintaining command files, Files Containing Commands
- syntax, RENAME
- renaming files
- and RENAME, Files Containing Commands, RENAME
- revalidate
- sections, Description
- RIGHT, Using the SELECT Statement
- ROLLBACK WORK
- and END, END
- and EXIT, EXIT
- and INPUT, Using the INPUT Command, INPUT
- and savepoints, Using SQL SAVEPOINT and ROLLBACK WORK Statements
- by ISQL, Leaving ISQL
- use, Managing Transactions
- row
- count, Using the SELECT Statement
- insertion, Using the INPUT Command
- length, Using the SELECT Statement
S- savepoint
- use of, Using SQL SAVEPOINT and ROLLBACK WORK Statements
- script file
- example of, Example
- for UNLOAD command, Example
- sections
- extracting, EXTRACT
- revalidating, Description
- SELECT, SELECTSTATEMENT
- ISQL support of, Using the SELECT Statement
- SELECTSTATEMENT, SELECTSTATEMENT
- semantic errors, Command Errors
- semicolon
- and command termination, Terminating Commands
- omission of, Terminating Commands
- SET, SET
- and ISQL sessions, Setting Command Options
- CONVERT, Description
- syntax, SET
- SET command
- option summary, Setting Command Options
- SETOPT
- ignoring during extract, Description
- single-character input, Terminating Commands
- slash, Aborting Commands
- special characters
- meaning to ISQL, Special Characters in Commands
- SQL statements
- and ISQL, Purpose of ISQL
- SQLGEN, SQLGEN
- invoking from ISQL, Using SQLGEN
- SQLUtil, SQLUTIL
- invoking from ISQL, Using SQLUtil
- standards
- checking with flagger, Parameters
- START, START
- and command buffer, Parameters in Commands, The Command Buffer
- and command files, Parameters in Commands, Files Containing Commands
- effect of CONTINUE, Description
- effect of ECHO, Description
- syntax, START
- START DBE, Starting a DBE Session
- STOP DBE
- and END, END
- and EXIT, EXIT
- during ISQL use, Unexpected ISQL or DBEnvironment Termination
- STORE, STORE
- and command buffer, The Command Buffer
- and command files, Files Containing Commands
- and profile file, Creating a Profile File
- syntax, STORE
- storing command buffer contents, The Command Buffer
- in a file, STORE
- subcommands, REDO, Description
- submitting commands, Using ISQL Files and Buffers
- synonym file, Using a Synonym File
- syntax errors, Command Errors
- SYSTEM, SYSTEM
- syntax, SYSTEM
- use of, Using System Commands and Programs
- system interrupt character
- and leaving ISQL temporarily, Using System Commands and Programs
- example, Special Characters in Commands
T- table definition
- and INFO, Using the INFO Command, INFO
- terminating ISQL
- and END, END
- and EXIT, EXIT
- unexpectedly, Unexpected ISQL or DBEnvironment Termination
- TID function
- and LOAD, External Format
- and SELECT , TID Function, External Format
- and UNLOAD, External Format
- and WHERE clause, TID Function
- data type code , Parameters
- TOP, Using the SELECT Statement
- transaction
- definition of, Managing Transactions
- ending, END
- exiting, EXIT
- management, How ISQL Manages Transactions
U- UNLOAD, UNLOAD
- direct to tape, Description
- EXTERNAL option, External Format, Internal Format
- INTERNAL option, Internal Format
- syntax, UNLOAD
- use of, Using the UNLOAD Command
- using a script file, Example
- unloading data
- and UNLOAD, UNLOAD
- from the command line, External Format
- prompting mode, External Format
- ways of, External Format, External Format
- with a command file, External Format
- unloading from tables, UNLOAD
- UP, Using the SELECT Statement
- UPDATE
- ISQL support of, Manipulating Data
- updating files, EDIT
- uses for ISQL, Purpose of ISQL
|
