Product: Aqua Data Studio

Version: 18.0.0-devi-177

Build #: 50341

Build Date: 2016-Jul-02 08:06:32 AM

 

Operating Environment: Linux (3.19.0-64-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15

Memory: Max=704,643,072;  Total=351,272,960;  Free=213,509,400;  CPUs=8

 

Database Version: DB2 LUW 10.5

 

Steps to Reproduce Issue

 

1. Connect to DB2 LUW Server.

2. Go to schema browser expand the desired schema

3. Select 'Tables' Node -> Right Click -> Select 'Create Table'

4. In Visual Editor:

 

Name: t1

Column Name: c1

DataType: GRAPHIC | VARGRAPHIC | LONG VARGRAPHIC

In Column Option pane 'For Bit Data' option select 'Yes'.

 

5. Now, click on create the icon.

 

Actual Result: error message "The specification for column, attribute, user-defined type or function "c1" contains incompatible clauses. SQLCODE=-683, SQLSTATE=42842, DRIVER=3.67.28" occurred. because the wrong script gets generated due to Column Option pane 'For Bit Data' option we have selected 'Yes'.

 

Expected Result: In Column Option pane 'For Bit Data' option should be disabled for DataTypes 'GRAPHIC', 'VARGRAPHIC' and 'LONG VARGRAPHIC'.

 

Issue is reproducible in ADS 17.0.6-4