#11076: Double quote is missing in generated create view script in DB2LUW.

kirtipbankar(*) reported 2013-12-17T06:35:02Z · last modified 2014-11-21T20:27:19Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - ER Modeler
Version	16.0

Database version:DB2LUW 10.1

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

Connect DB2LUW

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,Select 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.

DROP VIEW "VACT"

CREATE VIEW VACT AS SELECT ALL ACTNO , ACTKWD , ACTDESC FROM ACT

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

All Comments (0) Change History