Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements

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. Sometimes the statement cannot be used in stored procedures that are not in Transact-SQL format. In other cases, an alternative statement closer to the ANSI/ISO SQL Standard is recommended unless Transact-SQL compatibility is an issue.

  • [External call]

    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 service]

    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.