SqlRowIdPrivate (Class Keyword)
Usage
To hide the ID column when projecting the table to ODBC and JDBC, use the following syntax:
Class MyApp.MyClass [ SqlRowIdPrivate ] { //class members }
Otherwise, omit this keyword or place the word Not immediately before the keyword.
Details
If this keyword is true, the ID column is a hidden field when the table is projected to ODBC and JDBC.
When a persistent class is projected as an SQL table, the Object Identity value for each object is projected as an SQL column — the Row ID column. The SqlRowIdPrivate keyword lets you specify whether this Row ID column should be hidden from ODBC and JDBC-based queries. If the row ID column is hidden:
-
It is not reported as a column by the various catalog queries
-
It is not included in the SELECT * query.
An ODBC or JDBC client can select this column if the query explicitly lists the column within the SELECT clause. (Note that by definition, you cannot use a Row ID column in an UPDATE or INSERT statement because the value of the Row ID cannot be modified or directly set).
Typically you use this keyword for cases where you are dealing with legacy relational data and do not want the Row ID column to be seen by reporting tools.
Effect on Subclasses
This keyword is not inherited.
Default
If you omit this keyword, the ID column is visible normally when the table is projected to ODBC and JDBC.
