Try OpenEdge Now
skip to main content
Database Administration
Reference : Database Startup Parameters : Alphabetical listing of database startup parameters : SQL rowid identifier(-SQLQuotedRowid)
 
SQL rowid identifier(-SQLQuotedRowid)
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.

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 ;