How to get ROWID from Progress database

Question

I have a Progress database from which I am executing an ETL. One of the tables that I read does not have a unique key on it, so I need to access the ROWID in order to be able to uniquely identify the row. What is the syntax for accessing the ROWID in the process?

I understand that there are problems using the ROWID to identify strings, but that's all I have now.

Answer 1

A quick warning for my answer is almost 10 years since I worked with Progress , so my knowledge is probably more than a bit of a date.

[PDF], , , , , : ROWID RECID. ROWID .

4GL :

FIND customer WHERE cust-num = 123.
crowid = ROWID(customer).

FIND customer WHERE ROWID(customer) = crowid EXCLUSIVE-LOCK.

SQL- [PDF] , ROWID SQL Progress. :

SELECT ROWID, FirstName, LastName FROM customer WHERE cust-num = 123

: .

Answer 2

, , ROWID RECIDs .

1) , ROWID .

2) , ROWID .

Answer 3

. ROWID select, . ROWID , , *.

:

SELECT ROWID, * FROM customer WHERE cust-num = 123

:

SELECT ROWID, FirstName, LastName FROM customer WHERE cust-num = 123

Answer 4

Google : http://bytes.com/forum/thread174440.html

[e-mail]( oid ctid , )