I am trying to generate sql from sql. Like
select 'select count(*) from ' ||
tabschema ..............syscat.tables where.....;
is there a way to run this with a single statement?

Hey, all.
Subject line says it all.
But for background:
I'm developing on UDB for Windows. The production application is on z/

I am an old-time  mainframe programmer.    MVS,  JCL, JES, DB2.
I notice alot of my colleagues are migrating their  mainframe
applications to newer client/server.
However I am happy my company has comitted at least 10-15 years to

Does anyone know where to get DB2 reference manuals.   Would we order
these through IBM?

we are currently trying to migrate from 8.x 32-bit to 9.5 64-Bit
(Windows 2003)
We also want to to migrate our SMS-tablespaces to automatic storage.
The only option for us is db2move with copy schema. In Our tests we

I'm running DB2 Express-C on a Server 2003 box acting as an additional
domain controller in our small domain.
I'm trying to create a simple task to connect to a database, call a
stored procedure and the disconnect.

i am trying to run advise using the following parameter and i get this
error against one of the database :
db2advis -d db1 -i test.sql
Using user id as default schema name. Use -n option to specify schema

In office, I can have RedHat AS 4.0.
And I like to configure a DB2 for home lab system.
Which one is better OpenSuse 10.3 or CentOS?

Hi, all.
My background is more Oracle than db2. My skills at SQL tuning are
quite limited.
I'm running 8.2 on Windows.

lvmbi@worf:~$ db2 connect to sqldba user username using difficultpwd
SQL0332N  Character conversion from the source code page "923" to the
target
code page "UNKNOWN" is not supported.  SQLSTATE=57017

   I have a newbie question about backing up our database on our
Solaris
   system. I was reading the "Data Recovery and High Availability
Guide

I have an issue with SET INTEGRITY after loading my table. Set
integrity does not see integrity violations checking by trigger. My
shell script does the following steps:
- LOAD FROM ... REPLACE INTO my_table

My company changed the security policy for DB2 server in mainframe. To
implement this policy in client, I have to enable encryption of Server
authentication for the two different db2 clients, one in UNIX and the
other in Windows.

I am trying to pass an XML document in a trigger from a transition
table to a Stored Procedure.
I can get the Stored procedure to accept it successfully from an
appllication call. So I know that functionality is there on the SP

Any IBMers out there know if IBM intends to incorporate Informix's SDS
functionality into UDB?
Lew