Skip to Content
author's profile photo Former Member
Former Member

Need to connect Sybase IQ with DB visualizer

We are having DB visualizer to create /execute proc and sql for ASE .

Can we connect to IQ server using db visualizer .

I can see option for Sybase IQ in DB Visualizer . as Database Type =Sybase IQ

Which Driver JDBC should be used . It has Sybase SQLAnywhere . but seems it is not loaded . Apprciate if you could let us know driver need to download ...

Second Option : IQ COCKPIT

But do not see any query editor in Cockpit .. ( Eplore --> IQ Server --> Right panel - drop down execute sql ) -- Not very good query tool .

We are in process of migratingASE store procs into IQ . So need some Sybase IQ tool to write sql/proc etc .

IQ Version 16 sp11 -- have cockpit only ( No sybase central ) .

Appreciate your help .

Regards

Ajay Pandey

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 11, 2016 at 01:26 PM

    Hi AJay,

    I've used DB Visualizer in a customer environment together with SQL Anywhere in the past, so I'm quite sure it works. It was required to register the JDBC driver class / jar in the properties of the connection type or class (what you referred to as "Database Type"). This is because DBVisualizer supports these RDBMSs but does not include the driver.

    A Query Editor also is included in Interactive SQL (dbisql) in the "Tools" menu (item "Edit Query", shortcut Ctrl-Q) but you may prefer to continue to use one you're familiar with.

    I don't know of any tool to migrate ASE stored procedures to IQ, mostly because it's hardly necessary. IQ (and SQL Anywhere) support SPs in both Watcom SQL dialect (which you can consider Anywhere / IQ native) and Transact SQL dialect (which is the only dialect ASE supports). So running your create procedure statements against IQ unchanged should be a decent approach to start with.

    The traps are slightly different or rather somewhere else. IQ by default behaves different when connected using an OpenClient (or TDS) client rather than a native IQ / Anywhere client. With an OC / TDS client, IQ behaves more similar to ASE than with an ODBC client or dbisql. Same with jConnect (ASE behavior) vs. the iAnywhere JDBC driver (native behavior).

    One important difference: with ASE style behavior, table column definitions, also for temp tables inside procedures, don't allow NULL values unless explicitly specified by using the NULL directive. With IQ style behavior, it's compatible to the SQL standard and most other implementations, Columns do allow NULL values unless explicitly declared using the NOT NULL directive. The short message is: don't rely on defaults, specify everything explicitly, which will keep you away from a lot of trouble.

    HTH for a start...

    Cheers

    Volker

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.