Named parameters

SQL Anywhere functions and procedures that are referenced from the CALL statement, the EXECUTE statement (Transact-SQL), or the FROM clause of a DML statement support positional parameters and named parameters. Named parameters allow you to specify any subset of the available parameters in any order. You can use named parameters with system-defined procedures and functions and with user-defined procedures. Named parameters cannot be used with user-defined functions.

The following named parameter syntaxes are supported:

Example

The following example uses = to specify a named parameter:

CALL sa_conn_properties( connidparm = 1 );

This example uses named parameters when calling the system procedure, and returns information about the remote tables with foreign keys on the SYSOBJECTS table, in the production database, on a database server named satest:

CALL sp_remote_exported_keys(
     @server_name=>'satest',
     @sp_name=>'sysobjects',
     @sp_qualifier=>'production' );

Named parameters

Example

Standards and compatibility

See also