Hello

i had a script that i use to use on SYBASE 12.X to do a select and a
row count of all tables now in syabse 15.X it fails with

The built-in function 'rowcnt' has been deprecated. Use the new built-
in
function 'row_count' instead. Deprecated function returns value of 0.

if i use the row_count function if fails also with
Msg 11021, Level 16, State 2:
Function ROW_COUNT invoked with wrong number or type of argument(s).

this is the script

--select o.name, rowcnt (i.doampg)
select o.name, row_count (i.doampg)
from sysobjects o, sysindexes i
where o.type = 'U'
and i.id = o.id
and i.indid < 2

Sybase 15.0 on solaris 10
thank you
Maria

evoradba (AT) yahoo (DOT) ca pisze:
Hi.

row_count(db_id, , object_id, [ptn_id])

example: row_count(db_id(), object_id('table_name'))


Regards,

--
Marcin Najs