Find the number of rows in a table from metadata

I want to write a single select statement to determine the number of rows in a set of tables in Sybase IQ. In SAS, I write this as CREATE TABLE dsnobs as SELECT libname,memname,nlobs, datetime() format DATETIME16. as timestamp FROM dictionary.tables WHERE (libname=upcase('MY_LIB') & memname IN ('TABLE_1', 'TABLE_2', 'TABLE_3')); For your information, - a SAS libname is something like a table creator or table space - the dictionary are similar to IQ SYS tables - memname is just the name of the table Can I do the same thing in IQ? An approximate solution, or an indication on the space used would suit me too.