Expert Knowledgebase
DB2 with Craig Mullins
Function to return a comma-separated text string
(21 JUN 2004)
DB2 has built-in column functions such as SUM({column-name}). But I need a
function to return a comma separated text string (VARCHAR) for, say,
EMP_NAME's within departments (Assuming there are at most 10 emp...
Setting buffer pools
(21 JUN 2004)
Buffer Pools: My boss advocates everything in BP0 and we have eight subsystems
running that way. The IDUG conference has taught me otherwise, but how do
you do the analysis to initially divide that one big bu...
Problem extracting timestamp with Brio software
(21 JUN 2004)
I am trying to extract a timestamp from a DB2 table using Brio software.
However, I am unable to receive an accurate nanosecond format. The timestamp
is correct until the last three digits of the six digit na...
Why use identity column with all of its problems?
(21 JUN 2004)
With all the problems identity column brings, is it worthwhile to invest in the
identity column? What is the approach to design using identity column?
Loading data into exisiting table with command load
(21 JUN 2004)
I want to load data from a file into an
existing table by help of command load (?); the database is an IBM DB2.
How can I manage that?
Can a function-based index be created?
(21 JUN 2004)
I'm trying to use the Case Insensitive search feature of a packaged product.
Since it is a packaged product, I cannot change the SQL created. The search
argument constructed by the software is: "where upper(...
Resolving the SQL0104N error
(21 JUN 2004)
I am trying grant access to the database to a group on AIX 4.3.3. We are
running DB2 v7.2 and I have successfully granted connect to the database. When I issued this command
grant select on table schema.ta...
Alternative to using "fetch first n rows"
(21 JUN 2004)
Is there an alternative to using "fetch first n rows" in a select statement?
I'm using it in a Java program where n needs to be a bind variable (coded as
?). I get this error:
COM.ibm.db2.jdbc.DB2Exception...
Definition of GETPAGE
(21 JUN 2004)
What is exactly is the definition of GETPAGE
in DB2 v7.1 on OS/390?
Reverse index in DB2?
(21 JUN 2004)
I wonder in DB2, is there any reverse index like in Oracle?
|
|
|
|
|
|
|
| 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 |
|
|
|
|
|
