Index

C

column property
CONSTANT, CONSTANT of a Column
data buffer size, Specifying Data Buffer Size
data type, Data Type
OUTFILE, OUTFILE of a Column
PRESERVE BLANKS, Preserving Blanks for a Specific Column
SQL expressions, SQL Expressions
Command syntax of tbSQL utility, Executing Utility
Constraint, Constraints
User of the Same Separator, Use of the Same Separator
constraint
When the ESCAPED BY Option Is Not Specified, When the ESCAPED BY Option Is Not Specified
constraints, Constraints
control file, Control File
control file option
comment, Comment Insertion
Control File Options
APPEND|REPLACE|TRUNCATE|MERGE, Handling Existing Data
BADFILE, BADFILE
CHARACTERSET, CHARACTERSET
INFILE, INFILE
INTO TABLE, Specifying Tables
LOGFILE, LOGFILE
PRESERVE BLANKS, PRESERVE BLANKS
Control file options
FIELD ESCAPED BY, FIELDS ENCLOSED BY
FIELD OPTIONALLY ENCLOSED BY, FIELDS OPTIONALLY ENCLOSED BY
FIELD TERMINATED BY, FIELDS TERMINATED BY
IGNORE LINES, IGNORE LINES
LINES FIX, LINES FIX
LINES STARTED BY, LINES STARTED BY
LINES TERMINATED BY, LINES TERMINATED BY
POSITION, POSITION of a Column
Target Column and Properties, Target Column and Properties
TRAILING NULLCOLS, TRAILING NULLCOLS
control file options
BADFILE, BADFILE
INFILE, INFILE
INTO TABLE, Specifying Tables
LOGFILE, LOGFILE
MULTI INSERT INDEXES|FAST BUILD INDEXES, Creating Indexes
TRAILING NULLCOLS, TRAILING NULLCOLS

D

Data File
Fixed Record Format, Fixed Record Format
Separated Record Format, Separated Record Format
data file
fixed record format, Fixed Record Format
data Type
INTEGER|FLOAT|DOUBLE, Data Type
data type
CHAR, Data Type
DATE|TIMESTAMP|TIME, Data Type
RAW, Data Type

E

error file, Error File
execution order
importing the compatible table, Importing the Compatible Table
importing the data into the table that already exists, Importing Data into a Table that Already Exists
table that has constraint, Importing the Table that Has Constraints
export mode, Export Mode
full database mode, Export Mode
table mode, Export Mode
user mode, Export Mode

I

I/O file, I/O File
import mode, Import Mode
From User To User mode, Import Mode
full database mode, Import Mode
table mode, Import Mode
user mode, Import Mode
index creation method
FAST BUILD INDEX, Creating Indexes
MULTI INSERT INDEX, Creating Indexes

L

Load Method
Conventional Path Load, Load Methods
Direct Path Load, Load Methods

T

tb export, tbExport, Overview
tbExport parameter, Specifying Parameters in the Command Prompt
tbExport utility parameters, List of Parameters
tbImport, Overview
tbImport parameter, Specifying Parameters in the Command Prompt
tbImport utility parameters, List of Parameters
tbLoader , Overview
tbLoader data type
binary data type, Data Type
tbLoader execution example
fixed length record - LINES FIX, Fixed Record Format - In the Case of a Fixed Length Record
fixed record format - LINES TERMINATED BY, Fixed Record Format - When Record Separator is EOL
mass object data, When Mass Object Type Data Is Included
separated record format, Separated Record Format
tbLoader I/O File, I/O File
; Log File, Log File
Control File, Control File
Data File, Data File
Error File, Error File
tbMigrator, Overview
tbSQL, tbSQL
tbSQL accessing database, Accessing Database
tbSQL column format, Column Format
numeric type, Numeric Type
tbSQL column format, character type, Character Type
tbSQL Command, Command
tbSQL command
DISCONNECT, DISCONNECT
R[UN], RUN
tbSQL commands
!, !
[INPUT], INPUT
@, @@, @, @@
/, /
%, %
ACC[EPT], ACCEPT
C[HANGE], CHANGE
CL[EAR], CLEAR
COL[UMN], COLUMN
CONN[ECT], CONNECT
DEF[INE], DEFINE
DEL, DEL
DESC[RIBE], DESCRIBE
DISC[ONNECT], DISCONNECT
ED[IT], EDIT
EXEC[UTE], EXECUTE
EXIT, EXIT
H[ELP], HELP
HIS[TORY], HISTORY
HO[ST], HOST
L[IST], LIST
LOAD[FILE], LOADFILE
LS, LS
PAU[SE], PAUSE
PING, PING
PRI[NT], PRINT
PRO[MPT], PROMPT
Q[UIT], QUIT
SAVE CREDENTIAL, SAVE CREDENTIAL
SET, SET
SHO[W], SHOW
SPO[OL], SPOOL
STA[RT], START
TBDOWN, TBDOWN
UNDEF[INE], UNDEFINE
VAR[IABLE], VARIABLE
WHENEVER, WHENEVER
tbSQL configuration environment, Configuration Environment
tbSQL executing commands, Executing Utility
tbSQL System Variables, System Variables
tbSQL system variables
AUTOCOMMIT, AUTOCOMMIT
AUTOTRACE, AUTOTRACE
BLOCKTERMINATOR, BLOCKTERMINATOR
COLSEP, COLSEP
CONCAT, CONCAT
DDLSTATS, DDLSTATS
DEFINE, DEFINE
ECHO, ECHO
EDITFILE, EDITFILE
ESCAPE, ESCAPE
EXITCOMMIT, EXITCOMMIT
FEEDBACK, FEEDBACK
FILEEXT, FILEEXT
FILEPATH, FILEPATH
HEADING, HEADING
HISTORY, HISTORY
LINESIZE, LINESIZE
LONG, LONG
NUMFORMAT, NUMFORMAT
NUMWIDTH, NUMWIDTH
PAGESIZE, PAGESIZE
PAUSE, PAUSE
SERVEROUTPUT, SERVEROUTPUT
SQLPROMPT, SQLPROMPT
SQLTERMINATOR, SQLTERMINATOR
TERMOUT, TERMOUT
TIME, TIME
TIMEOUT, TIMEOUT
TIMING, TIMING
TRIMOUT, TRIMOUT
TRIMSPOOL, TRIMSPOOL
VERIFY, VERIFY
WRAP, WRAP
tbSQL terminating utility, Terminating Utility
tbSQL utility command, Command

U

Utility API
TBDisconnect, TBDisconnect
TBImport, TBImport
utility API
TBConnect, TBConnect
TBExport, TBExport