Saturday, October 18, 2014

Row ID in SQL/400

By using RRN we can include Row number in our sql.

Example:

We need to include row number with item number and item name.

SELECT RRN, IPROD, IDESC FROM BPCS405CDF/IIM


In Oracle we use ROWID


No comments:

Post a Comment