Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » Using the SQL statement reference

 

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.

  • [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.

  • [external procedures]   The statement is for use in calling external functions and procedures.

  • [MobiLink]   The statement is for use only in MobiLink clients.

  • [SQL Remote]   The statement can be used only in SQL Remote.

  • [web services]   The statement is for use in web services clients.

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.

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1