Hi Friends,
I am new to db2 database and trying to convert a sql statement that works fine on SQL-2000 into db2 database.

Basically What I am trying todo is If I have two tables named table1 and table 2, I want to count the number of rows in these two tables and represent the results as two different coloumns in the result set. The following statement works fine for me in SQL server 2000. Can anyone tell me the equivalent db2 statement

SELECT (SELECT COUNT(*) FROM Table1) AS Count1,
(SELECT COUNT(*) FROM Table2) AS count2

The resultset is a table with two coloumns Count1 and Count2 in it.

Thanks,
Sai

See if this example helps :

values((select count(*) from syscat.tables),(select count(*) from syscat.views))

Thanks for the reply.
But when I try to execute this in db2 using strsql
then it says,
INTO clause missing from embedded statement.
Am I doing something wrong ??

-Sai

If you are coding embedded SQL, every SELECT/FETCH statement should have the INTO Clause

SELECT col1,col2 into :col1,:col2 from table1

or
FETCH Cursor1 into :col1,:col2

Of course, SELECT Statement in a cursor defn is an exception

(Pl check the syntax)

Cheers
Sathyaram

select (select count(*) from t1), (select count(*) from t2) from sysibm.sysdummy1