User's Manual

Index
remotetype SQL Remote table
ASA 329
ASE 342
remotetypes SQL Remote view
ASE 347
remoteuser SQL Remote table
ASA 329
ASE 343
message tracking 237
using 237
remoteusers SQL Remote view
ASA 334
ASE 348
replication
administering 13
ASE limitations 442
backup procedures 249, 253, 257, 272
blobs 83
case studies 15
conflicts 88
control statements 262
cursor operations 262
cursor statements 262
data definition statements 82
data recovery 224
data types 83
dbremote 292
design for ASE 147
Message Agent 292
mixed operating systems 189
mobile workforces 15
options 315
passthrough mode 260
primary key errors in SQL Remote for ASA 127
primary key errors in SQL Remote for ASE 173
primary key pools in SQL Remote for ASA 134
primary keys in SQL Remote for ASA 129
primary keys in SQL Remote for ASE 175
procedures 80
publication design for ASA 102
publications 11
referential integrity errors in SQL Remote for
ASA 127
referential integrity errors in SQL Remote for
ASE 173
server-to-laptop replication 15
server-to-server 16
setup examples 15
SQL statements 78, 260
ssqueue 312
ssremote 292
stored procedures 262
subscriptions 11
synchronization 303
transaction log 13, 78
transaction log management 249, 253, 257, 272
triggers 80
triggers in SQL Remote for ASA 127
upgrading databases 258
Replication Agent
SQL Remote 278, 279
SQL Remote for ASE 265
replication conflicts
managing in SQL Remote for ASA 120
managing in SQL Remote for ASE 165
replication definitions
Replication Server 285
replication options
BLOB_THRESHOLD 316
DELETE_OLD_LOGS 316
EXTERNAL_REMOTE_OPTIONS 316
QUALIFY_OWNERS 316
QUOTE_ALL_IDENTIFIERS 317
REPLICATION_ERROR 89, 246, 271, 317
SAVE_REMOTE_PASSWORDS 317
SR_DATE_FORMAT 317
SR_TIME_FORMAT 318
SR_TIMESTAMP_FORMAT 318
SUBSCRIBE_BY_REMOTE 318
VERIFY_ALL_COLUMNS 319
VERIFY_THRESHOLD 319
replication role
granting 269
Replication Server
configuring 285
restart the connection 286
SQL Remote 277, 278, 285, 312
SQL Remote architecture 279
SQL Remote for ASE 265
ssqueue 282
REPLICATION_ERROR option
error handling 271
error handling procedures 246
replication option 317
459