Aqua Data Studio 15.0.0-dev-70
Build #: 35519
Built on: 2014-Jan-13 03:38:49 PM
O.S. : Windows 8.1
Database : DB2 iSeries 7.1
Issue : Create/Drop script is not generated for Synonyms
Steps to Reproduce :
1. Connect and Expand tree node of DB2 iSeries Database.
2. Expand tree node of Schema.
3. Expand tree node of any Schema(e.g. test).
4. Right click on tree node of Aliases and Select "Create Alias" option.
5. Create Synonym window opens, Select Schema from Schema drop down list.
6. Enter five blank spaces and then name (e.g." new_syn") in name text field.
7. In Alias for pane, Select Schema from Schema drop down list.
8. Enter five blank spaces and then name (e.g." machine") in Object text field.
9. Click on Create button.
10.Go to tree node of Aliases, select and right click on newly created alias, select "Drop Alias" option.
Here it is observed that, Drop Synonym pop up window does not appears.
11] Again right click on newly created alias, select Script Object to Window As, Click CREATE/DROP option.
Here it is observed that, Script is not generated for CREATE/DROP option.
