Expert Knowledgebase
DB2 with Craig Mullins
General recommendations for DB2 compression
(21 JUN 2004)
Are there any general recommendations or questions to ask to determine when
to use (or not use) DB2 compression? Does the type of DASD we use or the
operating system level impact this decision? Is there a m...
Using host variables after ORDER BY
(21 JUN 2004)
I would like to use SQL query with following clause:
SELECT COL1,COL2,...
FROM TABLE
WHERE COL1=...
ORDER BY:HOST-VARIABLE
Now i'm getting an error showing
ILLEGAL SYMBOL ":" in the query.
Th...
Primary key name not showing up -- error SQL0204N
(21 JUN 2004)
Using DB2 UDB 7.2 Fixpak3 on AIX 4.3.3. We ran a reorganization. On the tables that have no clustered index, but have a unique index, the
primary key name is no longer returned by DB2look and does not show up ...
Eliminating duplicates when loading tables
(21 JUN 2004)
When loading a table using DB2 load utility, if my input file for load has
duplicate key values within, all the records with this key value are
discarded. But I want the first record to be loaded in this cas...
IDENTITY_VAL_LOCAL() on DB2 UDB V6.1
(21 JUN 2004)
Does this function IDENTITY_VAL_LOCAL(), work with DB2 UDB Version 6.1 on Windows NT? When
I try to call the function at the same level as the INSERT, it returns a
null.
Redundant predicates in the DB2 optimizer
(21 JUN 2004)
I have a partitioned database that has three columns in the clustering index. The
database has 70 million rows. I am using Visual Explain (VE) to show the
access path for three queries, each resulting in bas...
Accessing SQL details from DB2 log files
(21 JUN 2004)
At our shop we use DB2 Ver 5.0 on MVS. We have a front end tool (GQL) that
is being connected to the DB2. There is a provision in the GQL where users
can frame their own SQL and execute it at the backend DB2....
Fetching a date column with a DD-MMM-YYYY format
(21 JUN 2004)
I want to fetch a date column with the 'DD-MMM-YYYY' format. Can I do it in a single query? I tried, but got an error:
SELECT
CHAR(T1.COL_DT ,'DD-MMM-YYYY'),
FROM
TABLE1 T1
Any ideas?
Calling stored procedures through SQL
(21 JUN 2004)
How do I call DB2 stored procedures through SQL? What is the syntax? We have a stored procedure that has an OUT parameter. How do we get this OUT parameter?
Seeing the results of EXPLAIN
(21 JUN 2004)
I created Plan_Table in order to run an EXPLAIN on an SQL statement. I was
able to run the EXPLAIN, but now how do I read the results. I want to be
able to maximize the efficiency of my SQL statement. Any he...
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
