× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2015-03-12T17:45:39Z  · last modified 2015-03-12T20:42:53Z

DB2 iSeries -> Primary key constraint -> Scripting: Schema is not appended for Create/Drop


Priority Major
Complexity Unknown
Component Script Object
Version 15.0

DB2 iSeries -> Primary key constraint -> Scripting: Schema is not appended for Create/Drop

If you create a table with below script and then go to the constraint node and try to individually script Create/Delete that constraint the SCHEMA is not appended. I am not able to drop the constraint if I execute the script

CREATE TABLE QTCP.MARC11  ( 
A VARCHAR(25) NOT NULL,
B VARCHAR(25) NOT NULL,
CONSTRAINT QTCP.APK2 PRIMARY KEY(A)
)
GO

 

Script should be created like below with QTCP appended before APK2 which is the constraint name

ALTER TABLE QTCP.MARC11
ADD CONSTRAINT QTCP.APK2
PRIMARY KEY (A)
GO
 
 
 
1 attachment

Issue #13138

Closed
Fixed
Resolved 2015-03-12T18:21:26Z
 
 
Completion
No due date
Fixed Build v16.0.0-rc-10, v15.0.14-20
No time estimate

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