i'm using sybase sql server any where 7 and by using
dbsrv7.exe i'm able to create db.
it's working fine. no issues.
now i'm upgrading to sybase sql server any where 9 and by
using dbsrv9.exe i created
db. this time when i'm using sysindexes table of sybase i'm
getting
error as
Table name 'sysindexes' is ambiguous exception
com.sybase.jdbc2.jdbc.SybSQLException
because ASA Error -852: Table name 'sysindexes' is
ambiguous
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -852: Table
name 'sysindexes' is ambiguous
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2796)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2126)
at
com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc2.jdbc.SybStatement.queryLoop(SybStatement.java:1578)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:1563)
at
com.sybase.jdbc2.jdbc.SybStatement.executeQuery(SybStatement.java:418)
at
com.cisco.nm.util.db.DBUtils.doesIndexExist(DBUtils.java:174)
why this is happening. any help is appreciated.