Appendix D.2 Contents of the Type Name Descriptor Area

Table D-1 shows what the Type Name Descriptor Area contains.

Table D-1 Contents of the Type Name Descriptor Area

Level number*Type name area nameData typeLength (bytes)Description
1SQLTNDA[Figure]2+42[Figure]nIndicates the name of the entire Type Name Descriptor Area.
2SQLTZshort2Specifies the number of retrieval items.
2SQLTNVAR[Figure]42[Figure]nArea composed of the authorization identifier and data type identifiers.
3SQLSCHEMA[Figure]10Area storing information about the user-defined type authorization identifier.
4SQLSCHEMALshort2The authorization identifier is set in this area. 0 is set if the data type of the corresponding retrieval item is not a user-defined type.
4SQLSCHEMACchar8The authorization identifier is set in this area.
3SQLTYPE[Figure]32Area storing information about the user-defined type data type identifier.
4SQLTYPELshort2The length of the user-defined type is set in this area. 0 is set if a data type of the corresponding retrieval item is not the user-defined type.
4SQLTYPECchar30The data type identifier of the user-defined type is set in this area.
Legend:
[Figure]: Not applicable

* Level numbers indicate the set inclusion relationships of the Type Name Descriptor Area. For example, the level 2 data area is composed of the level 3 data areas.