Cloudscape Create Sequence

[satish gutta]

Hi all,

This is the syntax i am trying to use to create sequence for pkcolumn of table.
CREATE SEQUENCE PORTAL.KEY_ID START WITH 1 INCREMENT BY 1 CACHE 20;
I am getting the following error upon execution.


Starting execution

CREATE SEQUENCE PORTAL.KEY_ID START WITH 1 INCREMENT BY 1 CACHE 20;

SQL Exception: Syntax error: Encountered "PORTAL" at line 1, column 17.

If any body know how to deal with this help me...

Thanks all.

[Jeanne Boyarsky]

Satish,
I haven't used Cloudscape, but two questions that might lead you in the right direction:
1) Do you have a schema defined name "portal"?
2) Does Cloudscape support sequences?

[satish gutta]

Yes I have a schema defined PORTAL and i checked cloudscape support for creating sequence and cudnt found any help..anyways even i am new to cloudscape ..

appreciate you help and time.

thanks