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.