Hope no one aware of this question where I mention previously
Ok, but any way I try this with power designer through reengineering the database and try to extract the DDL script out of it, but I cant run and insert all the tables under Sybase IQ database which I create (my own created database), from one extended I cannot insert the DDL scripts, the DBSQL program seems getting hang so I have to restart the database to reconnect back. But what I feel is that the problem with the database sizing, if I create the another new database and try to inserts the DDL script where I cannot execute point, it successfully inserting.
Please some one tell me how to make a Sybase IQ database where I can insert any number of tables with the sizing problem
Here is the sql script where I use to create the database
CREATE DATABASE '/home/sybase_iq/avameddb/avamediq.db'
TRANSACTION LOG ON '/home/sybase_iq/avameddb/avamediq.log'
PAGE SIZE 4096
PASSWORD CASE RESPECT
IQ PATH '/home/sybase_iq/avameddb/IQ_MAIN_00'
IQ PAGE SIZE 65536
MESSAGE PATH '/home/sybase_iq/avameddb/avamediq.iqmsg'
TEMPORARY PATH '/home/sybase_iq/avameddb/IQ_TEMP_00'