Document Type | Technical Information
Category | Utility
Document Number | TUTTI014
Overview
This guide explains the methodology for extracting Table Data.
Method
tbexport
This method loads Table Data using the utility provided by Tibero and is only available in Tibero.
tbsql
export query
- You can specify the file name to extract to, as well as the field delimiter and line termination characters. A .dat file and a .ctl file with the specified file name will be created.
- The absolute path for the file to be extracted can be specified.
- The extracted .dat and .ctl files can be used through tbloader.
- You can filter the data to be extracted by applying a where condition.
- Data extraction from heterogeneous DBMS is possible through DBlink.
export table
- A .dat file and a .ctl file are automatically created with the table name to be extracted. (Uppercase)
- The files are created in the path where tbsql is executed.
- The extracted .dat and .ctl files can be used through tbloader.
- Extracts all data from the table.
load
- You can specify the file name to extract to, and a .dat file and a .ctl file with the specified file name will be created. (Uppercase)
- The absolute path for the file to be extracted can be specified.
- The extracted .dat and .ctl files can be used through tbloader.
- You can filter the data to be extracted by applying a where condition.
- Data extraction from heterogeneous DBMS is possible through DBlink.
spool
- You can specify the file name to extract to, and only data will be extracted to that file.
- Everything displayed on the terminal screen is saved to the file.
- The absolute path for the file to be extracted can be specified.
- You can filter the data to be extracted by applying a where condition.
- Data extraction from heterogeneous DBMS is possible through DBlink.