Hi All,

I have following error when I try to get data from syscat.tablespaces. However everything works fine when I have similar SQL to get get from syscat.tables. Any idea on this issue? I also check the privilage of syscat.tables and syscat.tablespaces. They are the same.

Thanks,

Mike
----------------------------- Commands Entered ------------------------------
Select 'list tablespace containers for ' || tbspaceid || ' show details;'
from syscat.tablespaces
where tbspace like 'SGIRA%'
;
------------------------------------------------------------------------------
Select 'list tablespace containers for ' || tbspaceid || ' show details;' from syscat.tablespaces where tbspace like 'SSS%'
SQL0440N No authorized routine named "||" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884

SQL0440N No authorized routine named "||" of type "FUNCTION " having compatible arguments was found.

Concatenation only works on character data.

How can I list the container of all tablespaces. I can only find the following command to list, but it can show the container for individual tablespace. Is there any way I can get the container of all tablespaces?

list tablespace containers for # show details

Thanks a lot!

Mike

n_i gave you a point.
You have to change:

Got it. Thx a lot!