A select descriptor before the FETCH is desccribed below
| Empty column to indicate seperation of descriptor from Data Buffers | Data Buffers | |||
| SQLDNUM | 3 | (Set by program) | ||
| SQLDFND | 3 | |||
| S1.SQLDV | ||||
| S2.SQLDV | ||||
| S3.SQLDV | ||||
| 1,2,3,4,5,6,7,8,9,10 | ||||
| S1.SQLDVLN | 10 | SEL_DV | ||
| S2.SQLDVLN |
6 |
(Set by program) | ||
| S3.SQLDVLN |
9 |
(Set by program) | ||
| S1.SELDVTYP | 1 | (Set by program) | ||
| S2.SELDVTYP | 1 | (Set by program) | ||
| S3.SELDVTYP | 1 | (Set by program) | ||
| SEL_DI | ||||
| S1.SQLDI | 0 | |||
| S2.SQLDI | 0 | |||
| S3.SQLDI | 0 | |||
| 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 | |||