Expert Knowledgebase
DB2 with Craig Mullins
Comparing DB2 and Oracle on OS/390
(10 FEB 2005)
What is the difference between DB2 and Oracle in
the OS/390 environment? And which one is better?
I couldn't find a clear and fair answer to this question.
Runstats command to update all columns of multi-column index
(10 FEB 2005)
If I run the following Runstats command:
Runstats Database.tablespace Index(all)
will it update ALL columns
of a multi-column index or just the first column?
How much CPU overhead used to process SQL error codes?
(10 FEB 2005)
DB2 v7 z/OS: Our performance monitor has a SQL error summary that shows
thousands of SQL error codes per hour. Most of these errors are handled in
the application code (COBOL CICS) and do not result in an...
FETCH FIRST ROW ONLY in an update query?
(10 FEB 2005)
Can I use
FETCH FIRST ROW ONLY in a select statement of update query?
Example:
(SELECT SCH.SCHEDULEID FROM ASHOK.INTERVIEWERSCHEDULEMASTER SCH,
ASHOK.RESUMEDETAILS SSS WHERE SCH.INTERVIEWLOCATION
=SS...
Equivalent of Oracle's DUAL table
(10 FEB 2005)
Is there an Oracle DUAL table equivalent in DB2? Could you please let me
know?
Possibilities of deadlock
(10 FEB 2005)
I have seven different transactions, a job accessing a table and a job
inserting records to the same table. Will there be any possibility for
deadlock? If so how to overcome this issue?
Dropping a column in 7.2 database
(10 FEB 2005)
I would like to drop a column from a DB2 7.2 database. Is it possible to
do this by backing up the table, setting integrity off, dropping table, restoring the
table without the field to be dropped, and the...
Granting ALTER to any user
(10 FEB 2005)
Can we grant ALTER on any table to any user like as in Oracle?
grant alter on any table to user
Where can I get this list of grants? From any system catalog?
Equivalent of SELECT INTO
(10 FEB 2005)
What is equivalent to SELECT INTO in DB2? In Oracle or SQL Server, it is
possible to use "select into" and create a table.
Converting Oracle SQL to DB2
(10 FEB 2005)
I am new to DB2. We are migrating an Oracle database to DB2. In this
conversion, I have to convert following
Oracle SQL to DB2 SQL:
Oracle:
=======
Select T1.A1,
T2.P1,
T3.X1,
...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
