SQLRETURN SQL_API
TBConnect(SQLCHAR *dnsname, SQLCHAR *username, SQLCHAR *pwd, 
          struct sqlca *pSqlca);

SQLRETURN SQL_API
TBDisconnect(SQLCHAR *dnsname, struct sqlca *pSqlca);

SQLRETURN SQL_API
TBExport(SQLINTEGER versionNumber, TBExportStruct *pParamStruct, 
         struct sqlca *pSqlca);

#include "tbutil.h"

#define DNS_NAME "DEFAULT"
#define USER_NAME "SYS" 
#define PWD "tibero"

int main(int argc, char *argv[]) 
{ SQLRETURN rc = SQL_SUCCESS;
  SQLINTEGER versionNumber = 1; 
  SQLCHAR dataFileName[256];
  SQLCHAR actionString[256];
  SQLCHAR msgFileName[256];
  SQLCHAR fieldTerm[5];
  SQLCHAR lineTerm[5];
  SQLCHAR enclStart[5];
  SQLCHAR enclEnd[5];

  struct sqlca ca            = {"\0", 0, 0, {0, "\0"}, "\0",
                                {0, 0, 0, 0, 0, 0}, "\0", "\0"};
  TBExportStruct exportStruct = {NULL, 0, NULL, NULL, NULL, 0, NULL,
                                0, NULL, NULL};
  TBExportIn exportIn = {{NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0}};

  TBExportOut exportOut = {0};

  rc= TBConnect((SQLCHAR *)DNS_NAME, (SQLCHAR *)USER_NAME, (SQLCHAR *)PWD, &ca);

  if (rc != SQL_SUCCESS) return -1;

  strcpy((char *)dataFileName, "./all_tables.dat"); 
  strcpy((char *)actionString, "select * from all_tables"); 
  strcpy((char *)msgFileName, "./all_tables.log"); 
  strcpy((char *)fieldTerm, ",");
  strcpy((char *)lineTerm, "\n"); 
  strcpy((char *)enclStart, "\""); 
  strcpy((char *)enclEnd, "\"");
  
  /* setting data file name */
  exportStruct.piDataFileName = dataFileName; 
  exportStruct.iDataFileNameLen = strlen((char *)dataFileName);
  
  /* setting action String */
  exportStruct.piActionString = calloc(1, sizeof(sqlstr)); 
  exportStruct.piActionString->data = actionString; 
  exportStruct.piActionString->length = strlen((char *)actionString);
  
  /* setting file type */ 
  exportStruct.iFileType = SQL_DEL;
  
  /* setting message file name */ 
  exportStruct.piMsgFileName = msgFileName;
  exportStruct.iMsgFileNameLen = strlen((char *)msgFileName);
  
  /* setting field term, line term etc.. */ 
  exportIn.iMeta.fieldTerm = fieldTerm; 
  exportIn.iMeta.fieldTermLen = strlen((char *)fieldTerm); 
  exportIn.iMeta.lineTerm = lineTerm; 
  exportIn.iMeta.lineTermLen = strlen((char *)lineTerm); 
  exportIn.iMeta.enclStart = enclStart; 
  exportIn.iMeta.enclStartLen = strlen((char *)enclStart); 
  exportIn.iMeta.enclEnd = enclEnd; 
  exportIn.iMeta.enclEndLen = strlen((char *)enclEnd);
  
  /* setting export input, output information */ 
  exportStruct.piExportInfoIn = &exportIn; 
  exportStruct.poExportInfoOut = &exportOut;
  
  /* setting file type */
  rc = TBExport(versionNumber, &exportStruct, &ca); 
  if (rc != SQL_SUCCESS) return -1;
  
  /* disconnect */
  rc= TBDisconnect((SQLCHAR *)DNS_NAME, &ca);
  if (rc != SQL_SUCCESS) return -1;
  
  return 1;
}

SQLRETURN SQL_API TBImport(SQLINTEGER versionNumber,
                                TBImportStruct *pParamStruct, 
                                struct sqlca *pSqlca);

#include "tbutil.h"

#define DNS_NAME "DEFAULT"
#define USER_NAME "SYS" 
#define PWD "tibero"

int main(int argc, char *argv[]) 
    { SQLRETURN         rc = SQL_SUCCESS;
    SQLINTEGER          versionNumber = 1; 
    SQLCHAR             dataFileName[256];
    SQLCHAR             actionString[256];
    SQLCHAR             msgFileName[256];
    SQLCHAR             badFileName[256];
    SQLCHAR             fieldTerm[5];
    SQLCHAR             lineTerm[5];
    SQLCHAR             enclStart[5];
    SQLCHAR             enclEnd[5];
    SQLCHAR             escape[5];
    
    struct sqlca ca = {"\0", 0, 0, {0, "\0"}, "\0",
                      {0, 0, 0, 0, 0, 0}, "\0", "\0"};
    TBImportStruct importStruct = {NULL, 0, NULL, NULL, NULL, 0, NULL,
                                    0, NULL, 0, 0, NULL, NULL};
    TBImportIn importIn = {{NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0},
                            0, 0, 0, 0};
    TBImportOut importOut = {0, 0, 0, 0, 0, 0};
    
rc= TBConnect((SQLCHAR *)DNS_NAME, (SQLCHAR *)USER_NAME, (SQLCHAR *)PWD, &ca);
if (rc != SQL_SUCCESS) return -1;

strcpy((char *)actionString, "LOAD DATA "
                             "APPEND "
                             "INTO TABLE DEPT " 
                             "MULTI INSERT INDEXES "
                             "(position, deptno, dname CONSTANT \"co dep\", loc)");
                             
    strcpy((char *)dataFileName, "./test.dat"); 
    strcpy((char *)msgFileName, "./test.log"); 
    strcpy((char *)badFileName, "./test.bad"); 
    strcpy((char *)fieldTerm, ",b"); 
    strcpy((char *)lineTerm, "abbb\n"); 
    strcpy((char *)enclStart, "{$"); 
    strcpy((char *)enclEnd, "$}"); 
    strcpy((char *)escape, "XX");
    
    /* setting data file name */ 
    importStruct.piDataFileName = dataFileName;
    importStruct.iDataFileNameLen = strlen((char *)dataFileName);
    
    /* setting action String */
    importStruct.piActionString = calloc(1, sizeof(sqlstr)); 
    importStruct.piActionString->data = actionString; 
    importStruct.piActionString->length = strlen((char *)actionString);
    
    /* setting file type */ 
    importStruct.iFileType = SQL_DEL;
    
    /* setting message file name */ 
    importStruct.piMsgFileName = msgFileName;
    importStruct.iMsgFileNameLen = strlen((char *)msgFileName);
    
    /* setting bad data file name */ 
    importStruct.piBadFileName = badFileName;
    importStruct.iBadFileNameLen = strlen((char *)badFileName);
    
    /* turn on DPL mode */
    importStruct.iDPL                     = 2;
    
    /* setting field term, line term etc.. */ 
    importIn.iMeta.fieldTerm = fieldTerm; 
    importIn.iMeta.fieldTermLen = strlen((char *)fieldTerm); 
    importIn.iMeta.lineTerm = lineTerm; 
    importIn.iMeta.lineTermLen = strlen((char *)lineTerm); 
    importIn.iMeta.enclStart = enclStart; 
    importIn.iMeta.enclStartLen = strlen((char *)enclStart); 
    importIn.iMeta.enclEnd = enclEnd; 
    importIn.iMeta.enclEndLen = strlen((char *)enclEnd); 
    importIn.iMeta.escape = escape;
    importIn.iMeta.escapeLen = strlen((char *)escape);
    
    importIn.iRowcount                     = 0;   
    importIn.iSkipcount                    = 0;
    importIn.iCommitcount                  = 2;
    importIn.iErrorcount                   = 50;
    
    /* setting export input, output information */ 
    importStruct.piImportInfoIn = &importIn; 
    importStruct.poImportInfoOut = &importOut;

    /* setting file type */
    rc = TBImport(versionNumber, &importStruct, &ca); 
    if (rc != SQL_SUCCESS) return -1;

        fprintf(stdout, "oRowsRead[%ld]", importOut.oRowsRead); 
        fprintf(stdout, "oRowsSkipped[%ld]", importOut.oRowsSkipped); 
        fprintf(stdout, "oRowsInserted[%ld]", importOut.oRowsInserted); 
        fprintf(stdout, "oRowsUpdated[%ld]", importOut.oRowsUpdated); 
        fprintf(stdout, "oRowsRejected[%ld]", importOut.oRowsRejected); 
        fprintf(stdout, "oRowsCommitted[%ld]", importOut.oRowsCommitted);

        /* disconnect */
        rc= TBDisconnect((SQLCHAR *)DNS_NAME, &ca); 
        if (rc != SQL_SUCCESS) return -1;

        return 1;

  }

tblibver libtbcli.so
Tibero 7 (DB 7.2.4 FS02_PS04) Build 310352

Linux bistro-build-centos_7 5.15.0-134-generic #145~20.04.1-Ubuntu SMP Mon Feb 17 13:27:16 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)

Patch files (FS02PS_700093a FS02PS_700103a FS02PS_344166f FS02PS_700110a FS02PS_342949f FS02PS_700006a FS02PS_342949g FS02PS_308549f FS02PS_191464v FS02PS_700138a FS02PS_700049a FS02PS_346475a FS02PS_342949h FS02PS_344166g FS02PS_700062a FS02PS_308549g FS02PS_345180d FS02PS_700028b FS02PS_346438a FS02PS_700355a)

tblibver -v libtbcli.so

Tibero 7 (DB 7.2.4 FS02_PS04) Build 310352
Linux bistro-build-centos_7 5.15.0-134-generic #145~20.04.1-Ubuntu SMP Mon Feb 17 13:27:16 UTC 2025 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)

Patch files (FS02PS_700093a FS02PS_700103a FS02PS_344166f FS02PS_700110a FS02PS_342949f FS02PS_700006a FS02PS_342949g FS02PS_308549f FS02PS_191464v FS02PS_700138a FS02PS_700049a FS02PS_346475a FS02PS_342949h FS02PS_344166g FS02PS_700062a FS02PS_308549g FS02PS_345180d FS02PS_700028b FS02PS_346438a FS02PS_700355a)
Compiled with "cc -ggdb -fstack-protector-all -fno-strict-aliasing -fno-omit-frame-pointer -pipe -O3 -D_OPT_COMPILED -U_FORTIFY_SOURCE -D_USE_VIP -Wall -W -Werror-implicit-function-declaration -Wno-unused-parameter -Wpointer-arith -Wdeclaration-after-statement -DHAVE_CONFIG_H -D_WORDSIZE=64 -D_OS_LINUX -D_LINUX_X86_64 -D_X86 -DUSE_ASSERT -DTSAM -DTSAM_NO_ESDS_SEQUENCE -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_USE_FSYNC -D_CHECK_LICENSE -D_STBLOG -D_TAC -DFD_SETSIZE=8192 -D_CM_OBSERVER -D_USE_FALLOCATE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -D_GNU_SOURCE -DHAVE_EPOLL"

Compiled at Feb 11 2026 10:47:23 build seq 310352 init rev {2023-11-24}

tblibver nonexistent.so
Error: Cannot load library 'nonexistent.so'
nonexistent.so: cannot open shared object file: No such file or directory

tblibver notsupported.so
Error: Library 'notsupported.so' does not support version information

FULL=Y

USER=SCOTT, USER1, …

TABLE=SCOTT.EMP, USER1.TABLE1, …

$ tbexport username=tibero password=tmax sid=tibero file=export.dat full=y
$ tbexport cfgfile=export.cfg

tbExport 7.0 102665 TmaxData Corporation Copyright (c) 2008-. All rights reserved.
Usage: tbexport [options] [parameter=value parameter=value ...]

Options:
  -h|--help       Display the more detailed information.
  -v|--version    Display the version information.
  -p|--patch      Display the binary's patch information.

Parameters:
  CFGFILE             Config file name
  COMPRESS            Compress Mode: Y/N, default: N
  CONSTRAINT          Export Constraint: Y/N, default: Y
  CONSISTENT          Consistent Mode: Y/N, default: N
  ENCRYPTION          Specifies a Encryption Mode
  ENCRYPTION_PASSWORD Specifies a password for encrypting data
                      in the export Dump File
  EXCLUDE             Limit the export to specific objects
  FILE                Export dump file name, default: default.dat
  FULL                Full Mode: Y/N, default: N
  GEOM_ASBYTES        Export the geometry columns as bytes, default: N
  GRANT               Export Grant: Y/N, default: Y
  INCLUDE             Export specific object types
  INDEX                Export Index: Y/N, default: Y
  INLINE_CONSTRAINT    Use the Inline Constraint: Y/N, default: N
                     (this option is only supported for the not null)
  IP                   IP address, default: localhost
  LOG                  Export script log file name
  LOGDIR               Export log directory
  NO_PACK_DIR          Export unpacked dump files to specified directory.
                     If this option is specified, FILE parameter will be ignored.
  OVERWRITE            Overwrite datafile if same file name exists: Y/N, default: N
  PACK_TYPE            Packing algorithm: TAR/ZIP, default: TAR
  PASSWORD             User password
  PORT                 PORT number, default: 8629
  QUERY                Where predicate: (Optional) to filter data to be exported
                     (must be used with TABLE parameter.)
  REMAP_TABLESPACE     Remaps the objects from the source tablespace to the target
                     tablespace.
  REMAP_TABLE          Remaps the objects from the source table to the target table.
  REMOVE_REPLACE       Use "CREATE" instead of "CREATE OR REPLACE" default: N
  ROWS                 Export Table Rows: Y/N, default: Y
  SAVE_CREDENTIAL      Save your username and password to specified file
  SCRIPT               LOG THE DDL SCRIPT: Y/N, default: N
  SID                  Database name
  TABLE                Table Mode: table name list
                       Append :<Partition Name> to select a single partition (Optional)  
  TEMP_DIR             Directory for the temporary raw dump files.
  THREAD_CNT           Thread Count, default: 4
  USER                 User Mode: user name list
  USERNAME             Database user name
  NOVALIDATE           NOVALIDATE: Y/N , default: N
  INDEX_PARALLEL_DEGREE  Option of index parallel degree, default: 0 (NOPARALLEL)

PARAMETER=value 
PARAMETER=value1, ...

FULL=Y 
FILE=EXPORT.DAT 
GRANT=Y
INDEX=Y 
CONSTRAINT=Y

full mode: tablespace, role, directory, schema, sys_privs, public_dblink,
           public_synonym, sys_dblink, user
user mode: type, job, psm (function, trigger, procedure, package, package_body,
           type_body), obj_privs, sequence, table, dblink, synonym, view, materialized_view,
           materialized_view_log, library,tablespace_quota,scheduler(scheduler_job,
           scheduler_chain, scheduler_chain_step,scheduler_chain_rule, scheduler_program)
table mode: constraint, index

tbExport 7.0 97668 TmaxData Corporation Copyright (c) 2008-. All rights reserved.
the entire database: Fri Feb 06 10:45:16 KST 2015
Export character set: MS949
  exporting tablespaces
  exporting roles
  exporting schema: "TIBERO"
  exporting tables
    [0] exporting table BONUS     no rows exported.
    [1] exporting table DEPT      4 rows exported.
    [2] exporting table EMP       10 rows exported.
    [3] exporting table SALGRADE  5 rows exported.
  exporting object privileges
  exporting indexes
  exporting sequences
  exporting views
  exporting synonyms
Packing the file...
Export completed successfully: Fri Feb 06 10:46:17 KST 2015

example.ctl:
        LOAD DATA
        INFILE 'example.dat' 
        LOGFILE 'example.log' 
        BADFILE 'example.bad' 
        APPEND
        INTO TABLE EMP 
        LINES FIX 12
        (
                empno position (01:04),
                ename position (06:12)
        )
        
        example.dat:
        7922 MILLER 7777 KKS        7839 KING 7934 MILLER 7566 JONES

example.ctl:
    LOAD DATA
    INFILE 'example.dat' 
    LOGFILE 'example.log' 
    BADFILE 'example.bad' 
    APPEND
    INTO TABLE EMP 
    TRAILING NULLCOLS 
    (
        empno position (01:04),
        ename position (06:15),
        job   position (17:25),
        mgr   position (27:30),
        sal   position (32:39)
    )

example.dat:
    7922 MILLER	    CLERK	7782	920.00
    7777 KKS	    CHAIRMAN		
    7839 KING	    PRESIDENT		5500.0
    7934 MILLER	    CLERK	7782	920.00
    7566 JONES	    MANAGER	7839	3123.75
    7658 CHAN	    ANALYST	7566	3450.00
    7654 MARTIN	    SALESMAN	7698	1312.50

example.ctl: 
    LOAD DATA
    INFILE 'example.dat' 
    LOGFILE 'example.log' 
    BADFILE 'example.bad' 
    APPEND
    INTO TABLE emp
    FIELDS TERMINATED BY ',' 
            OPTIONALLY ENCLOSED BY '"' 
            ESCAPED BY '\\'
    LINES TERMINATED BY '\n' 
    (
        empno, 
        ename, 
        job, 
        mgr,
        hiredate, 
        sal, 
        comm, 
        deptno
    )

example.dat:
    7654, "Martin", "Sales",7698,1981/10/28,1312.50,3,10
    7782, "\,Clark","Manager" ,7839, 1981/01/11 ,2572.50,10,20
    7839, "King",President,,1981/11/17,5500.00,,10
    7934,"Miller","Clerk",7782 ,1977/10/12,920.00,,10
    7566, "Jones",Manager" ,7839, 1981/04/02,3123.75,,20
    7658, "Chan", Ana lyst, 7566,1982/05/03,3450,,20

FIELDS  TERMINATED BY '"' 
        OPTIONALLY ENCLOSED BY '"'

example.ctl:
    FIELDS TERMINATED BY ',' 
    (ID, NAME)
    
example.dat:
    7654,Martin, Kim

grant lock any table to 수행 user;

-17004: Permission denied

" aaa \t" -> " aaa"

/" aaa \t" -> "aaa"

$ tbloader userid=db_user/db_password@default 
control=sample.ctl data=sample.data direct=Y parallel=2

$ export LR_WALLET_PATH=./wallet_file.dat

$ tbloader control=sample.ctl data=sample.data

$ export LD_MEM_PROTECT=N

$ export TBCLI_DPL_COMPRESSION_LEVEL= -1

_USE_DPL_MSG_COMPRESSION=Y (기본값 N)

LOAD DATA
    [CHARACTERSET characterset_name] 
    [BYTEORDER endian_type]
    [INFILE data_file_name]
    [LOGFILE log_file_name] 
    [BADFILE bad_file_name] 
    [DISCARDFILE discard_file_name] 
    [SKIP_ERRORS error_number, ...]
    [APPEND|REPLACE|TRUNCATE|MERGE(column_name,	)]
    [PRESERVE BLANKS]
    INTO TABLE table_name
    [WHEN filter_expression [AND filter_expression	]]
    [MULTI INSERT INDEXES|FAST BUILD INDEXES]
    [FIELDS [TERMINATED BY field_terminator]
            [OPTIONALLY ENCLOSED BY enclosed_by_start_string
                                [AND enclosed_by_end_string]] 
            [ESCAPED BY escaped_by_string]]
    [LINES [FIX number]
        [STARTED BY line_start_string] 
        [TERMINATED BY line_terminator_string]]
    [TRAILING NULLCOLS]
    [IGNORE number LINES] 
    (column_name [FILLER]
                 [POSITION(from:to)]
                 [INTEGER EXTERNAL(size)	        |
                  FLOAT EXTERNAL(size)	                |
                  DOUBLE EXTERNAL(size)	                |
                  CHAR(size)	                        |
                  RAW(size)	                        |
                  DATE(size) date_fmt_string	        | 
                  TIMESTAMP(size) timestamp_fmt_string  | 
                  TIME(size) time_fmt_string]
                  [OUTFILE]
                  [CONSTANT constant_value] 
                  [NULL TERMINATED] 
                  [PRESERVE BLANKS]
                  [sql_expression]
                  [NULLIF cond_expression], ..........)
-- This line is comment.

CHARACTERSET characterset_name

CHARACTERSET MSWIN949

BYTEORDER endian_type

BYTEORDER BIG ENDIAN

INFILE data_file_name

INFILE '/home/test/data.dat' 
INFILE '../data.dat'

LOGFILE log_file_name

LOGFILE '/home/test/control.log' 
LOGFILE '../control.log'

BADFILE bad_file_name

BADFILE '/home/test/data.bad' 
BADFILE '../data.bad'

DISCARDFILE discard_file_name

DISCARDFILE '/home/test/data.dsc' 
DISCARDFILE '../data.dsc'

SKIP_ERRORS error_number, ...

SKIP_ERRORS -10007
SKIP_ERRORS -10007, -10005

APPEND|REPLACE|TRUNCATE|MERGE(column_name, )

control.ctl:
    LOAD DATA
    ... 
    REPLACE
    ... 
    (...)

control.ctl:
    LOAD DATA
    ...
    MERGE(EMPNO, EMPNM)
    ... 
    (...)

PRESERVE BLANKS

control.ctl:
    LOAD DATA
    ...
    PRESERVE BLANKS
    ... 
    (...)

INTO TABLE table_name

control.ctl:
    LOAD DATA
    ...
    INTO TABLE EMP
    ... 
    (...)

WHEN filter_expression [AND filter_expression...]

filter_expression:
    {column_name|'('column_pos')'} operator {value_string|BLANKS}

control.ctl:
    LOAD DATA
    ...
    INTO TABLE EMP 
    WHEN C1 = '1'
    ... 
    (...)

[MULTI INSERT INDEXES|FAST BUILD INDEXES]

control.ctl:
    LOAD DATA
    ...
    MULTI INSERT INDEXES
    ... 
    (...)

FIELDS TERMINATED BY field_terminator

control.ctl:
    LOAD DATA
    ...
    FIELDS TERMINATED BY ','
    ... 
    (...)

FIELDS OPTIONALLY ENCLOSED BY enclosed_by_start_string

control.ctl:
    LOAD DATA
    ...
    FIELDS OPTIONALLY ENCLOSED BY '"'
    ... 
    (...)

control.ctl:
    LOAD DATA
    ...
    FIELDS OPTIONALLY ENCLOSED BY '{$' AND '$}'
    ... 
    (...)

control.ctl:
    LOAD DATA
    ...
    FIELDS OPTIONALLY ENCLOSED BY '"' 
        ESCAPED BY '\\'
    ... 
    (...)

”quotation mark[\”]”,0001→(quotation 
mark["],0001)”quotation mark[”]”,0001→오류 발생

FIELDS ESCAPED BY escaped_by_string

FIELDS ESCAPED BY '\\'
FIELDS ESCAPED BY '$$!'

LINES FIX number

control.ctl:
    LOAD DATA
    ...
    LINES FIX 5
    ... 
    (...)

data.dat: 
abcdefghijklmnopqrst

LINE #1: abcde
LINE #2: fghij
LINE #3: klmno
LINE #4: pqrst

LINES STARTED BY line_start_string

control.ctl:
    LOAD DATA
    ...
    LINES STARTED BY '$$$'
    ... 
    (...)

data.dat:
$$$0001,”SMITH”
…something … $$$0002,”DAVID”

(0001, “SMITH”), (0002, “DAVID”)

LINES TERMINATED BY line_terminator_string

control.ctl:
    LOAD DATA
    ...
    LINES TERMINATED BY '|\n'
    ... 
    (...)

TRAILING NULLCOLS

control.ctl:
    LOAD DATA
    ...
    TRAILING NULLCOLS
    ... 
    (
    id, 
    name, 
    job
    )

data.dat:
    10 SMITH

IGNORE number LINES

control.ctl:
    LOAD DATA
    ...
    IGNORE 1 LINES
    ...
    (...)

UNORDERED

control.ctl: LOAD DATA ...
        UNORDERED ... ( c1 position (03:04), c2 position (01:02)
        )

(column_name [FILLER]
             [POSITION(from:to)] 
             [INTEGER EXTERNAL(size)                          |
              FLOAT EXTERNAL(size)                            |
              DOUBLE EXTERNAL(size)                           |
              CHAR(size)                                      |
              RAW(size)                                       |
              DATE(size) date_fmt_string                      |
              TIMESTAMP(size) timestamp_fmt_string            | 
              TIME(size) time_fmt_string]
              [OUTFILE]
              [CONSTANT constant_value] 
              [NULL TERMINATED] 
              [PRESERVE BLANKS]
              [sql_expression]
              [NULLIF cond_expression],..........)

FILLER

control.ctl:
    LOAD DATA
    ... 
    (
        empno         position (01:04),
        ename         position (06:15), 
        job     filler position (17:25), 
        mgr           position (27:30),
        sal           position (32:39),
        comm          position (41:48),
        deptno        position (50:51)
)

control.ctl:
    LOAD DATA
    ... 
    (
        empno, 
        ename,
        job filler, 
        mgr,
        sal, 
        comm, 
        deptno
    )

POSITION(from:to)

control.ctl:
    LOAD DATA
    ... 
    (
        empno     position (01:04),
        ename     position (06:15),
        job       position (17:25),
        mgr       position (27:30),
        sal       position (32:39),
        comm      position (41:48),
        deptno    position (50:51)
    )

control.ctl:
    LOAD DATA
    ... 
    (
        empno, 
        ename, 
        job, 
        mgr, 
        sal, 
        comm, 
        deptno
)

INTEGER EXTERNAL(size)|FLOAT EXTERNAL(size)|DOUBLE EXTERNAL(size)

CHAR(size)

RAW(size)

DATE date_fmt_string|TIMESTAMP timestamp_fmt_string|TIME time_fmt_string

control.ctl:
LOAD DATA
.....
INFILE 'data.dat'
.....
(
    empno,
    ename,
    hiredate DATE "YYYYMMDD"
)

data.dat:
1111, JOHN, 19981112
2222, TOM,  20070802

control.ctl:
    LOAD DATA
    ....
    (
        empno INTEGER EXTERNAL(5),
        hiredate DATE(10) "YYYY/MM/DD"
    )

control.ctl:
    LOAD DATA
    .....
    INFILE 'data.dat'
    ..... 
    (
        empno, 
        ename,
        resume OUTFILE
    )

data.dat
1111, JOHN, ./clobdata.txt
2222, TOM, /home/test/clobdata.txt

control.ctl:
    LOAD DATA
    .....
    INFILE 'data.dat'
    ..... 
    (
        empno constant "1234", 
        ename
    )

control.ctl:
    LOAD DATA
    ... 
    (
        empno PRESERVE BLANKS,
        ename
    )

control.ctl:
    LOAD DATA
    ...
    (
        empno "TO_CHAR(SYSDATE, 'YYYYMMDD')",
        ename ":empno"
    )

NULLIF {column_name|'('column_pos')'} operator {value_string|BLANKS}

control.ctl:
    LOAD DATA
    ... 
    (
        empno CHAR,
        ename CHAR NULLIF empno = '0'
    )

-- This is comment for control file.

$ tbloader
tbLoader 7

TmaxData Corporation Copyright (c) 2008-. All rights reserved.

Usage: tbloader [options] [controls]


Options:
  -h|--help        Display the more detailed information.
  -c|--charset     Display usable character sets in this version.
  -v|--version     Display the version information.


Controls:
  userid           Username/password@dbname
  control          The name of the control file
  data             The name of the data file
  log              The name of the log file
  bad              The name of the bad file
  discard          The name of the discard file
  skip             The count of line to skip in data file      (Default: 0)
  errors           The count of error to allow                 (Default: 50)
  rows             The count of row for each commit            (Default: commit after the end)
  message          The count of records to process to print out(Default: 0)
  readsize         The size of buffer to read from the data file
                   (Default: 65536)
  disable_idx      Whether to disable indexes before loading   (Default: N)
  direct           Whether to use the Direct Path Loading      (Default: N)
  dpl_log          Whether to log about the Direct Path Loading(Default: N)
  parallel         The count of threads to execute Parallel Direct Path Loading
                   (Default: 1)
  bindsize         The size of buffer to read in the Direct Path Loading
                   (Default: 65536)
  syntax           Control file syntax (Default : tibero)

  dpl_parallel     Deprecated
  multithread      Deprecated


Example:
  tbloader userid=userId/passwd@dbname control=sample.ctl bindsize=100000

userid=userid/passwd@dbname

control=/home/test/control.ctl 
control=../control.ctl

log=/home/test/control.log 
log=../control.log

data=/home/test/data.dat 
data=../data.dat

bad=/home/test/data.bad 
bad=../data.bad

discard=/home/test/data.dsc 
discard=../data.dsc

skip=1 
direct=Y 
dpl_log=Y 
message=10000 
readsize=65536 
bindsize=65536 
errors=100
rows=100 
parallel=2

CREATE TABLE MEMBER 
(
    ID           NUMBER(4) NOT NULL,
    NAME         VARCHAR2(10),
    JOB          VARCHAR2(9), 
    BIRTHDATE DATE,
    CITY         VARCHAR2(10), 
    PICTURE      BLOB,
    AGE          NUMBER(3),
    RESUME       CLOB
);

CREATE TABLE CLUB
(
    ID           NUMBER(6) NOT NULL,
    NAME         VARCHAR2(10),
    MASTERID     NUMBER(4)
);

LOAD DATA
INFILE './data.dat'
APPEND
INTO TABLE club
FIELDS TERMINATED BY ','
        OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '|\n'
IGNORE 1 LINES
(
    id integer external,
    name,
    masterid integer external
)

id  name                masterid|
111111,FC-SNIFER,2345|
dkkkkkkkkkk|
111112,"DOCTOR CLUBE ZZANG",2222|
111113,"ARTLOVE",3333|
111114,FINANCE,1235|
111115,"DANCE MANIA",2456|
111116,"MUHANZILZU",2378|
111117,"INT'L",5555|