9.1d And Recid

R

Richard Grimmett

New Member
I need to access a Progress 9.1d table via OpenLink jdbc drivers, and process the rows in the order in which they were created.

I do have control over the creation of the rows within the ABL app, but cannot see a way of allocating an auto increment field in 9.1d, and do not particularly want to have the overhead of having more database activity to secure a 'control' number.

I was wondering whether I would be able to use an SQL 'order by RECID(table)', or whether RECID is not incremented all the time. I cannot find reference in the Progress manuals to how RECID is allocated.

Can anyone shed light on this, or suggest an alternative please?

Thanks
Richard
 
Recid will not be guaranteed sequential as I understand it, and anyway recid is not valid in more modern versions of progress. It is replaced by rowid. It's a way for Progress to find the record in the storage area.
If you really need order of creation then either add a datetime stamp at time of creation, or add a sequence to the DB and use that to populate an integer field on the record.
 
Thanks Cringer,

rowid cannot be accessed via openlink drivers (I am using SQL89). But it might not have helped either. I am not that experienced with Progress, am self teaching and come from other database backgrounds. I did not know about sequences, and I have just tried them and they seem to work well.

Richard
 
You must log in or register to reply here.
Back
Top