This structure is used to store partitioning information, such as the
partitioning map and the partitioning key of a table.
Table 70. Fields in the SQLUPI Structure
| Field Name | Data Type | Description |
|---|---|---|
| PMAPLEN | INTEGER | The length of the partitioning map in bytes. For a single-node table, the value is sizeof(SQL_PDB_NODE_TYPE). For a multinode table, the value is SQL_PDB_MAP_SIZE * sizeof(SQL_PDB_NODE_TYPE). |
| PMAP | SQL_PDB_NODE_TYPE | The partitioning map. |
| SQLD | INTEGER | The number of used SQLPARTKEY elements; that is, the number of keyparts in a partitioning key. |
| SQLPARTKEY | Structure | The description of a partitioning column in a partitioning key. The maximum number of partitioning columns is SQL_MAX_NUM_PART_KEYS. |
Table 71 shows the SQL data types and lengths for the SQLUPI data structure. The
SQLTYPE column specifies the numeric value that represents the data type of an
item.
Table 71. SQL Data Types and Lengths for the SQLUPI Structure
| Data type | SQLTYPE (Nulls Not Allowed) | SQLTYPE (Nulls Allowed) | SQLLEN | AIX |
|---|---|---|---|---|
| Date | 384 | 385 | Ignored | Yes |
| Time | 388 | 389 | Ignored | Yes |
| Timestamp | 392 | 393 | Ignored | Yes |
| Variable-length character string | 448 | 449 | Length of the string | Yes |
| Fixed-length character string | 452 | 453 | Length of the string | Yes |
| Long character string | 456 | 457 | Ignored | No |
| Null-terminated character string | 460 | 461 | Length of the string | Yes |
| Floating point | 480 | 481 | Ignored | Yes |
| Decimal | 484 | 485 | Byte 1 = precision Byte 2 = scale | Yes |
| Large integer | 496 | 497 | Ignored | Yes |
| Small integer | 500 | 501 | Ignored | Yes |
| Variable-length graphic string | 464 | 465 | Length in double-byte characters | Yes |
| Fixed-length graphic string | 468 | 469 | Length in double-byte characters | Yes |
| Long graphic string | 472 | 473 | Ignored | No |
Language Syntax
C Structure
/* File: sqlutil.h */
/* Structure: SQLUPI */
/* ... */
SQL_STRUCTURE sqlupi
{
unsigned short pmaplen;
SQL_PDB_NODE_TYPE pmap[SQL_PDB_MAP_SIZE];
unsigned short sqld;
struct sqlpartkey sqlpartkey[SQL_MAX_NUM_PART_KEYS];
};
/* ... */
|
/* File: sqlutil.h */
/* Structure: SQLPARTKEY */
/* ... */
SQL_STRUCTURE sqlpartkey
{
unsigned short sqltype;
unsigned short sqllen;
};
/* ... */
|