Top-Level Queries Report
The top-level queries report provides a general overview of the main queries (SELECT, UPDATE, INSERT, DELETE) present in your source code that are not part of other queries.

What is a "Top-Level Query"?

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:
Structure
Assessment for Teradata SQL *
Assessment for Oracle SQL
Assessment for Transact SQL
Select
🗸
-
-
Update
🗸
-
-
Insert
🗸
-
-
Delete
🗸
-
-
*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.

Where can I find it?

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.

What information does it contain?

The top-level queries report contains the following information about all the top-level queries found while converting:
Column
Description
PartitionKey
The unique identifier of the conversion.
FileType
The type of file that the object is in. (SQL, BTEQ, etc...)
ObjectName
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>*/
HighLevelObject
The friendly name of the top-level query.
FileName
The name of the file in which the query is located. Uses the relative path starting from the input directory.
LineNumber
The line number inside the file where the query is located.
LinesOfCode
The total lines of code that the query has.
HighestEWISeverity
The highest EWI severity found within the query.
ConversionStatus
The final status of the conversion of the query.
EWIs
The descriptions of all the EWIs found within the query.
UDFsUsed
The names of all the user-defined functions found within the query.
ConversionPercentage
The conversion percentage of the query.
EWIsNumer
The amount of EWIs found within the query.
Last modified 8mo ago