Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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|