#14138: DB2 z/OS Script to Window Create Schema gives incorrect SQL syntax

tariqrahiman reported 2016-01-05T17:17:40Z · last modified 2016-01-06T20:05:16Z

DB2 z/OS Script to Window Create Schema gives incorrect SQL syntax

Dev	ivangron
QA	SachinPrakash

Priority	Low
Complexity	Unknown

Component	DB - DB2 zOS
Version	17.0

Version: 17.0.0-ga-19

Build #: 48060

Build Date: 2016-Jan-04 05:29:29 PM

Operating Environment: Mac OS X (10.8.5, x86_64) / UTF-8 / en / US / Oracle Corporation 1.8.0_40-b27

Memory: Max=5,637,144,576; Total=924,319,744; Free=618,436,136; CPUs=8

DB2 z/OS Script to Window Create Schema gives incorrect SQL syntax

Connect to IBM DB2 z/OS 11

1. Click on IVAN Schema and right click

2. Select Script to window -> Create

3. CREATE SCHEMA IVAN is generated

4. Replace IVAN with TARIQ so that sql is

CREATE SCHEMA TARIQ

5. Now execute the query. You will get incorrect syntax

>[Error] Script lines: 1-2 --------------------------

ILLEGAL USE OF KEYWORD SCHEMA. TOKEN AUXILIARY AUX TRIGGER JAR ALIAS INDEX UNIQUE TABLESPACE WAS EXPECTED. SQLCODE=-199, SQLSTATE=42601, DRIVER=3.67.28

6. Fix for Multi Select script Window as well

----

11/29/2013 revision 35063, flag was changed from false to true. Please check why this was made.

2 attachments

Screen Shot 2016-01-05 at 9.12.19 AM.png

2016-01-05T17:17:40Z

129 KB
14138_ADS-17-GA-20.png

2016-01-06T06:53:03Z

171 KB

All Comments (3) Change History

ivangron 2016-01-05T17:28:36Z

schema nodes should not allow for schema object scripting as there is no such object type or ddl in db2 z/OS

raghavsingh 2016-01-06T06:52:52Z

Verified in ADS-17.0.GA-20. Refer updated screenshot '14138_ADS-17-GA-20.png'

tariqrahiman 2016-01-06T20:05:16Z

Verified in ADS v17.0.0-ga-20

Search Tips

Aqua Data Studio / nhilam

DB2 z/OS Script to Window Create Schema gives incorrect SQL syntax

2 attachments

Issue #14138

Completion

Search Tips

Aqua Data Studio / nhilam

Title

DB2 z/OS Script to Window Create Schema gives incorrect SQL syntax

2 attachments

Issue #14138

Completion