Hi and happy new year
I search a news group for DB2 sql language .
This is the one here...
(I need to find primary key on a table name and delete it)
Have a look at the SYSCAT.TABCONST catalog view. It lists all constraints,
including PK, and you can use that to construct the respective ALTER
TABLE ... DROP CONSTRAINT ... statement.
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
QOTW: "Python, the language that wraps tightly around a problem and
swallows it whole." -- Raymond Hettinger
Because it is so important, this link is re-posted for the future
(originally...
QOTW: "It might be nice if it was widely understood (in IT) that Python was
a language any competent programmer could pick up in an afternoon, such that
Java, C, and Perl shops would not be...
QOTW: "This whole charset mess is not meant to be solved by mere
mortals." - Thorsten Kampe, a day or so before solving his
symptom with a codecs method:...
QOTW: "If you really want to learn hard-core Python, probably your best bet
is:
* read everything Tim Peters has ever written in comp.lang.python
(this will take a few months), start with "import...
QOTW: "Python is a revelation to me as a language that grows with the ability
of the programmer, which creates a multi-level community not too centered on
one-upmanship to nurture new talent." -...
QOTW: "However, inspection of a vast corpus of code might lead one to believe
that any commenting capability was completely unnecessary." - Jim B. Wilson
"The Python people also piped to say...
QOTW: "The problem is, I never feel like I'm programing
the *problem*, I always feel like I'm programming the *language*." - Roy Smith
Alternatives to the Decimal type:...
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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,...
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...
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
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,...
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...