Auto-Generated Serial Numbers?

15 pts.
Tags:
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ria
    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.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following