Is there a strong interface between PHP and DB/2 UDB on Linux? Something that brings through the unique to DB2 capabilities so that PHP can utilize them. IBM has made DB2 very Java'ish which is
annoying to me as I am no fan of what Sun has done with Java. C++, Open Object Rexx, ...

Hi again,
I'm wondering if it is possible within DB2 SQL to obtain the AS400 job
information - either the job number or name.
I've had a look at GET DIAGNOSTICS but cannot see anything in there,

I want to set the rowcount equal to one (1) prior to a delete statment, but
when I issue this command:
       SET ROWCOUNT 1
via the "Run SQL Scripts" application of the iSeries client tools Navigator,

When I build a procedure , I get a message Build has started , then
there is no progress. What can be the issue? Can anyone help me ?
Vj.

I am running DB2 WSE V8 with FP9a on a Windows 2000 SP4 machine and I
have encountered what appears to be a bug with the db2set command, and
was wondering how to offically submit this as a problem to IBM.
The problem concerns the use of the -v (verbose) option of the db2set

I have an update trigger as shown below that is intended to write a
before image record to an audit table. However when I update a single
row in the underlying table, two records (identical apart from a tiny
difference in the timestamp) get written to the audit table. Can anyone

I need to connect SQL Server 2000 to DB2 on z/OS through DB2 Connect 8.
I can successfully connect and query data through a System DSN, but
trying to link the server using this DSN and MSDASQL fails (can't seem
to find the DB2 Connect server).  I've also tried IBM's OLE/DB driver

I am trying to load a small file to DB2 v8.1 and I am getting an
interesting error message.  I haven't found a clear explanation of what
it means or how to resolve it yet.
This is the error I am getting:

We have main Four Databases on Production server in which we have lot of
schemas ,each schema
represents a client .
so i want to ask what is the beneficial whether creating a limited  databases

I need to udpate the name of a DB2 6.1 UDB server. The only place I see it show up is the SPN_NAME in dbm cfg. When I update this it is successful, I then terminate and restart DB2. After the restart
the old name has come back. Is there some additional steps to get this name ...

Does anyone have the sql statements to create the DB2CERT database?  It
not on the CD that comes with the book.  I don't understand how IBM can
write a whole book based on this DB and not provide the code to quickly
create it...

Hi i am Mandar,
I am using db2mtrk -i -d -v to see how much memory db2 is taking.
But it is showing  details about all the databases on the server ,actually
according to me i think

I have a user that needs to use Unqualified SQL from an ASP
application.  I need to know what I can have them set to default to the
correct qualifier when he executes a sql statement. Can anyone lend a
hand?

I have an insert instead-on trigger on a view. The view is defined with
some embedded User defined function that returns VARCHAR(32000).
With my default buffer pool page size of 4k, I am able to insert and
update to the view if one of the column has the function applied. But

Anyone can give me a link which shows how to setup DB2 (v8) replication
step by step? Thanks.
As a non-DB2 person, I find out IBM DB2 doc is not very helpful at all,
espeically compare with Oracle docs.