Looking help for SQL script or Utility to generate DDL of IQ database

[Former Member]

Tried iqunload -n -c .   It give ddl for database/dbspace but a lot more info regarding table/references/sp/trigger etc .

I just need create datrabase/alter database/alter dbspace  ...

IQ version : 15.4

Appreciate your help .

Regards

Ajay Pandey

[saroj_bagai]

For SAP IQ 15.4 you can generate create database ddl using Sybase Central as well and or power designer

[Former Member]

Hi Saroj,

We don't have Sybase Centrail . So want to generate by isql; .. getting below error ..

Version : 15.4

Tried using petersap's script (http://www.petersap.nl/SybaseWiki/index.php?title=Reverse_Engineer_IQ_dbspaces) . But failing with error :

Msg 21, Level 14, State 0:

SQL Anywhere Error -1003007: Large Objects Management functionality is not licensed on this server.

-- (db_catalog.cxx 5909)

[former_member188490]

Since the goal is simply to get ddl, you *may* try this.
- Backup this database
- Restore it on some other box using IQ 16
- Start database in IQ 16
- Do *not* run 'alter database upgrade'
- Now run iqunload against this database to see whether you can extract ddl

[Former Member]

Thanks Milind

[former_member182258]

You might look at PowerDesigner, but we don't have something more targeted than iqunload:

http://scn.sap.com/docs/DOC-70562

[Former Member]

Thanks Courtney,

We do not have power designer/Sybase central . So we need to do with either some SQL script or iqunload .

I check Iqunload work fine in IQ 16 . but getting error  IQ 15.4..

iqunload -n -c "UID=DBA;PWD=sql;DBF=remix.db" -r ddl.sql

Sybase IQ Unload Utility Version 15.4.1.3014

Connecting and initializing

"remix" was started in an unsupported version of the server.  Schema only unload requires the database be started with 12.6 ESD11 (or higher) or 12.7 ESD5 (or higher).

1> select @@version

2> go

@@version

--------------------------------------------------------------------------------------------------------------------------------

Sybase IQ/15.4.0.3014/120606/P/ESD 1.4/Sun_x64/OS 5.10/64bit/2012-06-06 02:11:07