Using the SQL statement reference
380
♦
Optional portions Optional portions of a statement are enclosed by
square brackets.
RELEASE SAVEPOINT [
savepoint-name
]
These square brackets indicate that the savepoint-name is optional. The
square brackets should not be typed.
♦
Options When none or only one of a list of items can be chosen,
vertical bars separate the items and the list is enclosed in square
brackets.
[ ASC | DESC ]
For example, you can choose one of ASC, DESC, or neither. The square
brackets should not be typed.
♦
Alternatives When precisely one of the options must be chosen, the
alternatives are enclosed in curly braces.
[ QUOTES { ON | OFF } ]
If the QUOTES option is chosen, one of ON or OFF must be provided.
The braces should not be typed.
♦
One or more options If you choose more than one, separate your
choices with commas.
{ CONNECT, DBA, RESOURCE }
Statement applicability indicators
Some statement titles are followed by an indicator in square brackets that
indicate where the statement can be used. These indicators are as follows:
♦
[ESQL] The statement is for use in Embedded SQL.
♦
[Interactive SQL] The statement can be used only in Interactive SQL.
♦
[SP] The statement is for use in stored procedures, triggers, or batches.
♦
[TSQL] The statement is implemented for compatibility with Adaptive
Server Enterprise. In some cases, the statement cannot be used in stored
procedures that are not in Transact-SQL format. In other cases, an
alternative statement closer to the SQL/92 standard is recommended
unless Transact-SQL compatibility is an issue.
If two sets of brackets are used, the statement can be used in both
environments. For example, [ESQL][SP] means a statement can be used
either in embedded SQL or in stored procedures.
To Next Page
Loading...