Sybase recommends that you run this procedure to avoid the SQL syntax problems that cause failures.
unloadold.sql
unload.sql
optdeflt.sql
opttemp.sql
iqunload –n –c "UID=DBA;PWD=SQL;ENG=my_eng;DBN=my_dbname".The schema unload produces a reload.sql script that contains the schema for the database being migrated in the directory from which you ran the unload.
-- CREATE DATABASE command: CREATE DATABASE '/iq-15/unload/127/db/iq127db.db' LOG ON '/iq-15/unload/127/db/iq127db.log' CASE IGNORE ACCENT IGNORE PAGE SIZE 4096 COLLATION 'ISO_BINENG' BLANK PADDING ON JCONNECT OFF CHECKSUM OFF IQ PATH 'iq127db.iq' IQ SIZE 50 TEMPORARY PATH 'iq127db.iqtmp' TEMPORARY SIZE 25 MESSAGE PATH 'iq127db.iqmsg' IQ PAGE SIZE 131072 BLOCK SIZE 8192
Running the reload.sql script does not execute the sample statement, but you can use this generated statement as a template when you create your database with Sybase IQ 15.4.