Salesforce

Is the Progress RECID function supported on an SQL-92 query?

« Go Back

Information

 
TitleIs the Progress RECID function supported on an SQL-92 query?
URL NameP83803
Article Number000157520
EnvironmentProduct: Progress
Version: 9.x
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
Is the Progress RECID function supported on an SQL-92 query?
Can I call the ABL/4GL RECID function from within an OpenEdge SQL WHERE clause?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
The Progress RECID function is not supported with Progress SQL-92.

The ROWID function is the equivalent function in Progress SQL-92.

For example, run this SQL-92 query against the sample sports database:
 
1. From SQLEXP run the following code:

SELECT ROWID FROM pub.customer;

or

2. From Procedure Editor run the following code:

SELECT string(ROWID(Customer)) FORMAT "X(25)" FROM customer

Please note that from procedure editor there is no semicolon ";" at the end of the select statement.
Workaround
Notes
References to Other Documentation:

Progress article(s):

 FAQ: Recid and Rowid
 Is there any plan to discontinue RECID over ROWID?
Keyword Phrase
Last Modified Date11/20/2020 7:14 AM

Powered by