× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. March 2003

Re: "Reference #"

I have often used the timestamp as primary key, in the last file (table) I created I tried the auto, and it is working gtreat.

here is part of my "CREATE":

CREATE TABLE PAGO.CH1 ( N_OPAGO dec(7, 0) GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
F_OPAGO DATE NOT NULL WITH DEFAULT,
etc....

Regardless of what I try to write in N_OPAGO, the system generates the record using the next available number.

Chuck Lewis wrote:

Hi Folks,

I have been asked to create a program to allow employees to enter comments,
suggestions, etc. on how the company is doing, what we can do to improve,
etc.

They will have the option to be anonymous in these entries or be "tracked"
for follow-up.

I need to assign a number or something to each record so I can reference
them. What is the best way to do this ?

At a past company we had multiple companies and I wrote Receiving programs
that generated a Receiver # from a data area and each company had a
particular designation in that data area plus the "next number". This, plus
the fact that usually only one person at a location would be entering
Receivers, tended to avoid any problems with this.

In this situation, with the option of being anonymous it is wide open to all
our 10 locations; I fear this might be more difficult.

Anyone doing anything like this ?

Thanks !

Chuck







_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.