How can we uniquely identify a record in AS400 if primary key/unique key/composite key is not defined? Is there a ROWID pseudo column in AS400 similar to Oracle?
If yes, how can we retrieve all row values along with ROWID values with a SQL query?
Asked
Active
Viewed 87 times
1 Answers
1
This question has been asked before. See
- Unique identifier for AS400 Database if there is no primary key / unique key / composite key defined?
- Is rowid concept is there in AS400 like in oracle?.
When you enter a new question, the Web-UI offers you similar questions. Apparently you ignored these.
PoC
- 521
- 3
- 13
-
As long as there's at least one answer with an upvote on another question, you can vote to close a question as a duplicate. – Charles Jan 11 '23 at 14:18