Re: "Reference #"

[rob@xxxxxxxxx]

You can use UUID's by searching the archives for this.

If you are on V5R2, you can use identity columns
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst79.htm
or ROWID's
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/sqlp/rbafymst80.htm
both are quite simple to set up and would require ZERO PROGRAMMING on your 
part to increment.

After having asked a recent question on either this list, or the 
midrange-l list, about some manipulation of a combined field, (like your 
example of differentiating by plant) I've come to the conclusion that this 
violates database rules.  And I keep the fields separate.  When I need 
them combined I use a view that combines them.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Chuck Lewis" <clewis@xxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
03/26/2003 04:06 PM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     "RPG/400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        "Reference #"


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.