Expert Answer Center > Database > DB2 > DB2 with Craig Mullins
EMAIL THIS
Expert Knowledgebase
  EXPERT KNOWLEDGEBASE HOME        RSS FEEDS  
DB2 with Craig Mullins
Display in sets of:       
1-10 of 438  << Previous   page 1 2 3 ... 42 43 44   Next >>
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, ...
1-10 of 438  << Previous   page 1 2 3 ... 42 43 44   Next >>
HomeExperts on DemandIT Expert Webcast SeriesExpert KnowledgebaseSite Index
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 technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts