Expert Knowledgebase
DB2 with Craig Mullins
Using the DELETE with CASCADE option
(21 JUN 2004)
Using the DELETE with the CASCADE option deletes the entire row matching with the value of the primary key. Suppose there is one more field that is declared
foreign key here and primary key to some other tabl...
What are the data types for DB2 for iSeries?
(21 JUN 2004)
What are the data types for DB2 for iSeries?
Varchar, number...?
Finding a JDBC driver pack
(21 JUN 2004)
Could you help me get the 'DB2 for OS/390 5.1 JDBC Driver' pack. I have been
on look out for this for a long time now. we have even downloaded the whole
DB2 UDB for OS/390 and searched the same for this drive...
When will the DB2 Developer's Guide be updated?
(21 JUN 2004)
When will DB2 Developer's Guide be updated for DB2 Version 7? The entire DB2
community is waiting eagerly and impatiently for this. Most of us will run,
not walk, to our nearest bookstore to buy it as soon ...
A step-by-step approach to creating a partitioned database
(21 JUN 2004)
Can you give me the step by step approach to creating a partitioned database
and a table with partition keys?
Listing rows using current date, part 2
(21 JUN 2004)
Thank you very much for showing me the use of the special register CURRENT
DATE ( question posed jan 18 ). It's too bad that the date field in my table
is in the format yyyymmdd (no dashes or slashes), while ...
DB2 equivalent of ROWNUM
(21 JUN 2004)
I want to display only 20 records from a select statement. Oracle
provides a reserved function ROWNUM which can be used in the SQL statements
to restrict the display of output:
Select * from table1 where row...
Definitions of SQL error codes
(21 JUN 2004)
Where can I find the definition of SQL error codes; for example, SQL0104N?
|
|
|
|
|
|
|
| TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of . |
|
| |
All Rights Reserved, , TechTarget |
|
|
|
|
|
