Home > IT Answers > AS/400 > Auto-Generated Serial Numbers?
Ria
15 pts.
 Auto-Generated Serial Numbers?
AS/400 queries, Query/400
I want to know that how do i generate serial numbers by using Query/400.For eg a database named employlist having name,address and phno.Now i want to add one another column which is serial. How???????? Can anyone please tell me the solution by using Query/400. I've done it from SQL. Name Address Phno ABC XYZ 123 ASD XZV 999 Serial Name Address Phno 1 ABC XYZ 123 2 ASD XZV 999

Software/Hardware used:
ASKED: June 4, 2009  11:16 AM
UPDATED: June 9, 2009  6:56 AM
RELATED QUESTIONS
Answer Wiki:
I don't think this is possible. Phil ===================== Hi, You could try using the relative record number (RRN) as serial. Should get you a similar result (as long as you have no deleted records in your file). Regards, Martin Gilbert.
Last Wiki Answer Submitted:  June 5, 2009  1:15 pm  by  philpl1jb   44,060 pts.
All Answer Wiki Contributors:  philpl1jb   44,060 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanx for your replies….
But i think Phil is write there is no way to generate serial nos through Query/400.

Mr. Martin will u please tell me, how to use Relative record number (RRN).I’ve used it in SQL and it works.Actually i want some calculation through serial numbers, for this purpose i need to add this in my database.

Ria.

Ria
 15 pts.