Top-level query is the term used to refer to the following SQL structures that are located at the top-level of your source code, meaning they are not part of another query:
Assessment for Teradata SQL *
Assessment for Oracle SQL
Assessment for Transact SQL
*Teradata currently uses a different report generation mechanism. It's planned to use the same one that Oracle and Transact use. For this reason, more accurate information for Teradata reports can be found here.
The top-level queries report can be found in a folder named "reports", in the output folder of your conversion.
The name of the file itself starts with "TopLevelQueries" so it can easily be located.
The format of the file is .CSV.
The top-level queries report contains the following information about all the top-level queries found while converting:
The unique identifier of the conversion.
The type of file that the object is in. (SQL, BTEQ, etc...)
The top-level statement index within the file or, a custom name for the query, if specified in a comment above it with the following format:
/* CustomName </sc-dml>*/
The friendly name of the top-level query.
The name of the file in which the query is located. Uses the relative path starting from the input directory.
The line number inside the file where the query is located.
The total lines of code that the query has.
The highest EWI severity found within the query.
The final status of the conversion of the query.
The descriptions of all the EWIs found within the query.
The names of all the user-defined functions found within the query.
The conversion percentage of the query.
The amount of EWIs found within the query.