Loading Simple Large Objects
- 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.