File and Object Level Breakdown - SQL Files

This section shows a general conversion summary for all the SQL files.

In Teradata, this table applies to all the files with the following extensions:

  • .sql

  • .dml

  • .ddl

Code Conversion Rate

This section shows the code conversion rate of the SQL files. For more information about these calculations check the Conversion Rate Modes section.

Formula

(converted_lines / total_lines) * 100

CSV Associated Field Names

  • SqlLoCConversionRate

Sample

Consider the following example, even though the second table is not recognized due to a parsing error, the comments inside are considered supported lines of code.

CREATE TABLE sample_table1 	-- converted
(				-- line with error
	-- Comment 1		-- converted
	col1 INTEGER,		-- converted
	-- Comment 2		-- converted
	col2 INTEGER,		-- converted
	-- Comment 3		-- converted
	col3 INTEGER,		-- converted
	-- Comment 4		-- converted
	col4 !INTEGER,		-- line with error
	-- Comment 5		-- converted
	col5 INTEGER!		-- line with error
);

CREATE !TABLE sample_table2	-- line with error
(				-- line with error
	-- Comment 1		-- converted
    	col1 INTEGER,		-- line with error
	-- Comment 2		-- converted
	col2 INTEGER		-- line with error
)				-- line with error

Expected Conversion Rate: 65%

Explanation: There is a total of 20 lines of code, and 13 of them were successfully converted by the tool. Using the formula, the conversion rate is (13/20)*100.

A line with an error is defined as every line of code that contains at least one error message. For more information check the Issues and Troubleshooting section of each language documentation.

Conversion Rate - Files Generated

This field applies only to Teradata reports.

It describes the percentage of SQL files that were successfully generated. The files that were not generated in the output are due to unexpected issues during the process of transformation.

Formulae

(files_generated / total_files) * 100

CSV Associated Field Names

  • SqlFilesConversionRate

Sample

input_folder
    input1.sql
    input2.sql
    input3.sql

Expected Files Generated Conversion Rate: 66.67%

Explanation: Only 2 of the 3 input files of the conversion were successfully generated in the output.

Conversion Rate - LOC

This field applies only to Teradata reports.

It describes the same as the Code Conversion Rate common section but applies to all the supported SQL file extensions in Teradata.

Total File Quantity

This field applies only to Teradata reports.

It describes the total number of identified SQL files.

CSV Associated Field Names

  • SqlFileCount

Sample

input_folder
    input1.sql
    input2.dml
    input3.ddl
    input4.bteq
    input5.fl

Expected Total File Quantity: 3

Explanation: In this sample, 3 of the files have a supported SQL extension.

Total LOC

This field applies only to Teradata reports.

It describes the same as the Lines of Code common section but applies to all the supported SQL file extensions in Teradata.

Lines of Code

It represents the number of lines of code in the SQL extension files. This counting does not consider blank lines, only the ones that contain code, comments, or both.

CSV Associated Field Names

  • SqlLinesCount

Sample

Folder1
    input1.sql            -- 20 lines
    input2.sql            -- 20 lines
Folder2
    input3.sql            -- 10 lines
    input4.sql            -- 5 lines
    input5.txt            -- 15 lines

Expected Lines of code: 55

Explanation: Only the lines in the SQL extension files are considered in this section.

Total Object Quantity

It describes the number of objects successfully identified in the SQL extension files.

CSV Associated Field Names

  • SqlIdentifiedObjects

Sample

CREATE TABLE sample_table1 
(
	-- Comment 1
	col1 INTEGER,
	-- Comment 2