Example showing a Select Descriptor After the FETCH
| Empty column to indicate seperation of descriptor from Data Buffers | Data Buffers | ||
| SQLDNUM | 3 | ||
| SQLDFND | 3 | ||
| S1.SQLDV | MARTIN, , , , | ||
| S2.SQLDV | , , 7,6,5,4, , , , | ||
| S3.SQLDV | , , , 4,8,2,.,5,0,, | ||
| 1,2,3,4,5,6,7,8,9,10 | |||
| S1.SQLDVLN | 10 | SEL_DV | |
| S2.SQLDVLN |
6 |
||
| S3.SQLDVLN |
9 |
||
| S1.SELDVTYP | 1 | ||
| S2.SELDVTYP | 1 | ||
| S3.SELDVTYP | 1 | ||
| SEL_DI | |||
| S1.SQLDI | 0 (set by FETCH) | ||
| S2.SQLDI | 0 (set by FETCH) | ||
| S3.SQLDI | 0 (set by FETCH) | ||
| S1.SQLDH±VNAME | E N A M E | ||
| S2.SQLDH±VNAME | E M P N O | ||
| S3.SQLDH±VNAME | C O M M | ||
| 1 2 3 4 5 | |||
| SEL_DH_VNAME | |||
| S1.SQLDH±MAX±VNAMEL | 5 | ||
| S2.SQLDH±MAX±VNAMEL | 5 | ||
| S3.SQLDH±MAX±VNAMEL | 5 | ||
| S1.SQLDH±CUR±VNAMEL | 5 | ||
| S2.SQLDH±CUR±VNAMEL | 5 | ||
| S3.SQLDH±CUR±VNAMEL | 4 |