602SQL Documentation Index  

Data export in 602SQL

Data export is performed in the data transfer designer. Select the table or query on the Control Panel and execute the Export data action. A wizard for the transfer design with predefined values from the source table (or query) will appear. Enter in the target file (type and name) and modify the transfer description that is automatically generated. The export design can be saved for later use.

BLOB type columns are not exported in the DBF format. When you export tables that contain CLOB type columns, a MEMO-file with the same name as the DBF file will be created. TIME type columns (even with a time zone) are exported as CHAR. TIMESTAMP type columns (even with a time zone) are exported as the DATE type by default (therefore lose the time entry). You can change this behaviour in the designer, and export them as CHAR. The TIME and TIMESTAMP columns exported as CHAR can be imported back into 602SQL without information loss (conversion from CHAR to the correct type is done automatically).

An application can be exported as a single unit. Data is exported in the internal 602SQL format.