User`s guide

versioncolumns
7-251
versioncolumns
Automatically update table columns
Syntax
vl = versioncolumns(dbmeta, 'cata')
vl = versioncolumns(dbmeta, 'cata', 'sch')
vl = versioncolumns(dbmeta, 'cata', 'sch', 'tab')
Description
vl = versioncolumns(dbmeta, 'cata') returns a list of columns that
automatically update when a row value updates in the catalog cata, in the database
whose database metadata object is dbmeta resulting from a database connection object.
vl = versioncolumns(dbmeta, 'cata', 'sch') returns a list of all columns that
automatically update when a row value updates in the schema sch, in the catalog cata,
for the database whose database metadata object is dbmeta resulting from a database
connection object.
vl = versioncolumns(dbmeta, 'cata', 'sch', 'tab') returns a list of
columns that automatically update when a row value updates in the table tab, the
schema sch, in the catalog cata, for the database whose database metadata object is
dbmeta resulting from a database connection object.
Examples
Get a list of which columns automatically update when a row in the table BONUS updates,
in the schema SCOTT, in the catalog orcl, for the database metadata object dbmeta.
vl = versioncolumns(dbmeta,'orcl','SCOTT','BONUS')
vl =
{}
The results are an empty set, indicating that no columns in the database automatically
update when a row value updates.