RE: Sequence Objects

I have the same questions.  How to use it? There was something about 'Next 
value' expression.

Sudha Ramanujan
SunGard Futures Systems
sramanujan@xxxxxxxxxxxxxxxxxx
(312) 577 6179
(312) 577 6101 - Fax


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx] 
Sent: Tuesday, January 18, 2005 9:57 AM
To: Midrange Systems Technical Discussion
Subject: Re: Sequence Objects

I read that too.  How does one READ the sequence object from within SQL?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Richard Theis <theis_richard@xxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/18/2005 10:48 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
midrange-l@xxxxxxxxxxxx
cc

Subject
Re: Sequence Objects










> Hi all,
> Is there any sequence objects in iSeries that can auto generate key by
> incrementing when the record is read?
> Sudha

Look at SQL statement CREATE SEQUENCE (Creates a DTAARA under the covers)
V5R3 only

Bonne réception/Best regards
Richard THEIS
  iSeries Education, France



-- 
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.


-- 
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.