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™.
PUT statementUse the PUT statement to store a row in an insert buffer for later insertion into the database.
Supplying Inserted Values

Supplying Inserted Values

The values in the inserted row can come from one of the following sources:

Constant values that are written into the INSERT statement
Program variables that are named in the INSERT statement
Program variables in the FROM clause of the PUT statement
Values that are prepared in memory addressed by an sqlda structure or a system-descriptor area and then specified in the USING clause of the PUT statement

The system descriptor area or sqlda structure that descriptor or sqlda_pointer references must define a data type and memory location of each value that corresponds to a question-mark ( ? ) placeholder in a prepared INSERT statement.