Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Cloudscape Create Sequence

 
satish gutta
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic