Operating system and syntax UNIX / Windows 
-SQLQuotedRowid [ std | value]
Use with Maximum value Minimum value Single-user default Multi-user default
DBS – – std std
std|value
Specify behavior of the string "rowid":
  • std — specify std to indicate that all instances of the quoted string "rowid" are interpreted as an SQL identifier (such as a column name).
  • value — specify any string other than std to indicate that all instances of rowid, quoted or not, are interpreted as the SQL rowid function.

Use SQL rowid identifier (-SQLQuotedRowid) to specify how the quoted string "rowid" is interpreted.

The SQL rowid identifier (-SQLQuotedRowid) parameter may be modified while your database is online using PROMON or through the _DbParams VST. This change will only take effect on the primary broker and its newly spawned servers.

Example

Start the database server as shown:

mprosrv myDB -S  1234 -H myhost  -SQLQuotedRowid std

After starting the server and connecting a client to the database, query a column named rowid as shown:

select custnum, "rowid"  from pub.my_customer where "rowid" = 10 ;

Query both the column named rowid (quoted), and the value of the rowid function(no quotes) as shown:

select custnum, "rowid", rowid from pub.my_customer where "rowid" = 10 ;