#13759: DB2 ZOS : Incorrect create table script generated for decfloat datatype.

raghavsingh reported 2015-09-29T04:29:13Z · last modified 2015-12-04T03:55:04Z

DB2 ZOS : Incorrect create table script generated for decfloat datatype.

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - DB2 zOS
Version	17.0

Product: Aqua Data Studio

Version: 17.0.0-rc-2

Build #: 46104

Build Date: 2015-Sep-28 06:50:25 PM

Step to Reproduce:

1. Connect to IBM DB2 ZOS database.

2. Expand Schemas object folder.

3. Expand any schema & go to Tables object folder.

4. Right click on Tables object folder & select "Create Table" option.

5. In Create Table window:

-Enter Table name.

-Add one column having DECFLAOT datatype

- Add one more column having datatype as varchar.

6. Go to preview sql tab, script will be generated:

CREATE TABLE "DPACK"."Decfloat" (

"decfloat" DECFLOAT(34),

"varchar" VARCHAR(25)

)

7. Click on create button, a new table will be created.

8. Go to table tree node, select table Decfloat. Right click on it and select "Script Object to New Window As" CREATE.

9. System will generate a Create Script.

Actual Result: Incorrect sql script generated for decfloat datatype.

CREATE TABLE DPACK.Decfloat (

decfloat DECFLOAT(),

varchar VARCHAR(25) FOR MIXED DATA

)

Observation :

System is generating a wrong create script which is not allowing us to create a table.

4 attachments

DECFLOAT.png

2015-09-29T05:00:06Z

114 KB
Remain_datatypes.png

2015-09-29T06:21:23Z

53 KB
Reopened_13759_RC-8.png

2015-10-07T06:11:48Z

92 KB
13759_RC-11.png

2015-10-09T03:54:21Z

111 KB

All Comments (6) Change History

raghavsingh 2015-09-29T06:21:11Z

CASE : 2 : Wrong Length displayed for some datatypes after create SQL Script for created table

1. Connect to IBM DB2 ZOS database.

2. Expand Schemas object folder.

3. Expand any schema & go to Tables object folder.

4. Right click on Tables object folder & select "Create Table" option.

5. In Create Table window:

-Enter Table name.

-Add one column having DECFLAOT datatype

- Add one more column having datatype as varchar.

6. Go to preview sql tab, script will be generated:

CREATE TABLE "DPACK"."REMAIN_DATATYPES" (

"binary" BINARY(5000),

"blob" BLOB(5000),

"clob" CLOB(5000),

"dbclob" DBCLOB(5000),

"varbinary" VARBINARY(5000)

)

7. Click on create button, a new table will be created.

8. Go to table tree node, select table REMAIN_DATATYPES. Right click on it and select "Script Object to New Window As" CREATE.

9. System will generate a Create Script.

Actual Result: Wrong Length displayed for some datatypes after create SQL Script for created table

CREATE TABLE DPACK.REMAINS_DATATYPES (

BINARYS BINARY(255),

BLOBS BLOB(265),

CLOBS CLOB(265) FOR MIXED DATA,

DBCLOBS DBCLOB(1032),

VARBINARYS VARBINARY(255)

)

Please refer attached remain_datatypes.png file

ivangron 2015-10-06T23:58:57Z

DBz/os has added a new column, length2 in the syscolumns catalog table that represents the length for lobs, clobs, blobs, dbclobs. Made changes to extraction and scripting to handle this. changes will affect the tree display of columns length and object extraction/scripting for length values.

raghavsingh 2015-10-07T06:12:29Z · (edited)

Issue still reproducible in ADS-17-RC-8
1. Decfloat datatypes :Incorrect sql script generated for decfloat datatype.
2. CLOB and DBCLOB : Same values not displayed for datatype after create SQL Script for created table

Refer updated screenshot: Reopened_13759_RC-8.png

ivangron 2015-10-07T15:20:38Z

Code was checked in 20 minutes before build was complete. Please try version v17.0.0-rc-9

raghavsingh 2015-10-09T03:54:02Z

Verified in ADS-17-RC-11. Refer updated screenshot '13759_RC-11.png

tariqrahiman 2015-12-04T03:55:04Z

Verified in ADS v17.0.0-rc-49

Search Tips

Aqua Data Studio / nhilam

DB2 ZOS : Incorrect create table script generated for decfloat datatype.

4 attachments

Issue #13759

Completion

Search Tips

Aqua Data Studio / nhilam

Title

DB2 ZOS : Incorrect create table script generated for decfloat datatype.

4 attachments

Issue #13759

Completion