Aqua Data Studio 15.0.0-dev-73
Build #: 35575
Built on: 2014-Jan-17 05:39:06 PM

Operating Environment:  Windows7 64-bit
Database : Informix 12.10
Issue : Query builder does not generate SQL joins for Informix database.

Steps to reproduce:

1.Connect to Informix server 
2. Run below scripts on query analyser

 CREATE TABLE "informix".date_datatypes  (

    col_date            DATE NOT NULL,

    col_datetime        DATETIME HOUR to MINUTE NOT NULL,

    col_interval        INTERVAL YEAR to MONTH NOT NULL

    )

IN ol_s_092013_174025

EXTENT SIZE 32 NEXT SIZE 32

LOCK MODE PAGE

GO

 

CREATE TABLE "informix".numeric_datatypes  (

    col_int             INTEGER NOT NULL,

    col_boolean         BOOLEAN,

    col_bigint          BIGINT,

    col_float           FLOAT,

    col_decimal         DECIMAL(15,5),

    col_int8            INT8,

    col_money           MONEY,

    col_serial          SERIAL NOT NULL,

    col_smallfloat      SMALLFLOAT,

    col_integer         INTEGER,

    PRIMARY KEY(col_int)

        FILTERING WITHOUT ERROR

)

IN ol_s_092013_174025

EXTENT SIZE 32 NEXT SIZE 32

LOCK MODE PAGE

GO

 3. Now Go to Schema Browser

 Select desired database, right click and select option Query Builder

 In Add Table window select Schema: informix

 Select Tables " date_datatypes  " and " numeric_datatypes  "

 Click on Add and Close button

  1.When we add tables cross join script is not generated in query.

  2.When we apply inner join then inner join script is not generated in query.

  3.When we apply left outer join then left word is missing in query.
  4.When we apply right outer join then right word is missing in query.

  5.When we apply full outer join then full outer join script is not generated in query.

 

 4. Link where you can see that Informix supports all SQL joins.

http://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp?topic=%2Fcom.ibm.welcome.doc%2Fwelcome.htm