Every nonfragmented table has a virtual column named rowid. To avoid ambiguity, you cannot use rowid as a column name. Performing the following actions causes an error:
You can, however, use the term rowid as a table name.
CREATE TABLE rowid (column INTEGER, date DATE, char CHAR(20));
Examples in this section show workarounds that involve owner naming when the keyword STATISTICS or OUTER is a table name. (This workaround also applies to STATISTICS or OUTER as a view name or synonym.)
Using statistics as a table name causes the following example to fail because the database server interprets it as part of the UPDATE STATISTICS syntax rather than as a table name in an UPDATE statement:
UPDATE statistics SET mycol = 10;
The workaround in the following example specifies an owner name with the table name, to avoid ambiguity:
UPDATE josh.statistics SET mycol = 10;
Using outer as a table name causes the following example to fail because the database server interprets outer as a keyword for performing an outer join:
SELECT mycol FROM outer; -- fails
The following successful example uses owner naming to avoid ambiguity:
SELECT mycol FROM josh.outer;Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]