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™.
LOAD statementUse the LOAD statement to insert data from an operating-system file into an existing table or view.
Loading Simple Large Objects

Loading Simple Large Objects

The database server loads simple large objects (BYTE and TEXT columns) directly from the LOAD FROM file. Keep the following restrictions in mind when you load BYTE and TEXT data:

You cannot have leading and trailing blanks in BYTE fields.
Use the backslash ( \ ) to escape the special significance of literal delimiter and backslash characters in TEXT fields.
Data being loaded into a BYTE column must be in ASCII-hexadecimal form. BYTE columns cannot contain preceding blanks.
Do not use the following characters as delimiting characters in the LOAD FROM file: digits ( 0 to 9), the letters a to f, and A to F, the backslash ( \ ) character, or the NEWLINE (CTRL-J) character.

For loading TEXT columns in a non-default locale, the database server handles any required code-set conversions for the data. See also the HCL OneDB™ GLS User's Guide.

If you are unloading files that contain BYTE or TEXT data types, objects smaller than 10 kilobytes are stored temporarily in memory. You can adjust the 10-kilobyte setting to a larger setting with the DBBLOBBUF environment variable. Simple large objects that are larger than the default or the setting of DBBLOBBUF are stored in a temporary file. For more information about the DBBLOBBUF environment variable, see the HCL OneDB Guide to SQL: Reference.