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/2003 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.