Nonstop Database, HiRDB Version 9 UAP Development Guide
The following table shows the contents of the Type Name Descriptor Area.
Table D-1 Contents of the Type Name Descriptor Area
Level number# | Type name area name | Data type | Length (bytes) | Description |
---|---|---|---|---|
1 | SQLTNDA | -- | 2+ 42 x n | Indicates the name of the entire Type Name Descriptor Area. |
2 | SQLTZ | short | 2 | Specifies the number of retrieval items. |
2 | SQLTNVAR | -- | 42 x n | Area composed of the authorization identifier and data type identifiers. |
3 | SQLSCHEMA | -- | 10 | Area storing information about the user-defined type authorization identifier. |
4 | SQLSCHEMAL | short | 2 | The 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. |
4 | SQLSCHEMAC | char | 8 | The authorization identifier is set in this area. |
3 | SQLTYPE | -- | 32 | Area storing information about the user-defined type data type identifier. |
4 | SQLTYPEL | short | 2 | The 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. |
4 | SQLTYPEC | char | 30 | The data type identifier of the user-defined type is set in this area. |
#: 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.
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.