15.00 - Stored Procedure Compilation (SPL Prefix) Messages - Teradata Database

Product: Teradata Database
Release Number: 15.00
Language: English (United States)
Last Update: 2018-09-24

Stored Procedure Compilation (SPL Prefix) Messages
SPL0001: "%s: Internal error. Unable to open file %s ."
SPL0002: "%s: Internal error. Unable to initialize."
SPL1001: "%s:E(L%d), Unexpected text %s in place of parameter."
SPL1002: "%s:E(L%d), Unexpected text %s in place of local variable."
SPL1003: "%s:E(L%d), Unexpected text %s in place of statement."
SPL1004: "%s:E(L%d), Unexpected text %s in place of statement in EH."
SPL1005: "%s:E(L%d), Expecting label name instead of %s ."
SPL1007: "%s:E(L%d), Expecting cursor SQL SELECT statement instead of %s ."
SPL1008: "%s:E(L%d), Unexpected text %s in PRINT statement."
SPL1009: "%s:E(L%d), Invalid/missing data type instead of %s ."
SPL1010: "%s:E(L%d), Unexpected text %s in place of data type size attribute."
SPL1011: "%s:E(L%d), Length of identifier %s exceeded %d characters."
SPL1012: "%s:E(L%d), Invalid or missing attribute for data type %s ."
SPL1013: "%s:E(L%d), Unexpected text %s in place of parameter type or name."
SPL1015: "%s:E(L%d), Invalid/missing comma between parameter declarations."
SPL1016: "%s:E(L%d), Invalid/missing default value %s ."
SPL1017: "%s:E(L%d), Unexpected text %s in place of keyword HANDLER."
SPL1018: "%s:E(L%d), Unexpected text %s in place of keyword BEGIN."
SPL1019: "%s:E(L%d), Unexpected text %s in place of keyword FOR in the FOR cursor statement."
SPL1020: "%s:E(L%d), Invalid or missing SQLSTATE value %s ."
SPL1021: "%s:E(L%d), Expecting colon instead of %s ."
SPL1022: "%s:E(L%d), Unexpected text %s in place of END LABEL.
SPL1023: "%s:E(L%d), Expecting FOR/WHILE/LOOP statement instead of %s ."
SPL1024: "%s:E(L%d), Unexpected text %s in place of DO."
SPL1025: "%s:E(L%d), Unexpected text %s in FOR cursor statement."
SPL1026: "%s:E(L%d), Invalid/missing expression: %s"
SPL1027: "%s:E(L%d), Invalid/missing SQL statement: %s"
SPL1028: "%s:E(L%d), Illegal attempt to modify symbol %s ."
SPL1029: "%s:E(L%d), Unexpected text %s ."
SPL1030: "%s:E(L%d), Referencing an undefined cursor %s ."
SPL1031: "%s:E(L%d), Referencing an undefined alias %s ."
SPL1032: "%s:E(L%d), Expecting keyword PROCEDURE instead of %s ."
SPL1033: "%s:E(L%d), Unexpected text %s ."
SPL1034: "%s:E(L%d), Unexpected text or Teradata Database reserved word %s ."
SPL1035: "%s:E(L%d), Referencing an undefined label or illegal usage of label.
SPL1036: "%s:E(L%d), Expecting end label %s instead of %s ."
SPL1037: "%s:E(L%d), Missing INTO clause in SQL SELECT statement."
SPL1038: "%s:E(L%d), SQL SELECT returns %d columns, but INTO clause has %d target variables."
SPL1040: "%s:E(L%d), Invalid/missing stored procedure definition: %s"
SPL1041: "%s:E(L%d), Missing close comment delimiter */ ."
SPL1042: "%s:E(L%d), Invalid/missing stored procedure name."
SPL1043: "%s:E(L%d), Expecting keyword END instead of %s ."
SPL1044: "%s:E(L%d), Integral value specified with data type must be between %d and %d ."
SPL1045: "%s:E(L%d), Invalid/missing INTO clause."
SPL1046: "%s:E(L%d), Nesting level of FOR cursor statements exceeded the limit of %d ."
SPL1048: "%s:E(L%d), Encountered %s when expecting an SPL statement."
SPL1051: "%s:E(L%d), Invalid/missing keyword FOR in condition handler."
SPL1052: "%s:E(L%d), Duplicate SQLSTATE code %d ."
SPL1053: "%s:E(L%d), Missing = sign in SET statement."
SPL1054: "%s:E(L%d), Duplicate condition name %s ."
SPL1055: "SPL1055", "%s:E(L%d), Unexpected text %s in place of column list/expressions in SELECT-INTO statement."
SPL1057: "%s:E(L%d), Error in parameter list."
SPL1058: "%s:E(L%d), No loop context for ITERATE statement with label %s ."
SPL1059: "%s:E(L%d), Unexpected text %s in place of semicolon."
SPL1060: "%s:E(L%d), Unexpected text %s in place of END IF / END FOR / END WHILE / END LOOP."
SPL1061: "%s:E(L%d), Invalid data type %s ."
SPL1062: "%s:E(L%d), Unexpected text %s in place of keyword CONTINUE/EXIT in condition handler."
SPL1063: "%s:E(L%d), Unexpected text %s in place of keyword CURSOR."
SPL1064: "%s:E(L%d), Unexpected text %s in place of AS."
SPL1065: "%s:E(L%d), Unexpected text %s in place of keyword SQLSTATE."
SPL1066: "%s:E(L%d), Transaction control statements BT, ET are not allowed in ANSI mode."
SPL1067: "%s:E(L%d), Transaction control statement COMMIT is not allowed in Teradata mode."
SPL1068: "%s:E(L%d), Error in parameter list or missing parenthesis."
SPL1069: "%s:E(L%d), LOCKING modifier cannot be used with SQL CALL statement."
SPL1070: "%s:E(L%d), Invalid usage of LOCKING modifier."
SPL1071: "%s:E(L%d), Unexpected text CREATE/REPLACE keyword, Ignoring the text."
SPL1072: "%s:E(L%d), Expecting the END LABEL %s ."
SPL1073: "%s:E(L%d), The transaction control statements are not allowed inside updatable FOR cursor statement."
SPL1074: "%s:E(L%d), LEAVE statement referencing an invalid label %s ."
SPL1075: "%s:E(L%d), The left parenthesis in parameter declaration is missing."
SPL1076: "%s:E(L%d), The right parenthesis in parameter declaration is missing."},
SPL1077: "%s:E(L%d), Request larger than the maximum permissible size."
SPL1078: "%s:E(L%d), User is not authorized to use the DDL/DCL/Dynamic SQL statement."
SPL1079: "%s:E(L%d):S(%d), Missing/Invalid SQL statement %s .
SPL1080: "%s:E(L%d), Condition name %s is already defined."
SPL1081: "%s:E(L%d), SQLSTATE value %s is already defined."
SPL1082: "%s:E(L%d), Condition name %s is not defined.
SPL1083: "%s:E(L%d), RESIGNAL statement specified outside a handler declaration."
SPL1084: "%s:E(L%d), Unexpected text %s in place of condition name."
SPL1101: "%s:E(L%d), Expecting local variables or INOUT/OUT parameters in INTO clause."
SPL1102: "%s:E(L%d), Length of single quoted string exceeding %d ."
SPL1104: "%s:E(L%d), Unexpected text on LHS of SET statement."
SPL1105: "%s:E(L%d), Cursor with name %s is not updatable."
SPL1106: "%s:E(L%d), Unexpected text %s in place of FOR-loop identifier or FOR-loop condition."
SPL1107: "%s:E(L%d), Unexpected token END_OF_FILE ."
SPL1109: "%s:E(L%d), Expecting local variable instead of %s in SQL CALL statement."
SPL1110: "%s:E(L%d), Invalid SQL DELETE statement."
SPL1111: "%s:E(L%d), Symbol name %s must not begin with a# ."
SPL1112: "%s:E(L%d), Missing SET keyword."
SPL1114: "%s:E(L%d), Invalid CHARACTER SET type %s ."
SPL1115: "%s:E(L%d), Unexpected text CHARACTER SET in DECLARE statement."
SPL1117: "%s: Undo declare handler not allowed in NON ATOMIC BLOCK."
SPL1118: "%s:E(L%d), Transaction control statements not allowed in ATOMIC block."
SPL1119: "%s:E(L%d), Generic exception condition handler already defined."
SPL1120: "%s:E(L%d), Updatable cursor is not allowed in Teradata mode."
SPL1121: "%s:E(L%d), Invalid DELETE statement; not supported in SPL."
SPL1122: "%s:E(L%d), %s contains translation error."
SPL1126: "%s:E(L%d), Illegal attempt to modify %s field in diagnostics area."
SPL1127: "%s:E(L%d), Illegal attempt to modify %s more than once in SIGNAL or RESIGNAL statement."
SPL1128: "%s:E(L%d), Data type of %s is not compatible with statement or condition information item."
SPL1129: "%s:E(L%d), Unexpected text %s in place of statement or condition information item name."
SPL1130: "%s:E(L%d), Invalid data for condition number."
SPL1132: "%s:E(L%d), %s cursor is not specified as scrollable."
SPL1134: "%s:E(L%d), Invalid data for CLASS_ORIGIN or SUBCLASS_ORIGIN."
SPL1135: "%s:E(L%d), Invalid fetch orientation specified in the Fetch statement."
SPL1136: "%s:E(L%d), WITH...BY clause cannot be specified in cursor select statement."
SPL1137: "%s:E(L%d), Undefined label %s ."
SPL1138: "%s:E(L%d), Blank name in place of an identifier."
SPL1139: "%s:E(L%d), INTO list not allowed in a CURSOR SELECT statement."
SPL1140: "%s:E(L%d), NULL list not allowed in a Dynamic SQL statement."
SPL1141: "%s:E(L%d), %s is not allowed in a multi-statement request."
SPL1142: "%s:E(L%d), Dynamic SQL statement must be the only statement in a multi-statement request."
SPL1142: "%s:E(L%d), Unexpected text %s in place of Keyword READ."
SPL1143: "%s:E(L%d), Unexpected text %s in place of Keyword PRINT."
SPL1144: "%s:E(L%d), Unexpected SPLkeyword %s ."
SPL2001: "%s:E(L%d), Undefined symbol %s ."
SPL2006: "%s:E(L%d), Multiple definitions of %s ."
SPL2007: "%s:E(%d), Unknown statement type."
SPL2008", "%s:E(%d), Invalid cursor name or extra text after cursor name."
SPL2009", "%s:E(L%d), INTO list not allowed in the SQL statement."
SPL2010: "%s:E(L%d), Variable of CHARACTER type expected in PREPARE statement."
SPL3001: "%s: Internal error. Not able to perform file i/o for file %s ."
SPL3002: "%s: Internal error. Not able to allocate memory for %s ."
SPL4002: "%s: Stored procedure creation error %s ."
SPL4003: "%s: Internal error."
SPL5000: "%s:W(L%d), %s"
SPL5001: "%s:W(L%d), %s"
SPL5002: "%s:W(L%d):S(%d), %s"
SPL5004: "%s:E(L%d), Referring to undefined statement %s ."
SPL5005: "%s:E(L%d), FETCH not allowed for a WITH RETURN ONLY cursor %s ."
SPL5006: "%s:E(L%d), Dynamic cursor %s can t be an updatable cursor."
SPL5008: "%s:E(L%d), The number of dynamic result sets must be between 0 and 15."
SPL5009: "%s:E(L%d), Dynamic cursor %s is not allowed with WITHOUT RETURN, WITH RETURN TO CALLER/CLIENT."
SPL5010: "%s:E(L%d), Using is not allowed in cursor %s ."
SPL5011: "%s:E(L%d), WITH RETURN option is not supported in this release."
SPL5012: "%s:W(L%d), %s"
SPL5013: "%s:W(L%d), Identifier (%s) reference is ambiguous and will be treated as local variable during execution."
SPL5014: "%s:W(L%d), There is no handler defined for SQLSTATE/condition name(%s) in SIGNAL/RESIGNAL statement."

Back to home page