Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 7 / 536

Contents
vii
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