![Updatable cursor text error [CR 446647]](arrow-left.gif){kind=icon}
![Description of TDS in error [CR 443108]](arrow-right.gif){kind=icon}
In the section “LOAD TABLE statement” in Chapter 6, “SQL Statements,” the syntax for the FORMAT option should not contain single quotes. The correct syntax is:
LOAD [ INTO ] TABLE [ owner.]table-name
…( load-specification [, …] )
…FROM { 'filename-string' | filename-variable } [, …]
…[ CHECK CONSTRAINTS { ON | OFF } ]
…[ DEFAULTS { ON | OFF } ]
…QUOTES OFF
…ESCAPES OFF
…[ FORMAT { ascii | binary } ]
…
In the “Usage” section of the “LOAD TABLE statement” section, the fifth paragraph in the description of the QUOTES option should be replaced with the following paragraph, which does not have single quotes in the FORMAT option:
“The data extraction facility provides options for handling quotes (TEMP_EXTRACT_QUOTES, TEMP_EXTRACT_QUOTES_ALL, and TEMP_EXTRACT_QUOTE). If you plan to extract data to be loaded into an IQ table and the string fields contain column or row delimiter under default ASCII extraction, use the TEMP_EXTRACT_BINARY option for the extract and the FORMAT binary and QUOTES OFF options for LOAD TABLE.”
