× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
hmalsch reported 2012-02-10T16:50:38Z  · last modified 2012-02-14T15:11:16Z

For iSeries DB2, scripting an existing view in the Query Analyzer is missing the body of the view.


Priority Major
Complexity Unknown
Component Editor - Debugger for DB2
Version 10.0

I'm running ADS 10.0.7 on Windows 7.  I've also tested the following on another computer running ADS version 9.xx with the same results.  I'm connected to an iSeries DB2 database. 

I created a view using Aquadata as follows:

CREATE VIEW vwErrors( ID, MESSAGE_ID, VALIDATOR_NAME, TYPE, MESSAGE, DETAILS, FIELD_NAME, RT, TT, DAY_HEADER_ID)
AS
   select ID, MESSAGE_ID, VALIDATOR_NAME, TYPE, MESSAGE, DETAILS, FIELD_NAME, REPORT_TYPE as RT, TRANSACTION_TYPE as TT, DAY_HEADER_ID
     from VALERRORS

GO

The view works fine, but when I right click on the view in Server Explorer and select "Script Object o Window As..." - "Create", I get this:
-------------------------------------
 DROP VIEW CRMINT.VWERRORS
 GO
 CREATE VIEW CRMINT.VWERRORS ( ID, MESSAGE_ID, VALIDATOR_NAME FOR VALID00001, TYPE, MESSAGE, DETAILS, FIELD_NAME, RT, TT, DAY_HEADER_ID FOR DAY_H00001 )
 AS

 GO

...a bunch of GRANT statements here...
-------------------------------------

The body is completely missing.  The same happens if I go directly to "Alter View"

Harry

3 attachments

Issue #6428

Closed
Fixed
Resolved 2012-02-13T22:32:47Z
 
 
Completion
No due date
Fixed Build 10.0.7_03
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017