Can someone clarify what is EXTEND USING option in the CREATE INDEX
command for, what kind of index structure it creates? Is it a new
feature introduced in FP10, or it's been around for awhile yet?
Thanks,

                In sybase there is a create default statement in order
to create a default object.
like
CREATE DEFAULT one as 1

I applied FP9a on top DB2 UDB 8 FP8. Now I notice in Control Center to
get this error:
[IBM][JDBC Driver] CLI0611E  Invalid column name. SQLSTATE=S0022
when I slelect any table then Show Related->Tables Spaces. Is supposed

Magna Infotech - a part of $ 1 billion Nagarjuna Group has
development centers in USA & India.
Magna is an ISO 9001:2000 certified company
Magna is a STPI regd. company

I'm trying to put together a simple util that will help me during
performance tuning, It will grab a bunch of values from different
snapshots and the db/dbm cfg, and print out different values, and if a
certain threshold value is reached, some information of which parameter

I wish to return a dosage (DECIMAL(7,3)) concatenated with its units
(VARCHAR(15); i.e., 1.500 cc. When I do this as shown below, I get
001.500 cc. Is there any easy way to elide the leading zeroes?
CAST(t4.dosage AS CHAR)||' '||t5.dosage_units AS dose,

Is there any split function in DB2? How to split a field value
separated with delimiter ","(comma)?

I would like to ask is these any DB2 function that can concatenation strings
and have grouping capability??
for example,
Tables:T

Hi, i recently installed administrative client on one of our prod
machines. from configuration assistant when i try connecting to our
server using ODBC driver i get the follwing error odbc drivers cannot
be loaded system error  127 , but i can connect using CLI Any help

I am getting the below error message when I am trying to connect from
client to remote database server installed on Linux. DB2 UDB ESE
database is running on a trail version on Linux and client
(administration client) installed on Windows.

Vol. 1 of SQL REFERENCE contains the following statement in the
description of CHAR:
Note: The CAST expression can also be used to return a string expression.
I was trying it in order to get rid of leading zeroes when I got the

I am writing a 64bit application for Solaris 10 and am need of 64 bit
binaries for the ODBC interface. What I have found so far are 32 bit
libraries that work on a 64 bit platform. Because I need to link my 64
bit application to the libraries, I need libraries compiled 64bit.

New to DB2 .
Want to create a disaster DB2 server with minimum resources, as
client(small company) can't afford big and don't have much budget to
spend.Currently backing to local tape. Tape is kept locally in safe,

All -
I am trying to figure out how to get a comma delimited file from the
command line which includes the column headings as the first line.  I
know how to create a del file using export, but it doesn't put the

Not having earned my DBA badge from the scouts just yet I'm a little
lost with an error I'm getting.
We've just upgraded our development database from 7.2 to 8.2 as the
first step in upgrading our wider environment. Of course, development