by: maricel |
last post by:
I have the following base table structure - DDL:
CREATE TABLE "ADMINISTRATOR"."T1" (
"C1" INTEGER NOT NULL )
IN "TEST_TS" ;
ALTER TABLE "ADMINISTRATOR"."T1"
ADD PRIMARY KEY
|
by: bwmiller16 |
last post by:
Folks -
OpSys: RH Linux, AS3
DB: UDB 8.2.0 (FP7 Stinger)
HW: 2 X-series
We setup a HADR pair and they went into PEER state (after we backed-up
the DB on primary and restored the DB on the...
|
by: technocrat |
last post by:
I am trying to laod 2 tables and set integrtiy on them, but the second
tables fails ( both are related and SET INTEGRITY ion first table
succeeds) saying constraint violation....is there a way to...
|
by: technocrat |
last post by:
I was runing load and then set integrity with for exception clause,
still the statement failed , there are some reecords in the exception
table but the actual table is still in check pending...
|
by: mahhsuri |
last post by:
I have 120 tables which mostly dependent to each other. Just did a
db2move for all data. Now causing SQL0668 error when accessing tables
with dependencies.
Now I am running SET INTEGRITY command...
|
by: Brian Tkatch |
last post by:
Is there a way to check the order in which SET INTEGRITY needs to be
applied? This would be for a script with a dynamic list of TABLEs.
B.
|
by: Brian Tkatch |
last post by:
A few questions about SET INTEGRITY.
1) Docs: The SET INTEGRITY statement is under transaction control.
Using two sessions (different user, even) i tried the following.
Session 1: UPDATE...
|
by: Doug |
last post by:
Hi all,
I have an issue with SET INTEGRITY after loading my table. Set
integrity does not see integrity violations checking by trigger. My
shell script does the following steps:
- LOAD FROM ......
|
by: trixxnixon |
last post by:
i have a form that is being designed to pend requests in a requests database.
the pend form is opened from an update form used by an employee to enter updates. when the pend form is updated, the...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|