Index

C

column property
CONSTANT, CONSTANT Clause
data buffer size, Data Buffer Size
data type, Data Type
FILLER, FILLER Clause
NULLIF, NULLIF Clause
OUTFILE, OUTFILE Clause
POSITION, POSITION Clause
PRESERVE BLANKS, Preserving Blanks
SQL expression, SQL Expression
Command syntax of tbSQL utility, Executing Utility
constraint, Constraints
Duplicate Delimiter Values, Duplicate Delimiter Values
When the ESCAPED BY Option is Not Specified, When ESCAPED BY Option is Not Specified
When the Table Owner and User are Different, When Table Owner and User are Different
control file, Control File
Control File Option
WHEN, Specifying Loading Conditions
control file option
APPEND|REPLACE|TRUNCATE|MERGE, Processing Existing Data
BADFILE, BADFILE
CHARACTERSET, CHARACTERSET
comment, Comment
DISCARDFILE, DISCARDFILE
FIELD ESCAPED BY, FIELDS ESCAPED BY
FIELD OPTIONALLY ENCLOSED BY, FIELDS OPTIONALLY ENCLOSED BY
FIELD TERMINATED BY, FIELDS TERMINATED BY
IGNORE LINES, IGNORE LINES
INFILE, INFILE
INTO TABLE, Specifying Tables
LINES FIX, LINES FIX
LINES STARTED BY, LINES STARTED BY
LINES TERMINATED BY, LINES TERMINATED BY
LOGFILE, LOGFILE
MULTI INSERT INDEXES|FAST BUILD INDEXES, Creating Indexes
PRESERVE BLANKS, PRESERVE BLANKS
SKIP_ERRORS, SKIP_ERRORS
Target Column and Properties, Columns and Properties
TRAILING NULLCOLS, TRAILING NULLCOLS

D

data file
Delimited Record Format, Delimited Record Format
fixed-length record format, Fixed-Length Record Format
data type
CHAR, Data Type
DATE|TIMESTAMP|TIME, Data Type
INTEGER|FLOAT|DOUBLE, 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 Modes
full database mode, Export Modes
table mode, Export Modes
user mode, Export Modes

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 INDEXES, Creating Indexes
MULTI INSERT INDEXES, Creating Indexes

L

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

T

T-Up, Overview
tbdv, Overview
tbExport, tbExport, Overview
tbExport parameter, Specifying Parameters at the Command Prompt
tbExport utility parameters, Parameters
tbImport, Overview
tbImport parameter, Specifying Parameters at the Command Prompt
tbImport utility parameters, List of Parameters
tbLoader , Overview
tbLoader data type
binary data type, Data Type
tbLoader example
delimited record format, Delimited Records
fixed-length record - LINES FIXED, Fixed-Length Records - Lines Fixed
fixed-length record format - LINES TERMINATED BY, Fixed-Length Records - Terminated by EOL
large object data, Large Object Data Types
tbLoader I/O File, I/O File
Control File, Control File
Data File, Data File
Error File, Error File
Log File, Log File
tbSQL, tbSQL
tbSQL accessing database, Accessing Database
tbSQL column format, Column Formats
character type, Character Type
numeric type, Numeric Type
tbSQL command, Commands
!, !
[INPUT], INPUT
@, @@, @, @@
/, /
%, %
ACC[EPT], ACCEPT
ARCHIVE LOG, ARCHIVE LOG
C[HANGE], CHANGE
CL[EAR], CLEAR
COL[UMN], COLUMN
CONN[ECT], CONNECT
DEF[INE], DEFINE
DEL, DEL
DESC[RIBE], DESCRIBE
DISC[ONNECT], DISCONNECT
DISCONNECT, DISCONNECT
ED[IT], EDIT
EXEC[UTE], EXECUTE
EXIT, EXIT
EXP[ORT], EXPORT
H[ELP], HELP
HIS[TORY], HISTORY
HO[ST], HOST
L[IST], LIST
LOAD[FILE], LOADFILE
LOOP, LOOP
LS, LS
PASSW[ORD], PASSWORD
PAU[SE], PAUSE
PING, PING
PRI[NT], PRINT
PRO[MPT], PROMPT
Q[UIT], QUIT
R[UN], RUN
REST[ORE], RESTORE
SAVE, SAVE
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 variable, System Variables
AUTOCOMMIT, AUTOCOMMIT
AUTOTRACE, AUTOTRACE
BLOCKTERMINATOR, BLOCKTERMINATOR
COLSEP, COLSEP
CONCAT, CONCAT
DDLSTATS, DDLSTATS
DEFINE, DEFINE
DESCRIBE, DESCRIBE
ECHO, ECHO
EDITFILE, EDITFILE
ESCAPE, ESCAPE
EXITCOMMIT, EXITCOMMIT
FEEDBACK, FEEDBACK
HEADING, HEADING
HEADSEP, HEADSEP
HISTORY, HISTORY
INTERVAL, INTERVAL
LINESIZE, LINESIZE
LONG, LONG
NEWPAGE, NEWPAGE
NUMFORMAT, NUMFORMAT
NUMWIDTH, NUMWIDTH
PAGESIZE, PAGESIZE
PAUSE, PAUSE
RECSEP, RECSEP
RECSEPCHAR, RECSEPCHAR
ROWS, ROWS
SERVEROUTPUT, SERVEROUTPUT
SQLPROMPT, SQLPROMPT
SQLTERMINATOR, SQLTERMINATOR
SUFFIX, SUFFIX
TERMOUT, TERMOUT
TIME, TIME
TIMEOUT, TIMEOUT
TIMING, TIMING
TRIMOUT, TRIMOUT
TRIMSPOOL, TRIMSPOOL
UNDERLINE, UNDERLINE
VERIFY, VERIFY
WRAP, WRAP
tbSQL terminating utility, Terminating Utility
tbSQL utility command, Commands

U

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