#11058: Double quote is missing in generated create view script in DB2-iseries.

nileshhmali reported 2013-12-16T06:00:20Z · last modified 2014-11-21T19:12:12Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	Future - .9

ADS version :ADS-windows-x64-15.0.0-Dev-51

Database - DB2-iseries-7.1

Connect DB2-iseries-7.1

Go to view node and right click -> Select tools->Select ER modular generator->Open entity relationship diagram window->

check view from object types,select any view name from list,click on next button.->opened Entity relationship diagram window.

Now on this window,tools menu->Select Generate script->check view from object types,select any view name from list,click on next button->

select double quote from object quoted identifier,click on next button.

Script generated by Aqua Data Studio 15.0.0-dev-51 on Dec-16-2013 11:16:58 AM

Database: M102739E

Schema: nilesh

DROP VIEW "nilesh"."test_view"

CREATE VIEW nilesh.test_view AS

SELECT "e_id","e_name","e_sal" FROM "nilesh"."employee"

Now you will observe that double quote is missing in generated Create view script.

All Comments (1) Change History

nileshhmali 2013-12-18T11:24:09Z

Same issue also reproducible in below databases,

Oracle11g
SybaseIQ
SybaseASE
Sybase Anywhere
Postgres
Mysql
Teradata
Vertica
Teradata Aster.
Oracle12c
Netezza