Try OpenEdge Now
skip to main content
Startup Command and Parameter Reference
Startup Parameter Descriptions : SQL rowid identifier(-SQLQuotedRowid)
 

SQL rowid identifier(-SQLQuotedRowid)

Use SQL rowid identifier (-SQLQuotedRowid) to specify how the quoted string "rowid" is interpreted.
Operating system and syntax
UNIX / Windows
-SQLQuotedRowid [ std |value ]
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
Database Server
—
—
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.

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 ;