SQL Anywhere Feedback - Whether there will be in the future Sybase ASA 10.x a support of

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Whether there will be in the future Sybase ASA 10.x a support of

Tolik Gusin

2005-09-21, 9:24 am

Hello All,

Whether there will be in the future Sybase ASA 10.x a support of
sequence, as for example in Oracle or DB2 ?

It is necessary for when in one table there are two autoincremental
fields.

Sample:

CREATE TABLE dba.TEST(
"IDENTITY" integer NOT NULL DEFAULT autoincrement,
"DOCNUMBER" integer NOT NULL DEFAULT autoincrement,
...
PRIMARY KEY ("IDENTITY"))

In this case function GET_IDENTITY() or a variable @@Identity do not
allow to receive the future or
last value of the field.

If the sequence will not be, then please little change syntax of
function GET_IDENTITY():
GET_IDENTITY([owner.] table-name [.fieldname] [, num_to_alloc]...)

That is that it would be possible to receive following value "IDENTITY"
for the set field.

--
Best Regards, Stalker

Origin: The History is Dead

Sponsored Links