Chapter 4 ISQL Commands

This chapter describes all the ISQL commands, giving syntax and examples for each and authorization requirements for commands that result in database access. The commands are presented in alphabetical order; those related to query results are defined under "SELECTSTATEMENT."

The size of commands submitted at a terminal or from an ISQL command file is unlimited. Commands submitted through the ISQL command buffer cannot exceed 32K bytes; the LOAD and UNLOAD size is unlimited.

Table 4-1 groups the commands you can execute from ISQL into functional categories. Refer to the ALLBASE/SQL Reference Manual for a description of those in the category named SQL statement. Refer to the ALLBASE/SQL Database Administration Guide for SQLGEN and SQLUtil commands.

Table 4-1 ISQL Command Summary

Group	Category	Command	Command Use
DBEnvironment access	SQL statements	Refer to the ALLBASE/SQL Reference Manual.	Define, access, and maintain databases.
	Column information	`INFO`	Display column definitions.
	Data utility	`INPUT`	Insert rows into a table.
		`LOAD`	Insert rows into a table from a file.
		`UNLOAD`	Copy rows from one or more tables to a file.
	Application program support	`EXTRACT`	Copy a stored module into an installable module file.
		`INSTALL`	Store a preprocessor-generated module in a DBEnvironment.
		`LIST INSTALL`	Identify the module in a file created by an ALLBASE/SQL preprocessor.
Command support	Query results	`UP`	Display previous rows in a query result.
		`DOWN`	Display next rows in a query result.
		`TOP`	Display the group of selected rows of a query result.
		`BOTTOM`	Display the last group of selected rows of a query result.
		`LEFT`	Display previous screen columns in a query result.
		`RIGHT`	Display next screen columns in a query result.
		`PRINT`	Print a query result.
		`PAUSE`	Suspend command file processing to enable review of a query result.
		`END`	Terminate query result display.
	File management	`EDIT`	Invoke an editor for creating or changing a file.
		`ERASE`	Purge a file.
		`LIST FILE`	Display a file.
		`RECALL FILE`	Display a file and store its contents in command buffer.
		`RENAME`	Change the name of a file.
		`STORE`	Save the contents of the command buffer in a file.
	Command files	`START`	Execute a command file.
	Command buffer	`CHANGE`	Modify the contents of the command buffer.
		`HOLD`	Put command(s) into the command buffer.
Command Support (Continued)	Command Buffer (Continued)	`RECALL CURRENT`	Display current contents of the command buffer.
		`RECALL FILE`	Displays a file and stores its contents in the command buffer.
		`RECALL HISTORY`	Place a command from the command history buffer into the command buffer and display it.
		`START`	Execute command(s) in the command buffer or a file.
		`STORE`	Save the contents of the command buffer in a file.
	Command history buffer	`DO`	Execute a command in the command history buffer.
		`LIST HISTORY`	Display commands in the command history buffer.
		`RECALL HISTORY`	Place a command from the command history buffer into the command buffer and display it.
		`REDO`	Edit a command in the command history buffer.
	ISQL environment	`LIST SET`	Display SET option values.
		`SET`	Set operational options, such as display line length, to specific values.
	Command information	`HELP`	Display description, syntax, and example of SQL or ISQL commands.
ISQL termination		`END``or``EXIT`	Terminate an ISQL session.
System access		`SYSTEM`	Execute HP-UX command(s).
SQLGEN invocation		`SQLGEN`	Execute SQLGEN commands.
SQLUtil invocation		`SQLUTIL`	Execute SQLUtil commands.

Chapter 4 ISQL Commands

Technical documentation

» Table of Contents

» Index