This section explains the variables and parameters that are used to pass and receive values in UAPs, SQL statements, external routines, and SQL routines.
- Embedded variables, indicator variables, ? parameters
These variables and parameters can be specified in SQL statements in a UAP or external routine. When specified, these variables and parameters are used to pass and receive values between the SQL statement and the UAP.
- SQL variables
These variables can be specified in SQL statements in an SQL routine. When specified, these variables are used to pass and receive values with the SQL routine. SQL variables cannot be specified in an external routine.
- SQL parameters
SQL parameters can be specified when a routine to be called is defined. Specifying an SQL parameter allows the values to be passed between the CALL statement in the SQL (UAP or routine that calls a function) and the routine being called. In an SQL routine, the SQL parameter is specified directly; in an external routine, the specification is made to a variable in an external routine corresponding to that SQL parameter.
- Organization of this section
- 1.6.1 Embedded variables and indicator variables
- 1.6.2 ? parameters
- 1.6.3 SQL parameters and SQL variables
- 1.6.4 Specifiable locations
- 1.6.5 Setting a value for an indicator variable
- 1.6.6 Setting a null default value in an embedded variable
- 1.6.7 Assignment rules