Problem:
========
I'm receiving SQL1101N when I sttempt to build a nickname in a
federated database.

I have some JDBC calling a DB2 mainframe (os/390) when I get the result
set back from a stored procedure call and get the ResultSetMetaData and
try to execute rsmd.getColumnName(1) all I get back is the String "1"
not the column name.

I am running a query from a Java app via the IBM type 4 driver back to
MF DB2 and am getting a strange result.
Basically my statement is
SELECT BLAH WHERE NAME LIKE ?

Hi @ll,
when i make a change on this parameters ->
Automatic maintenance             (AUTO_MAINT) = ON
Automatic database backup         (AUTO_DB_BACKUP) = OFF

Guys -
I'm doing a database consistency check for a client and I find that
they're building unique indexes for performance/query reasons where
they could be using non-unique indexes.

I am searching for Informations about a product called "DBConnect"
from IBM. It should be able to connect an application that is running
on a Windows client with the AS/400 (iSeries). I have heard this
product should be much faster than an ODBC connection. Is that true

I have a query that takes almost 1 hour to complete. This is acceptable
in certain situations, but unacceptable when no rows should qualify.
Something like:
Select list

After applying fixpack 10 on DB2 UDB ESE 8.1 (on Windows) all of our OS
scripts fails. The command which fails is:
      db2 -svtf scriptfile.udb -z scriptfile.log
The error message is 'DB21061E  Command line environment not initialized.'

we have configured a perfect DB2 HADR pair. After some days, we had
following problem:
After a reboot standby becomes standby, that's ok. Pimary becomes
primary, i tought db2 could do this then, when standby and primary

Can you have a Cobol program running on ZOS that accesses DB2 UDB
Version 8.2 located on a distributed environment (AIX)?  I also need to
hit CICS.  What software will I need if this is possible?
Thanks.

Our Health Center ("DB2 v8.1.0.64", "s040812", "MI00086", and FixPak
"7") hasn't been sending out email notifications for a bit now, but we
aren't sure why, since no configurations have changed (except the
server has been restarted, so perhaps something is 'off'). We just have

How to convert a string like '2,3,4' to three integer 2,3,4 in SQL
procedure of DB2 UDB 8.2?
Thanks!

We have installed Db2 UDB Enterprise edition on Linux and started
creating multiple databases.
We found out finaly the we had installed the wrong edition of product.
We should receive soon our licence.

Is anyone out there familiar with padl?  Is it possible to enable
authentication to DB2 with ldap by using padl?

I am few days old to the world of DB2 and right now i am stuck into a
problem that seems to be getting difficult for me.
Please have alook into this and provide me some help.
Below is one such procedure  that i have written ,