User's Manual

Chapter 15. System Objects for Adaptive Server Anywhere
Columns
Column Data type Description
publication_id UN-
SIGNED INT
The publication of which this article
is a part.
table_id UN-
SIGNED INT
Each article consists of columns
and rows from a single table. This
column contains the table ID for this
table.
where_expr LONG VAR-
CHAR
For articles that contain a subset of
rows defined by a WHERE clause,
this column contains the search
condition.
subscribe_by_-
expr
LONG VAR-
CHAR
For articles that contain a subset of
rows defined by a SUBSCRIBE BY
expression, this column contains the
expression.
query CHAR(1) The SUBSCRIBE BY expression
could be a subquery that returns mul-
tiple values. This column contains
Y or N to indicate if the expression
is a subquery (Y) or not (N). This
column is used by the Extraction
utility
SYSARTICLECOL table
Function Each row identifies a column in an article, identifying the column, the table
it is in, and the publication it is part of.
Columns
Column Data type Description
publication_id UN-
SIGNED INT
A unique identifier for the publication of
which the column is a part.
table_id UN-
SIGNED INT
The table to which the column belongs.
column_id UN-
SIGNED INT
The column identifier, from the
SYSCOLUMN system table.
327