![ALTER DBSPACE Example Syntax [CR #647844]](arrow-left.gif){kind=icon}
![RESTORE statement syntax correction [CR #633572]](arrow-right.gif){kind=icon}
Replace the WITH CHECKPOINT description in Reference: Statements and Options > SQL Statements > LOAD TABLE statement with:
WITH CHECKPOINT This option is useful only when loading SQL Anywhere tables in a Sybase IQ database.
Use this clause to specify whether to perform a checkpoint. The default setting is OFF. If this clause is set to ON, a checkpoint is issued after successfully completing and logging the statement. If the server fails after a connection commits and before the next checkpoint, the data file used to load the table must be present for the recovery to complete successfully. However, if WITH CHECKPOINT ON is specified, and recovery is subsequently required, the data file need not be present at the time of recovery.
The data files are required, regardless of what is specified for this clause, if the database becomes corrupt and you need to use a backup and apply the current log file.
WARNING! If you set the database option CONVERSION_ERROR to OFF, you may load bad data into your table without any error being reported. If you do not specify WITH CHECKPOINT ON, and the database needs to be recovered, the recovery may fail as CONVERSION_ERROR is ON (the default value) during recovery. It is recommended that you do not load tables when CONVERSION_ERROR is set to OFF and WITH CHECKPOINT ON is not specified.
See also Reference: Statements and Options > Database Options > Alphabetical list of options > CONVERSION_ERROR option [TSQL].
For information regarding automatic recovery of Sybase IQ data, see System Administration Guide: Volume 1 > System Recovery and Database Repair.
