Sybase 12.4.2 manual Vii

		Contents
	Types of join hierarchies	164
	Modifying tables included in a join index	167
	Inserting or deleting from tables in a join index	168
	Table versioning controls access to join indexes	169
	Estimating the size of a join index	169
CHAPTER 5	Moving Data In and Out of Databases	171
	Import and export overview	171
	Import and export methods	171
	Input and output data formats	172
	Permissions for modifying data	173
	Scheduling database updates	173
	Exporting data from a database	174
	Using output redirection	174
	NULL value output	175
	Bulk loading data using the LOAD TABLE statement	175
	Interpreting notification messages	187
	Memory message	187
	Main IQ Store blocks messages	188
	IQ Temporary Store blocks message	188
	Main buffer cache activity message	188
	Temporary buffer cache message	189
	Controlling message logging	189
	Using the INSERT statement	190
	Inserting specified values row by row	190
	Inserting selected rows from the database	191
	Inserting from a different database	192
	Importing data interactively	195
	Inserting into tables of a join index	195
	Inserting into primary and foreign key columns	196
	Partial-width insertions	197
	Partial-width insertion rules	198
	Converting data on insertion	202
	Inserting data from pre-Version 12 Adaptive Server IQ	204
	Load conversion options	204
	Column width issues	208
	Using the ASCII conversion option	208
	The DATE Option	210
	The DATETIME conversion option	212
	Working With NULLS	215
	Other factors affecting the display of data	216
	Matching Adaptive Server Enterprise data types	217
	Unsupported Adaptive Server Enterprise data types	217
	Adaptive Server Enterprise data type equivalents	218

vii