15.00 - 2663 SUBSTR: string subscript out of bounds in %TVMID.%FLDID. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

2663 SUBSTR: string subscript out of bounds in %TVMID.%FLDID.

Explanation:

This error occurs when a SUBSTR is used, and either the start position used is beyond the end of the string or the start offset plus the specified length is greater than the string length.

Generated By:

The interpretative instruction processor.

For Whom:

End User.

Notes:

This can be caused by an error in the second or third argument of SUBSTR. The TvmId and FldId can be from the source or target row.

Remedy:

Fix the DBC/SQL request and resubmit.