You can also define your own parameters. These are especially useful for RDBMSs that don't allow user-defined variables.
User-defined parameters are defined (and set to null) when first referenced. They must start with ui and a period (ui.) if the parameter will only be referenced (input-only) and u and a period (u.) if the parameter will be updated (in/out). A user-defined parameter lasts for one synchronization—it is set to null at the start of every synchronization.
A typical use of user-defined parameters is to access state information without having to store it in a table (requiring potentially complex joins).
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|