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™.
SET DESCRIPTOR statementUse the SET DESCRIPTOR statement to set values in a system-descriptor area (SDA).
Item Descriptor
Setting the DATA or IDATA Field

Setting the DATA or IDATA Field

When you set the DATA or IDATA field, use the appropriate type of data (character string for CHAR or VARCHAR, integer for INTEGER, and so on).

If any value other than DATA is set, the value of DATA is undefined. You cannot set the DATA or IDATA field for an item without setting TYPE for that item. If you set the TYPE field for an item to a character type, you must also set the LENGTH field. If you do not set the LENGTH field for a character item, you receive an error.