Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
ALLOCATE DESCRIPTOR statementUse the ALLOCATE DESCRIPTOR statement to declare the name and allocate memory for a system-descriptor area (SDA). Use this statement with ESQL/C.
WITH MAX ClauseYou can use the WITH MAX clause to indicate the maximum number of item descriptors that the new system-descriptor area can include.

WITH MAX Clause

You can use the WITH MAX clause to indicate the maximum number of item descriptors that the new system-descriptor area can include.

When you use this clause, the COUNT field value of the system-descriptor area is set to the number of items that you specify here. If you do not specify the WITH MAX clause, the default value of the COUNT field is 100 items. You can use the SET DESCRIPTOR statement to change the value of the COUNT field.

Examples of ALLOCATE DESCRIPTOR statements

The following examples show valid ALLOCATE DESCRIPTOR statements that include the WITH MAX clause. This example uses embedded variable names to identify the system-descriptor area and to specify the maximum number of item descriptors:

EXEC SQL allocate descriptor :descname with max :occ;

The next example uses a quoted string to declare desc1 as the identifier of the system-descriptor area, and uses an unsigned integer to specify 3 as the maximum number of item descriptors in the desc1 area:

EXEC SQL allocate descriptor 'desc1' with max 3;