467,198 Members | 1,111 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,198 developers. It's quick & easy.

Syantax support

Hi ,
This is regarding the sequence (select nextval) syntax support which
is not there on 8.1 base version but applying the fixpack 6 the syntax
is supported
Here can any one tell what fixpack this syntax is supported from .
Thanks
Aju
Nov 12 '05 #1
  • viewed: 1509
Share:
2 Replies
Ian
Ajay wrote:
Hi ,
This is regarding the sequence (select nextval) syntax support which
is not there on 8.1 base version but applying the fixpack 6 the syntax
is supported
Here can any one tell what fixpack this syntax is supported from .


Serge would know the answer (but he's probably offline for the week),
but it was either FP3 or FP4.

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----
Nov 12 '05 #2
I actually did.. But the news-server I used didn't propagate (yet).
Here's is a repeat (I apologize for duplicates):

NEXTVAL FOR <sequence> and PREVVAL FOR <sequence> was the original.
The SQL Standard did not follow this exact syntax.
The SQL Standard syntax is:
NEXT VALUE FOR <sequence> and PREVIOUS VALUE FOR <sequence>
DB2 supports and documents now the standard syntax and tolerates the old
one.
I don't recall when exactly that adjustment was done.

Cheers
Serge
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Aditya Ivaturi | last post: by
3 posts views Thread by Chris Hope | last post: by
5 posts views Thread by shaun.mostashari@lmco.com | last post: by
5 posts views Thread by NormaJean Sebastian via DBMonster.com | last post: by
4 posts views Thread by Juan T. Llibre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.