I have come back to DB2 after a few years absance.  I want to attach
to a remote instance from a Windows DB2 client and then list the
databases on the remote Linux DB2 server.
db2 attach to "remotenode" user xxx using yyyy.

I am working for the first time with DB2 via an ODBC link in PHP, and
I have the following working SQL generated by (ack!) Microsoft Query.
What I want to do is group by OB064.STSTYLE, and get a sum total per
style of OB1000.CFYARDS.  Simple eh?

I am new in DB2 8.1 below code works/logic works fine in Oracle, pls
find below the inline UDF , the intent of this UDF is to create a
string for each child and then return the computed string , following
query would be fired and it should give result in the stated format

I have a view defined as select * on base table. When base table is
altered to add new column, new column does not appear when selected
from view. Here is what I did to test.
db2 "create table test_sch.test ( c1 smallint, c2 smallint)"

I'm trying to call a z/OS stored procedure from Win UDB and am getting
a SQLCODE: -444, SQLSTATE: 42724.
On the the z/OS system log, I see -
DSNL027I  -PRDA SERVER DISTRIBUTED AGENT WITH 102

Chris Eaton gave an example of stored procedure transpose columns to rows
Here is an example of a rowtocol stored proc that takes a SQL statement as
the first paramter, a delimiter as the second parameter and the ouput (in the
3rd parameter) is the rows coverted to a column with the ...

My question is about checking my sql-syntax against DB2UDB V9 throug
JDBC 2.0
Is there a way to check my syntax,for example "select * from T1"?
Thank you for your help.

We are using DB2 V7 (MVS) in our shop, which dont have the luxury of
the 'WITH clause' - CTE support to accomplish recursive queries.
Here is my problem -
Table1

Dear guys
I tried to search about this topic in forum but could not get my reply
properly, can somebody tell me the exact commands and how to right the
db2move and db2look ? I have migrated the tables and data but the

We are getting following errors in diaglog. We have 4096 value as
MAXAGENTS and 512 for maxuproc
I am confused as which value we are hitting. are we hitting OS
( maxuproc ) value or MAXAGENTS.

Whats the difference of DB2 on say windows/linux machine vs DB2 on AIX or
DB2 on z/OS ?
I am new to this platform of z/OS. Is it the same as an AS/400 ? and is it
considered a mainframe ?

I am using udb version 8 fixpack 12 installed on Linux.
I need to move a schema from one db to another. All tables in the
target and source schemas are created using 'CCSID UNICODE'.
I used db2move export command from the db2 client on Windows XP.

We just got a "SQL Statement too long or complex" error on the
ISERIES.   James was able to get a compile after replacing some full
table names with (much shorter) correlation names, etc.
I have not see his query, but what are the statement size limits?  I

Hi All;
Working with a client running v9.5 on a non-partitioned VMWare
machine. In looking at the install requirements for version 9.1 on the
InfoCenter doc at http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp,

table T contains pair of the form (ID, VALUE) and it's ordered over
ID.
I need to write a query that for each row R of T computes the sum of
VALUE from row 1 to row R.