SnowConvert: Scripts Line Conversion Summary

Note

This section applies only to Teradata reports.

These fields are counted for the following Script files:

  • BTEQ: .bteq, .btq

  • FastLoad: .fload, .fl

  • MultiLoad: .mload, .mld, ml

  • TPump: .tpump, .tp

  • TPT: .tpt

Lines of Code

Represents the number of lines of code found in the Script files. This counting includes comments but does not include empty lines or lines with only whitespaces unless they are inside block comments or strings. Lines of code that were not recognized are counted as well.

Samples

Note

Samples of the SQL Conversion Summary Lines of Code also apply to Scripts Lines of Code.

.RUN FILE 'myscript.txt'

.SET FORMAT ON;
Copy

Expected Lines of Code: 2

DATABASE tduser;
Copy

Expected lines of code: 1

.LAYOUT Something;

INSERT INTO myTable (
    myValue
)
VALUES (
    123
);
Copy

Expected lines of code: 7

.logtable TheDatabase.tpumplog;
Copy

Expected lines of code: 1

DEFINE JOB my_job
DESCRIPTION 'A description
goes here'
(
     DEFINE SCHEMA my_schema
     DESCRIPTION 'The schema' (value VARCHAR (10));

   STEP setup_tables
   (
      APPLY ('DELETE FROM &some.name;')
      TO OPERATOR (DDL_OPERATOR () );
   );
);
Copy

Expected lines of code: 12

CSV Associated Field Names

  • ScriptTotalLoc

LOC Conversion Percentage

This is the percentage of fully converted lines divided by the total lines of code. Unrecognized Lines of code count as not converted. Comments count as converted.

Formula

scripts_converted_lines_of_code / scripts_total_lines_of_code
Copy

Samples

Note

Samples of the SQL Conversion Summary LOC Conversion Percentage also apply to Scripts Lines of Code.

CSV Associated Field Names

  • ScriptTotalLoc

Unrecognized Lines of Code

This is the number of lines of code that had an element that was not recognized.

Samples

Note

Samples of the SQL Conversion Summary Unrecognized Lines of Code also apply to Scripts Unrecognized Lines of Code.

CSV Associated Field Names

  • ScriptsUnrecognizedElementsLOC

Language: English