any words in DB2 same as Orcale ROWNUM or ROWID

billchen · #1 (**permalink**) 09-07-04, 21:41

Dear All,

I am using AS400 V5R1 DB2, I have encountered a problem that I can no identy the row which I selected.

does the DB2 has any word like ROWNUM, ROWID, Record No, etc.

Thanks

ricgre · #2 (**permalink**) 09-08-04, 12:51

I am using V5R3 and db2 does have a rowid data type.

billchen · #3 (**permalink**) 09-08-04, 13:46

and seem in V5R1 does not have identity function. how to handle this kind of problem in V5R1?????

Thanks for your answer

Blood8 · #4 (**permalink**) 09-10-04, 16:01

I'm not a expert in DB2 but in Internet I find a Oracle to DB2 UDB Conversion Guide.

http://www.redbooks.ibm.com/redbooks/pdfs/sg247048.pdf

I think that this guide can help you

Internet Services

Web Development

Digital Marketing

Consumer Tech