15.00 - -101 SQL statement length invalid - Teradata Tools and Utilities

Teradata Preprocessor2 (SPP Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

-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.