How to create Sybase Anywhere tables in sybase IQ?

[Former Member]

Hello Sir/Ma'am,

I am using Sybase IQ server for engineering Project purpose. I am now learning and understanding the concepts of Sybase IQ.

I have question regarding CREATE ENCRYPTED TABLE.
See this link
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1520/html/iqrefso/X...
where it is mentioned that
**"The CREATE TABLE ENCRYPTED clause is supported for SQL Anywhere tables in a Sybase IQ database.**"
Does this really work? If yes then how to create **SQL Anywhere tables in Sybase IQ database**?
As far as I know anything you create should belong to particular database how can be tables created cross databases of different server?

I hope you would provide answer as soon as possible.

[former_member182090]

To create a SQL Anywhere table in IQ, add "IN SYSTEM", e.g. CREATE TABLE mytab (a int) IN SYSTEM. This creates the table in the SQL Anywhere area of IQ which serves as a catalog for IQ. You can use many SQL Anywhere features for these tables that cannot be used with IO tables (like spatial datatypes and triggers, just to mention two). Clearly, as SQL Anywhere is a row-oriented DBMS, you won't get any of the IQ-specific features nor the IQ performance benefits from the column-oriented architecture.

Lastly, SQL Anywhere "IN SYSTEM" tables are sometimes also called "Catalog tables"..