-101 SQL statement length invalid - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-101 SQL statement length invalid

Possible Cause

The length of the incoming request is invalid. The two-byte length field preceding the request must contain a value in the range 1 to 32767 bytes. The application may have overwritten this field. Another cause could be the total size of the input data for the SQL request is greater than 32767 bytes.

Possible Solution

Verify that the program has not overwritten the length field during processing. The request is in the area addressed by the RDTSQL field in the associated RDTIN structure. The first two bytes of this area should contain the length of the request. If the length appears correct, contact your support personnel. If the size of the input data exceeds 32767 bytes, then correct the request and resubmit it.