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 | |