NetBase SQL Shadowing Handbook

Index NetBase SQL
____________________________________________________________
QUEST Software, Inc. ver A0195
SQL shadowing tables .......................... 2-15
SQLEXPLAIN ....................................... 4-12
SQLUTIL .............................................. 2-18
commands
SHOWDBE.............................. 2-18
STORE .................................... 2-24
STORELOG............................. 2-24
STOREONLINE ....................... 2-24
fields
Home partition ID............ 2-18, 2-19
Home partition number............... 4-1
Maximum Number of
Partitions.................. 2-18, 2-19, 4-1
WSL ID.................... 2-18, 2-19, 4-1
Standby Checkpoint Records................ 2-19
SYNC flag ............................................ 3-10
T
Termination Conditions........................... 4-3
Transaction record
BEGIN............................... 3-4, 3-7, 3-11
COMMIT............................ 3-4, 3-7, 3-11
DELETE tuple.................... 3-4, 3-7, 3-11
INSERT tuple .................... 3-4, 3-7, 3-11
UPDATE tuple................... 3-4, 3-7, 3-11
Troubleshooting......................................4-1
U
Unique column searches.........................3-3
User Exits...............................................3-1
Calling Conventions for Export Exits.. 3-5
Calling Conventions for Post User
Exits .................................................. 3-9
Export................................................ 3-1
export_sql_exit ...........................3-1, 3-2
EXPORTSQLPROC ..........................3-2
Post...................................................3-1
post_sql_exit_after .......3-1, 3-2, 3-3, 4-3
post_sql_exit_before.......................... 3-1
POSTSQLPROC ............................... 3-2
Sample................................... 3-13, 3-17
Structure
action field .................................3-4
User exits - Structure.............................. 3-4
action field................................ 3-5, 3-10
Binary data............................... 3-7, 3-12
Character data.......................... 3-7, 3-12
column_array field.................... 3-7, 3-12
column_length field .................. 3-7, 3-12
column_num field..................... 3-7, 3-12
column_type field ..................... 3-7, 3-12
comarea.............................. 3-4, 3-5, 3-9
commit_time field..................... 3-7, 3-11
data buffer................................ 3-4, 3-12
DBEname field......................... 3-7, 3-11
export_node field...................... 3-6, 3-10
first_time flag ........................... 3-6, 3-11
Floating point data.................... 3-7, 3-12
header............................... 3-4, 3-6, 3-11
import_node field...................... 3-6, 3-10
Integer data.............................. 3-7, 3-12
key_col_search flag.................. 3-6, 3-11
NLS character data.......................... 3-12
NULL value .............................. 3-7, 3-12
num_columns field ................... 3-7, 3-12
owner_name field..................... 3-7, 3-11
Packed decimal data................ 3-7, 3-12
record_type field....................... 3-7, 3-11
sqlca ................................... 3-4, 3-5, 3-9
status field................................ 3-6, 3-10
Table................................................. 3-4
table_name field....................... 3-7, 3-11
upd_columns field .................... 3-7, 3-12
upd_data field.................... 3-4, 3-8, 3-12
update_array field..................... 3-7, 3-12
user_area field ......................... 3-6, 3-11
user_name field........................ 3-7, 3-11
W
Warm Standby Logging (WSL)............... 1-1
WSL flags .............................................. 3-3
KEY_COL_SRCH_OK................ 3-3, 3-6
NO_TRX_LEN_CHK.......................... 3-3
X
XL.NB.NETBASE ................................... 3-2
XL.PUB.NETBASE................................. 3-2