× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported Mar 12, 2015  · last modified Mar 12, 2015

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
ivangron   Mar 12, 2015
Field Old Value New Value
Fixed Build v16.0.0-rc-10, v15.0.14-20
Resolution Fixed
Resolved Date Mar 12, 2015 6:21 PM
Status New Resolved
tariqrahiman   Mar 12, 2015
Field Old Value New Value
Status Resolved Closed

Issue #13138

Closed
Fixed
Resolved Mar 12, 2015
 
 
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