Forum Post: RE: Is Table Partitioning certificated by QAD?

  • Thread starter Thread starter Richard Banville
  • Start date Start date
Status
Not open for further replies.
R

Richard Banville

Guest
Rowids are unique per table, records are not. You could use the recid and partition id to manually build a rowid instead. I did a presentation which included this information and the prescribed way to do it at PUG last year. I can post it if you’d find it helpful. From: George Potemkin [mailto:bounce-GeorgeP12@community.progress.com] Sent: Friday, June 05, 2015 4:30 PM To: TU.OE.RDBMS@community.progress.com Subject: RE: [Technical Users - OE RDBMS] Is Table Partitioning certificated by QAD? RE: Is Table Partitioning certificated by QAD? Reply by George Potemkin Find by recid for a partitioned table will silently failed. But Progress errors (e.g. 17390-17403) are still report the recids: Index index number ( owner name . table name , index name partition name : partition number ): Found invalid key key value recid record identifier . (17403) How to find a record knowing its recid and its partition number? Stop receiving emails on this subject. Flag this post as spam/abuse.

Continue reading...
 
Status
Not open for further replies.
Back
Top