HPlogo ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL: HP 3000 MPE/iX Computer Systems

Index
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
  		   

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 the INPUT Command, INPUT, Parameters
and INSTALL, INSTALL
and LOAD, Setting the AUTOCOMMIT Option
AUTOCOMMIT option:
and INPUT, Using SQL SAVEPOINT and ROLLBACK WORK Statements
and INSTALL, Using SQL SAVEPOINT and ROLLBACK WORK Statements
and LOAD, Using SQL SAVEPOINT and ROLLBACK WORK Statements
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

B

banner,:
ISQL, Invoking ISQL
BEGIN WORK:
automatically by ISQL, How ISQL Manages Transactions
use of, Managing Transactions
beginning a DBE:
session, Starting a DBE Session
BINARY data
in description file, Description
BOTTOM, Using the SELECT Statement

C

CHANGE
and special characters, CHANGE
syntax, CHANGE
CHANGE:
and command buffer, The Command Buffer
and special characters, Special Characters in Commands
changing
files, EDIT
changing commands
with CHANGE, CHANGE
with REDO, REDO
changing:
command history buffer contents, The Command History Buffer
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 buffer, The Command Buffer
and command files, RECALL
and HOLD, ISQL Syntax
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
storing contents in a file, STORE
command buffer:
and command history buffer, The Command Buffer
and parameters, Using ISQL Files and Buffers
related ISQL commands, The Command Buffer
command file, Files Containing Commands
creating, Description
creating from command buffer, STORE
displaying, LIST FILE
executing, Description
executing commands in, START
pausing to review query result, SELECTSTATEMENT
command file:
and EDIT, Files Containing Commands
and parameters, Parameters in Commands
and STORE, Files Containing Commands
comments in, Files Containing Commands
creating, Files Containing Commands
error messages, Files Containing Commands
executing, Files Containing Commands
line limit, Files Containing Commands
maintenance, Files Containing Commands
SELECT in, Files Containing Commands
command history buffer, The Command History Buffer
and LIST HISTORY, LIST HISTORY
command history buffer:
related ISQL commands, The Command History Buffer
size of, The Command History Buffer
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
commands:
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 END, END
and EXIT, EXIT
and INPUT, Using the INPUT Command, INPUT
and LOAD, Setting the AUTOCOMMIT Option
COMMIT WORK:
and DBEnvironment termination, Unexpected ISQL or DBEnvironment Termination
and ISQL termination, Unexpected ISQL or DBEnvironment Termination
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
CONTINUE option:
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
edit line, REDO
current language
native language, Native Language Support
current:
command, The Command Buffer

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, Leaving ISQL
DBE:
session, Starting a DBE Session
DBEnvironment
access, Purpose of ISQL
DBEnvironment:
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
displaying files
and RECALL, RECALL
displaying files:
and LIST FILE, Files Containing Commands
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
ECHO option:
and command files, Files Containing Commands
ECHO_ALL option, Parameters
EDIT, EDIT
syntax, EDIT
edit mode, REDO
EDIT:
and command files, Files Containing Commands
and maintaining command files, Files Containing Commands
and profile file, Creating a Profile File
editing commands:
CHANGE, CHANGE
REDO, REDO
editing files, EDIT
editor, Using the System Editor
EDITOR option, Parameters
and EDIT, EDIT
and SELECT, Using the SELECT Statement
EDITOR option:
and command files, Files Containing Commands
END, END
syntax, END
use of, END
end users, ISQL Users
END:
use of, Leaving ISQL
entering commands, Using ISQL Files and Buffers
equating commands, Using a Synonym File
ERASE, ERASE
syntax, ERASE
ERASE:
and maintaining command files, Files Containing Commands
error handling, Handling Errors
error handling:
checking JCWs , Checking JCWs for Errors
command buffer, Command Errors
interactive commands, Command Errors
errors types of:, Handling Errors
errors:
command, Command Errors
DBEnvironment, DBEnvironment Errors
semantic, Command Errors
syntax, Command Errors
escape character:
and HOLD, The Command Buffer
and SET, Special Characters in Commands
example of use of, Setting Command Options
ESCAPE option
of SET, Parameters
ESCAPE option:
escape characters, Special Characters in Commands
use of, Special Characters in Commands
EXECUTE statement, Installing a Module
executing a module, Installing a Module
executing ISQL:
in job mode, Running ISQL in Job Mode
executing MPE/iX commands
from ISQL, SYSTEM
executing:
command buffer contents, The Command Buffer
EXIT, EXIT
syntax, EXIT
EXIT:
and RELEASE, Leaving ISQL
EXIT_ON_DBERR option
of SET, Parameters
EXIT_ON_DBWARN option
of SET, Parameters
external data files
length of data values in, Parameters
location of data in, Parameters
null indicators, Parameters, Description
use of, External Format
value loading criteria, Description
external data files:
creation, UNLOAD
EXTRACT, EXTRACT
syntax, EXTRACT
use of, Installing a Module
extracting modules, EXTRACT

F

files
and LIST FILE, LIST FILE
and RECALL, RECALL
creating, EDIT
creating external, UNLOAD
creating internal, UNLOAD
editing, EDIT
listing, RECALL
renaming, RENAME
files:
creating, Files Containing Commands
displaying, Files Containing Commands
editing, Files Containing Commands
removing, Files Containing Commands
renaming, Files Containing Commands
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
HELP:
use of, Getting Help
history buffer, The Command History Buffer
HOLD, ISQL Syntax
and special characters, Parameters
syntax, ISQL Syntax
HOLD:
and command buffer, The Command Buffer
and special characters, Special Characters in Commands

I

INFO
syntax, INFO
use of, Using the INFO Command
INPUT, INPUT
and AUTOCOMMIT option, INPUT, Parameters
and AUTOSAVE option, INPUT
and COMMIT WORK, INPUT
and ROLLBACK WORK, INPUT
syntax, INPUT
use of, Using the INPUT Command
INPUT:
and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements
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, INSTALL
and DROP option, INSTALL
syntax, INSTALL
use of, Installing a Module
INSTALL:
and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements
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
SQLGEN, SQLGEN
SQLUtil, SQLUTIL
invoking:
ISQL, Invoking ISQL
ISQL
environment options, SET
ISQL commands, ISQL Commands
summary of, ISQL Commands
ISQL commands purpose, Purpose of ISQL
ISQL commands structure, Authorization
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
RECALL, RECALL
REDO, REDO
RENAME, RENAME
SELECT, SELECTSTATEMENT
SELECTSTATEMENT, SELECTSTATEMENT
SET, SET
SQLGEN, SQLGEN
SQLUtil, SQLUTIL
START, START
STORE, STORE
SYSTEM, SYSTEM
UNLOAD, UNLOAD
ISQL session
and END, END
and EXIT, EXIT
ISQL session:
and SET, Setting Command Options
terminating, Leaving ISQL
ISQL:
banner, Invoking ISQL
invoking, Invoking ISQL
ISQLLP
and PRINT option, Using the SELECT Statement, Parameters
isqlout
and query result, Using the SELECT Statement
and SELECTSTATEMENT, Description
isqlpro, Creating a Profile File
ISQLSYN, Using a Synonym File

J

jcw
system JCW, Parameters
jcw:
ISQLERR, Checking JCWs for Errors
ISQLLASTERR, Checking JCWs for Errors
ISQLLASTWARN, Checking JCWs for Errors
ISQLWARN, Checking JCWs for Errors
system JCW, Checking JCWs for Errors
job mode:
running ISQL from, Running ISQL in Job Mode

L

language
current language, Native Language Support
native language support, Native Language Support
setting and resetting, Native Language Support
leaving ISQL
and END, END
and EXIT, EXIT
leaving ISQL:
and END, Leaving ISQL
and RESUME, Using System Commands and Programs
LEFT, Using the SELECT Statement
line-continuation prompt, Terminating Commands
line-kill character, Setting Command Options
LIST FILE, LIST FILE
syntax, LIST FILE
LIST FILE:
and maintaining command files, Files Containing Commands
LIST HISTORY, LIST HISTORY
syntax, LIST HISTORY
LIST HISTORY:
and command history buffer, The Command History Buffer
LIST INSTALL, LIST INSTALL
syntax, LIST INSTALL
use of, Installing a Module
LIST SET, LIST SET
in prompting mode, Description
syntax, LIST SET
LIST SET:
and SET commands, Setting Command Options
listing files
and LIST FILE, LIST FILE
and RECALL, RECALL
LOAD, LOAD
and AUTOCOMMIT option, Description
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:
and COMMIT WORK, Using SQL SAVEPOINT and ROLLBACK WORK Statements
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

M

managing transactions, Managing Transactions
modifying
commands, CHANGE
files, EDIT
module
dropping, INSTALL
executing, Installing a Module
extracting, EXTRACT
installing, INSTALL
MPE/iX commands, SYSTEM
MPE/iX commands:
and leaving ISQL, Using System Commands and Programs
multiple-line commands, Terminating Commands

N

native language
setting and resetting, Native Language Support
native language support
overview, Native Language Support
native language:
and special characters, Special Characters in Commands
NATIVE-3000
defined, Native Language Support
NLUSERLANG job control word
setting and resetting, 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 use of:, Setting Command Options
options:
in prompting mode, Example
initial values, Setting Command Options, SET
listing, LIST SET
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
valid values, START
parameters:
assigning values, Parameters in Commands
use of, Parameters in Commands
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
prompting mode:
and parameters, Parameters in Commands
use of, Prompting Mode
purging files
and ROLLBACK WORK, END
purging files:
and ERASE, Files Containing Commands

Q

query result
browsing through, Using the SELECT Statement
maximum length, Description
printing, Parameters
scrolling through, SELECTSTATEMENT, Parameters
query result:
definition of, Invoking ISQL
quotation marks
and NULL option, Parameters
and parameters, START, Description
quotation marks:
and synonym files, Using a Synonym File
embedded, Special Characters in Commands

R

re-executing commands, The Command History Buffer
RECALL, RECALL
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 buffer, The Command Buffer
and command history buffer, The Command History Buffer
RECALL:
and command buffer, The Command Buffer
REDO, REDO
syntax, REDO
REDO:
and command history buffer, The Command History Buffer
RELEASE
and END, END
and EXIT, EXIT
RELEASE:
by ISQL, Leaving ISQL
removing files
and ROLLBACK WORK, END
removing files:
and ERASE, Files Containing Commands
RENAME, RENAME
syntax, RENAME
RENAME:
and maintaining command files, Files Containing Commands
renaming files
and RENAME, RENAME
renaming files:
and RENAME, Files Containing Commands
RESUME:
after using SYSTEM, Using System Commands and Programs
revalidate
sections, Description
RIGHT, Using the SELECT Statement
ROLLBACK WORK
and END, END
and EXIT, EXIT
and INPUT, Using the INPUT Command, INPUT
ROLLBACK WORK:
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
CONVERT, Description
syntax, SET
SET command:
option summary, Setting Command Options
SET:
and ISQL sessions, 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
SQLGEN:
invoking from ISQL, Using SQLGEN
SQLUtil, SQLUTIL
SQLUtil:
invoking from ISQL, Using SQLUtil
standards
checking with flagger, Parameters
START, START
effect of CONTINUE, Description
effect of ECHO, Description
syntax, START
START:
and command buffer, Parameters in Commands, The Command Buffer
and command files, Parameters in Commands, Files Containing Commands
STARTDBE, Starting a DBE Session
STOP DBE
and END, END
and EXIT, EXIT
STOP DBE:
during ISQL use, Unexpected ISQL or DBEnvironment Termination
STORE, STORE
syntax, STORE
STORE:
and command buffer, The Command Buffer
and command files, Files Containing Commands
and profile file, Creating a Profile File
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
system interrupt character:
and leaving ISQL temporarily, Using System Commands and Programs
example, Special Characters in Commands
SYSTEM:
use of, Using System Commands and Programs

T

table definition
and INFO, Using the INFO Command, INFO
terminating ISQL
and END, END
and EXIT, EXIT
terminating ISQL:
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
ending, END
exiting, EXIT
transaction:
definition of, Managing Transactions
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

V

VALIDATE, Description
values
passing, Description
view definition, Using the INFO Command, INFO

Z

ZONED DECIMAL
converting, Description


  		 
Feedback to webmaster