SQLCHECK(FULL|NOSYNTAX)
-sc FULL|NOSYNTAX - Teradata Preprocessor2

Teradata® Preprocessor2 for Embedded SQL Programmer Guide

Product
Teradata Preprocessor2
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
whb1544831946911.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Specifies the level of checking to be performed on embedded SQL statements.

Usage Notes

Option Description
FULL Specifies that syntax, object references, and privileges checking are performed on embedded SQL statements.

This is the default. Use it whenever ENTRY or INTERMEDIATE for SQLFLAGGER is specified.

NOSYNTAX Specifies that no checking is to be performed on embedded SQL statements; and no syntax, object reference or access rights checking is performed.

Specifying the NOSYNTAX option to the SQLCHECK parameter disables the logon to the database during the precompile phase. It has no effect on runtime.

If both NOSYNTAX and a SQLFLAGGER of ENTRY are specified, PP2 generates an error and uses the default SQLFLAGGER value of NONE.