Error in my sql statement please help
SELECT     PRODDTA.F5549110.BLITM, PRODDTA.F41002.UMITM,
PRODDTA.F5549110.BLUOM, PRODDTA.F41002.UMUM
FROM         PRODDTA.F5549110, PRODDTA.F41002

I need to know if my regular relational database, now in DB2 v9.1 can
be transformed to an XML database easily?
The data can very easily be represented in XML, but can I convert a
regular table into an XML table and retain Stored Procedures and

Running DB2 on AIX.
I've read
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0408lee/
DMS tablespaces on concurrent I/O file systems (with the AUTORESIZE YES

J have database DB2 and create table T_TEST with fields:
ID - integer autoincrement
NAME - varchar(50)
QTY - Integer

I would like some opinions on my proposed solution to solve the
problem our production main job is having with lock suspends/
deadlocks.
Machine is a z/OS 01.06

I have a fulltime DB2/UDB Developer opportunity with a global
investment firm in NYC. If you are interested please send me your
resume.
I don't know whether this group can be used for job postings. If not,

Is it possible to create a DMS/SMS tablespace on an automatic storage
enabled DB2 V9 database? I don't have a personal copy to try it out.
Thanks,
Sam

Folks -
DB2 FP9 on Linux AS 4.
We are running PeopleSoft which has every table generated with "Not
Logged Initially".  Fine.

I have two tables TABLE1 and TABLE2 each has it's own primary key. TABLE2
has a foreign key to TABLE1 and TABLE1 has foreign key to TABLE2. Now I
have done a LOAD FROM NUL REPLACE INTO TABLE1 and LOAD FROM NUL REPLACE
INTO TABLE2 and both tables are in Set Integrity Pending state.

I need to see if some rows exist, but do not need to read them. The best
I could come up with is:
$sql = "SELECT 1 FROM $schema.auction_owners
         WHERE auction_id=$ai

I have a DB2 8.2(fk14) running on Solaris 9 server. Once the DB2
working, I can see more than 30 DB2 processes(db2sysc) running at the
same time. Is that normal?
Thanks.

What methods are there for migrating Oracle rowid based dml into DB2?
We have lots of code that uses the following method in Oracle
select rowid into lRowid from <table>;
.