Auto-Generated Serial Numbers?
Home > IT Answers > AS/400 > Auto-Generated Serial Numbers?
Ria
15 pts.
0
Q:
Auto-Generated Serial Numbers?
Query/400, AS/400 queries
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
ASKED: Jun 4 2009  11:16 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Gilly400
23625 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Jun 5 2009  1:15 PM GMT by Gilly400   23625 pts.
Latest Contributors: Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Ria   15 pts.  |   Jun 9 2009  6:56AM GMT

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.

 
0