CMS Snapshot Analysis - Run Analyzer - Missing or Wrong Links per technology - Sybase - Missing link when two objects are in different database

This page provides solution to the missing link between two objects of SYBASE say procedure and table when both belong to two different database.Ideally link should be crated for following two syntax :

1. Select <coulmn name> from Database.schemaname.tablename
   
   
   
   
2. 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 such two object

When resolving table name in SQL statement scope, the schema scope of the procedure is used

though the database name is provided and is not the one the schema belongs too.

However for below syntax, when schema name is repalced with .. then link is missing.
Select <coulmn name> from Database..tablename

Workaround is to

1. Update the procedure and replace the .. with actual schema name

Issue is planned to be fixed in 7.3.6

TBD