How do I get the next number for a global autoincrement column?

[Former Member]

If I had a table defined like below, how, from my application would I be able to get the next value for the "id" column before saving any data to the database?

create table people  
(  
     id not null default global autoincrement(100000),
     first_name varchar(100),
     last_name varchar(100)
);

alter table "people"
    add constraint PK_PEOPLE primary key (ID);

[Former Member · Accepted solution]

You can make a call to

select get_identity('people') from dummy;

which will get the next available number for that table.

[Breck_Carter · Accepted solution]

See also http://sqlanywhere.blogspot.com/2009/07/is-it-safe.html

[Former Member · Accepted solution]

Excellent information! Thanks!