Content Preview for: DB Systems & Applications Weblog
-
Be proactive. Don't let your manager be blindsided in the hallway by some problem you've been working on. "You'd be surprised at people who are up all night fixing a problem and don't tell anyone," Floss...
Read more »
-
By decipherinfosysThis project needed to support having multiple NULL values in the column and still have a UNIQUE constraint. That is allowed by Oracle but not in SQL Server and DB2 LUW. There is a way...
Read more »
-
User comments for the following queries are highly appreciated.. How does one compare data between 2 identical tables in DB2 ? In Oracle, one can use the minus option which is not there in DB2.
Read more »
-
IBM (NYSE: IBM) today unveiled a new version of its Informix Dynamic Server (IDS) software designed to help companies better manage and utilize the deluge of data generated from global operations while...
Read more »
-
DB2 Truncate is not as straight forward as Oracle Truncate. If in Oracle you can use "truncate table "… You may use the below command to truncate table in db2. alter table schema.table_name activate not...
Read more »
-
IBM officials said the company's database business, bolstered by last year's releases of DB2 9.5 and IDS 11, enjoyed a solid first quarter of 2008. With all the talk surrounding IBM’s successful first...
Read more »
-
Today's tip: Don't put DDS-defined logical file names in your SQL statements. To understand why, let me give you a little background. When you execute an SQL command, the system determines the best way...
Read more »
-
This week's tip: In your QAQQINI file, set IGNORE_DERIVED_INDEX to *YES. So what does that mean? First, QAQQINI is a file that you can use to control query processing. If you're not familiar with it, follow...
Read more »
