Reserved words

The words in Table 2-3 are reserved Replication Server keywords. Although the words are shown in lowercase, Replication Server is not case-sensitive. Therefore, all combinations of uppercase and lowercase letters are reserved. Replication Server also reserves all keywords and identifiers beginning with “rs_”.

Table 2-3: Replication Server reserved words

Words

A

abort, action, activate, active, add, admin, _af, after, all, allow, alter, always_rep, always_replicate, and, _ap, article, articles, _apd, append, applied, _ar, as, assign, at

B

before, begin, _bf, _bg

C

changed, _ch, check, ci, class, _cm, columns, commit, configure, connect, connection, connections, controller, create

D

database, datarow, ddl, debug, define, definition, deletelen, deliver, description, disconnect, distribute, distribution, distributor, _dln, _dr, drop, drop_repdef, _ds, dsi_suspended, dump, dynamic

E

enable, error, exec, execute, expand

F

_fi, first, for, from, function, functions

G

get, grant

H

_ha, hastext, holdlock

I

ignore, in, incrementally, internal_use_only, into, installjava, _instj, _isb, _isbinary

J

_jar

K

key

L

language, large, last, load, log, logical, loss

M

maintenance, map, marker, materialization, message, _mbf, min_before, minimal, min_row, move, _mr

N

name, named, _ne, never_rep, new, next, no, no_password, none, not, notrep, nowait, npw, _nr, _nu, null, nullable

O

of, off, offset, on, only, open_xact, or, _os, osid, output, overwrite, owner

P

parameters, parent, partialupd, partition, passthru, password, primary, procedure, procedures, _pu, public, publication, purge

Q

queue, queues, quoted

R

rebuild, reconfigure, recover, recovery, reject, remove, repfunc, replay, rep_if_changed, replicate, replicate_if_changed, replication, request, resume, retry, revoke, _rc, _rf, _rl, rollback, route, row, rpc, rs_ticket, rsrpc

S

scan, searchable, segment, select, send, sendallxacts, seq, server, set, shutdown, site, size, skip, source, sql, sqlddl, _st, standby, starting, status, string, subscribe, subscription, suspend, suspension, switch, sysadmin, sys_sp, system

T

table, tables, template, textcol, textlen, _tl, _tn, to, _tp, tpinit, tpnull, _tr, trace, tran, transaction, transactions, transfer, truncate, truncation, twosave

U

_up, unsigned, update, use, user, username, using

V

validate, verify, vers

W

wait, warmstdb, _wh, where, with, without, withouttp, _wo, writetext

Y

_yd, yielding

Z

_zl, zerolen