var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: can i use the list tablespaces command in a procedure
i need to find the total free spaces in MB in a tablespace.
can i use the list tablespaces command in a store procedure, or is their a query i can use instead?
I don't think you can execute LIST TABLESPACES from a procedure. However, you can query SYSCAT.TABLESPACES to retrieve the information you need.
If you are on Version 8 , you can use the SNAPSHOT_TBS_CFG table function
Visit the new-look IDUG Website
, register to gain access to the excellent content.