Subquery aliasing returning-104 error

rajesh_m · New User Joined: 15 Apr 2008 Posts: 36 Location: India

SELECT COUNT(*) (SELECT NAME FROM SYSIBM.SYSTABLES
WHERE CREATOR='ABCD') AS T1 FROM T1.NAME;

What is the problem in this query why it is not working. It is returning-104 error. Any help appriciatable.

Craq Giegerich · Posted: Thu May 08, 2008 6:38 pm Post subject:

Maybe you should just explain what you are trying to do.

rajesh_m · New User Joined: 15 Apr 2008 Posts: 36 Location: India

SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR='ABCD'
This query will return the list of tables with in the creator 'ABCD' i need the count of records for those tables.

ashimer · Posted: Thu May 08, 2008 7:02 pm Post subject:

SELECT COUNT(NAME) FROM SYSIBM.SYSTABLES WHERE CREATOR='ABCD'

dbzTHEdinosauer · Posted: Thu May 08, 2008 7:32 pm Post subject:

guptae · Posted: Thu May 08, 2008 8:55 pm Post subject:

Hello Rajesh,

If you want to count the number of rows ine ach table where creator ='ABCD' then u can use following query

rajesh_m · New User Joined: 15 Apr 2008 Posts: 36 Location: India

Ajesh · New User Joined: 03 Apr 2008 Posts: 6 Location: Chennai

Rajesh,

Try running this query.Hope this will solve the problem

SELECT COUNT(*) FROM (SELECT NAME FROM SYSIBM.SYSTABLES
WHERE CREATOR='ABCD') A;

rajesh_m · New User Joined: 15 Apr 2008 Posts: 36 Location: India

[quote="guptae"]Hello Rajesh,

If you want to count the number of rows ine ach table where creator ='ABCD' then u can use following query

dbzTHEdinosauer · Posted: Fri May 16, 2008 8:23 pm Post subject:

cast it or use a function to convert...........