how to add a sys.<viewname> in sybase as an view. The catalogs doesn't show the sys, dbo schema's for me to select the tables or views.

One of the reason why we need is to get the current timestamp from the database. The easiest method is select current_timestamp from sys.dummy.

Is there an alternative other than creating a view or proc for this purpose without having to do any database change?

thanks

None of those are imported as system views are ignored in almost all projects so we ignore them in the driver. (ASA or ASE?)

asa 10.0.1.3619, it seems like the alternative is just to add a proc to get current datetime i guess. thanks

I think that's best, as otherwise all the sys views are imported (if you enable it in the driver, the source is in the SDK) which is IMHO not that useful.