ASA SQL Reference
SQL Statements
Using the SQL statement reference
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.
[T-SQL] 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.
[MobiLink] The statement is for use only in MobiLink clients.
[SQL Remote] The statement can be used only in SQL Remote.
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 in both embedded SQL and stored procedures.