Re: SQL identity column V4R5 howto?

Nope.  Sounds like an effective stop gap solution until you get V5R2. 
Nothing stopping you from preloading a data queue with a large quantity of 
numbers instead of having a NEP in the background to deal with.  The only 
drawback is that when you restore, you'll have to reload the data queue. I 
don't think that a save saves the contents of any queue's, be it data 
queue, output queue, or whatever.

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





"Goodbar, Loyd (ETS - Water Valley)" <LGoodbar@xxxxxxxxxxxxxx>
Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
08/27/2003 10:30 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        SQL identity column V4R5 howto?


I know at V4R5 SQL does not have identity (auto number, auto sequence, 
auto
increment) columns. We're waiting for our 810 upgrade with V5R2 for this,
but I don't have a timeframe yet (hopefully by Oct 31).

Has anyone done a stored procedure or trigger or trigger/dtaq process for
using identity columns in SQL at V4R5?

I was thinking that I could write a before trigger to pass the library,
file, field, and RRN of the row to a data queue. A data queue monitor 
would
get these and do a "+1" to the field to populate the identity column. This
would "guarantee" serialization of the autonumbering process.

I would probably need to write an on-change trigger to "prevent" 
renumbering
of the identity column on existing rows.

Any other ideas, besides waiting for V5R2?

Thanks,
Loyd



-- 
Loyd Goodbar
Programmer/analyst
BorgWarner Incorporated
ETS/Water Valley
662-473-5713
lgoodbar@xxxxxxxxxxxxxx

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.