Is there a way to enable / disable constraints in db2 v7?

Posted by mauro2 on Stack Overflow See other posts from Stack Overflow or by mauro2
Published on 2009-01-07T18:45:00Z Indexed on 2010/03/22 22:01 UTC
Read the original article Hit count: 328

Filed under:

db2

|

constraints

|

database

Hello people,

I have to copy tables from an Oracle database to a db2 v7 one, and in order to do this (avoiding millions of drops and creates) I'd like to know if db2 has a feature like Oracle to enable / disable constraints temporarily without dropping them.

Thanks in advance, Mauro.

© Stack Overflow or respective owner

Related posts about db2

link DB2 AS/400 (system i) and DB2 AIX

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, everybody. I have two different database in DB2, a in DB2 AS400 and other in DB2 AIX, is possible link this database, similar to link by Oracle? Thank you in advance. erva. >>> More
Speed-start your Linux App: Using DB2 and the DB2 Control Center

as seen on Internet.com - Search for 'Internet.com'
This article guides you through setting up and using IBM DB2 7.2 with the Command Line Processor. You'll also learn to use the graphical Control Center, which helps you explore and control your databases, and the graphical Command Center, which helps you generate SQL queries. Other topics covered… >>> More
DB2 LUW Security - The DB2 DBA as a Locksmith

as seen on Internet.com - Search for 'Internet.com'
Database security should have multiple locks at multiple layers with multiple keys (and perhaps some barbed wire, an electric fence, a moat and a mean junkyard dog as well). With all these locks and keys, some locksmith skills are certainly useful. Rebecca Bond introduces some of her favorite DB2… >>> More
Why can't Perl's DBD::DB2 find dbivport.h during installation?

as seen on Stack Overflow - Search for 'Stack Overflow'
We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error: ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More
DBI::DBD package not getting installed for Perl?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, We are using a Perl utility to dump data from DB2 database. We installed DBI package and it is asking for DBD package also. We dont have root access and when we try to install DBD package we are getting the following error. ERROR BUILDING DB2.pm [lijumathew@intblade03 DBD-DB2-1.78]$ make make[1]:… >>> More

Related posts about constraints

Java JTextPane JScrollPane Display Issue

as seen on Stack Overflow - Search for 'Stack Overflow'
The following class implements a chatGUI. When it runs okay the screen looks like this: Fine ChatGUI The problem is very often when i enter text of large length ie. 50 - 100 chars the gui goes crazy. the chat history box shrinks as shown in this image. Any ideas regarding what is causing this? Thank… >>> More
AWT Textfield behaves weird with MicroSoft JVM

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am facing a weird problem when using MicroSoft JVM to run my Applet. I have an AWT panel with 4 textfields which is added to a dialog box. Everything goes fine until I enter a decimal value into the textfield and close the dialog box. When i reopen the dialog box the textfield inside the panel… >>> More
MS SQL Bridge Table Constraints

as seen on Stack Overflow - Search for 'Stack Overflow'
Greetings - I have a table of Articles and a table of Categories. An Article can be used in many Categories, so I have created a table of ArticleCategories like this: BridgeID int (PK) ArticleID int CategoryID int Now, I want to create constraints/relationships such that the ArticleID-CategoryID… >>> More
jquery slider control issue

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I am using slider control to create a progress bar for media player. Problem: the max value and slider size is not matching. The video get complete before it reaches the end of the slider. Code: <script type="text/javascript" src="js/jquery.ui.core.js"></script> <script… >>> More
Ask Tom: "On Constraints, Metadata, and Truth"

as seen on Oracle Technology Network - Search for 'Oracle Technology Network'
Our technologist uses constraints to improve query performance. >>> More