we are using db2 ESE v8.2.3 on windows, i try to use command window to
do binding
D:\Program Files\IBM\SQLLIB\bnd>java -cp "D:\program files\ibm\sqllib
\java\db2jcc.jar" com.ibm.db2.jcc.DB2Binder -url xxx -user xxx -

Are there any particular DB or DBM parameters that would cause more
occurrences of this SQL error:
[IBM][CLI Driver][DB2/AIX64] SQL0805N  Package "NULLID.SYSLH106
0X5359534C564C3031" was not found.  SQLSTATE=51002

Hi, I have the following version of DB2 installed on a server:
FP9a_WR21350_WSE.exe
I have 2 client computers with the DB2 Admin version
FP9a_WR21350_ADMCL.exe

I know the way to listing all sql server in my domain via vb or
vba ...
but existis a method to have the same via vb or vba to find in my lan
or demain all db2 server?

We have a table (document_folders), which simulates a directory
hierarchy, so in this table, each folder has an attribute
"TopFolderID" to indicate which folder its contained in (for the root
folder that attribute is NULL). To enforce correct TopFolderID's, we

All,
Running environment is non-partition database for datawarehouse with
DB2 V8.2 on AIX.
We have a few logical grouping of tables that we would like to load in

Am using DB2 UDB v 8.2 Enterprise Edition. I have a database with code
set = UTF-8. Now I want my database to handle other data also apart
from English ie. Japanese, Spanish, German etc,etc. So, these Japanese
for ex. will be encoded as double byte character sequence while

I am debugging a C++ application that was ported from PostgreSQL to
DB2 UDB (v8.1.0.112) on Linux and have run across a problem.  We have
a singleton object that handles connection pooling, creating
connections, etc.  This object is declared static to ensure

I am trying to create a store proc that contain a create index with
the cluster option and I receive
DB21034E  The command was processed as an SQL statement because it was
not a

Stupid question, probably...
Is some version of the Development Client needed in order for the db2 header
files (sql.h, etc.) to show up in the sqllib/include library?  Or is there
some place we can just copy these from?  Our database is running on Linux,

I have a table containing MEASURE DOUBLE. I want to
SELECT measure FROM mytable WHERE <condition>
If measure = 1860.45, I get: '1,860.45'. How can I strip the comma? I
tried:

In researching a client error, I came accross this discovery.  We have
a 32-bit db2 client connecting to a 64-bit instance.  Would that cause
a problem ?  Here are the stats:
32-bit client

When i execute "db2 select * from
TABLE(SYSPROC.SNAPSHOT_LOCK('Test',0)) as test_locks" , i get the
details of all the locks on db test
i want to know how to get the correspondence lock_stmts (the statements

I want to recive some data from db2 (as400) using ado.net in visual
basic. Also i want to access them by stored procedure that return a
cursor. So, i create very simple stored procedure on as400:
P1 : BEGIN BEGIN DECLARE CUR CURSOR WITH RETURN FOR SELECT PRICE,

Group,
as subject line says: I'm trying to migrate databases from v8.2 to v9.1
db2 migrate database blabla
SQL0970N  The system attempted to write to a read-only file.  SQLSTATE=55009