Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Column ExpressionsA column expression specifies a data value in a column in the database, or a substring of the value, or a field within a ROW-type column, or a field in a BSON column.
Using Rowids

Using Rowids

In HCL OneDB™, you can use the rowid column that is associated with a table row as a property of the row. The rowid column is essentially a hidden column in nonfragmented tables and in fragmented tables that were created with the WITH ROWIDS clause. The rowid column is unique for each row, but it is not necessarily sequential. It is recommended, however, that you use primary keys as an access method rather than exploiting the rowid column.

The following examples use the ROWID keyword in a SELECT statement:

SELECT *, ROWID FROM customer;

SELECT fname, ROWID FROM customer ORDER BY ROWID; 

SELECT HEX(rowid) FROM customer WHERE customer_num = 106;

The last example shows how to get the page number (the first six digits after 0x) and the slot number (the last two digits) of the location of your row.

You cannot use the ROWID keyword in the select list of the Projection clause of a query that contains an aggregate function.