Sybase 12.4.2 User Manual

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

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