Summary: This document provides information about the analysis results you can expect from an analysis of SQL technologies using the legacy PL/SQL and T-SQL analyzers embedded in CAST AIP.
What results can you expect?
Once the analysis/snapshot generation has completed, you can view the results in the normal manner (for example via CAST Enlighten):
Microsoft SQL Server and Sybase ASE T-SQL
Objects
| Instance |
 | Database |
 | Schema |
 | Trigger |
 | Function |
 | Procedure |
 | Table |
 | View |
 | Table Column / View Column |
 | Index, Foreign Key Constraint, Primary Key Constraint, Unique Constraint |
Links
Links detected by the SQL Analyzer are listed in the attached Excel file:
Oracle PL/SQL
Objects
| Collection Nested Table Type |
| Collection Varray |
| Cursor |
| Database Link |
| Function |
| Function (Private) |
| Instance |
| Index, Foreign Key Constraint, Primary Key Constraint, Check Constraint and Unique Key Constraint |
| Object Type (Incomplete, Body and Header) |
| Package Body |
| Package Header |
| Procedure |
| Procedure (Private) |
| Schema |
| Schema (Unknown) |
| Sequence |
| Synonym (Public/Private) |
| Table |
| Table Column |
| Trigger |
| View (Normal and Materialized) |
| View Column |
Object properties that are supported by the current release of the embedded SQL analyzer are described in the attached Excel file:
Links
Links detected by the embedded SQL analyzer are listed in the attached Excel file:
