altibase.txt

来自「需要了解iLoader工具的参数」· 文本 代码 · 共 22 行

1、首先你需要了解iLoader工具的参数（所有参数说明可以参见iLoader手册）
$ iloader help 
-----------------------------------------------------------------
     Altibase Data Load/Download utility.
     Release Version 4.3.9.103
     Copyright 2000, ALTIBASE Corporation or its subsidiaries.
     All Rights Reserved.
-----------------------------------------------------------------
iloader { in | out | formout | structout | help } [-T table_name] 
        [-d datafile]         [-f formatfile] 
        [-F firstrow]         [-L lastrow] 
        [-t field_term]       [-r row_term] 
        [-U|-u login_id]      [-P|-p password] 
        [-S|-s servername]    [-mode mode_type] 
        [-commit commit_unit] [-bad badfile] 
        [-log logfile]        [-e enclosing] 
        [-array count]        [-replication true/false] 
        [-split number]       [-noexp] 
        [-displayquery]       [-plus]
2、创建表tab_a的格式文件
shell>iloader formout -s 127.0.0.1 -u sys -p manager -T tab_1 -f tab_1.fmt
3、iloader in -s 127.0.0.1 -u sys -p manager -T tab_1 -d /home/altibase/wordk/tab_1.txt -f /home/altibase/work/tab_1.fmt -t "," -log logfile