How variables are set is described below
Dynamic SQL Statement
|
||||
`SELECT ENAME FROM EMP WHERE EMPNO=:NUM'
|
||||
select list Item (SLI) | placeholder (P) for bind variable (BV) | |||
Select SQLDA | Bind SQLDA | |||
Set by: | Set by: | |||
SQLADR | Address of SLI name buffer | Address of P name buffer | SQLADR | |
SQLADR | Address of SLI value buffer | Address of BV value buffer | SQLADR | |
DESCRIBE | Length of SLI name buffer | Length of P name | DESCRIBE | |
DESCRIBE | Datatype of select±list item | |||
sqlald() | Length of SLI name buffer | Length of P name buffer | Program | |
Program | Length of SLI value buffer | Length of BV value buffer | Program | |
Program | Datatype of SLI value buffer | Datatype of BV value buffer | Program | |
Output Buffers | Input Buffers | |||
DESCRIBE | Name of select list item | Name of placeholder | DESCRIBE | |
FETCH | Value of select list item | Value of bind variable | Program |