CMS Snapshot Analysis - Run Analyzer - Missing or Wrong Links per technology - Sybase - Links between Sybase objects of different database is not shown when table name is prefix with double dot

This page provides solution to the missing link between two objects of SYBASE, say procedure and table when both belong to two different databases and when table name is prefixed with double dot.

Select <coulmn name> from Database.schemaname.tablename.

Ideally link should be created for following two syntax as shown in the below screenshot:

Select <coulmn name> from Database..tablename

However for 2nd case link is not created from procedure to table when such syntax is used in procedure as shown above.

1. Run Analysis
2. Explore Enlighten and notice link is missing between two such objects.

Impact is missing link

In the following statement when double dot is used between database and tablename, then Analyzer could not identify the scope of the table and hence link is missing. 

Select <coulmn name> from Database..tablename

Workaround is to

1. Update the procedure and replace the syntax Database..tablename  with

   Database.tablename or
   Database.schema name.tablename

Ticket # 1752

Issue is planned to be fixed in 7.3.6