Teradata SQL Error and Failure Codes from Error 3789 To 3800

3789 Multiple ’%VSTR’ options.
Explanation: The user specified multiple data description option.
Generated By: SYN modules.
For Whom: End User.
Remedy: Remove additional one and resubmit the request.

3790 GRANT/REVOKE LOGON not allowed TO DBC.
Explanation: A GRANT LOGON or REVOKE LOGON statement has listed user DBC. This is not permitted.
Generated By: OPT modules.
For Whom: End User.
Remedy: Correct the error and resubmit the request.

3791 A view in an Update or Delete statement can not have a joined table in its definition.
Explanation: A view referenced in an Update or Delete statement can not have a joined table in its definition.
Generated By: RES module
For Whom: End User
Remedy: Correct search condition and resubmit the request.

3792 Conflicting CASESPECIFIC options.
Explanation: The user specified both CASESPECIFIC (CS) and NOT CASESPECIFIC (NOT CS).
Generated By: SYN modules.
For Whom: End User.
Remedy: Specify only one option.

3793 Conflicting NULL options.
Explanation: The user specified both NULL and NOT NULL options.
Generated By: SYN modules.
For Whom: End User.
Remedy: Specify only one option.

3794 The argument type for the HASHBUCKET function is invalid.
Explanation: The user specified an invalid type of argument for the HASBUCKET function. If specified the argument
must be a BYTE(4) data type.
Generated By: OPT modules.
For Whom: End user.
Remedy: Correct the argument type.

3795 Internal error: Unimplemented type option specified.
Explanation: An internal error, the parser code necessary to process this type is missing.
Generated By: SYN modules.
For Whom: System Support Representative.
Remedy: Save all relevant information and notify your support representative.

3796 The user must specify a value for PERMANENT space.
Explanation: The CREATE USER or DATABASE statement did not specify PERMANENT space.
Generated By: SYN modules.
For Whom: End User.
Notes: Use PERMANENT = 0 if you do not want to give space to a user.
Remedy: Add the PERMANENT clause and resubmit the request.

3797 A PASSWORD must be specified when creating a user.
Explanation: In the CREATE USER statement, the user did not specify a password.
Generated By: SYN modules.
For Whom: End User.
Remedy: Add the PASSWORD clause and resubmit the request.

3798 A column or character expression is larger than the max size.
Explanation: The maximum size limit for a character expression or column of LATIN, KANJI1, UNICODE or GRAPHIC
character type is 64000 bytes. It is 32000 bytes for KANJISJIS character type.
The maximum size limit for a column or expression of type BYTE or VARBYTE is 64000 bytes. If it is returned in the fieldmode
the limit is 32000 bytes representation because its representation takes two characters to represent a byte.
Generated By: SYN and OPT modules.
For Whom: End User.
Remedy: Reduce the size of the column.

3799 A RunUnit or Coordinator ID is larger than the max size.
Explanation: A RunUnit or Coordinator ID can be no longer than 30 characters.
Generated By: ParDrivr.
For Whom: End User.
Remedy: Reduce the size of the RunUnit or Coordinator ID.

3800 Datatype Mismatch in THEN/ELSE expression.
Explanation: The dataset of THEN/ELSE expressions contain a datatype that is incompatible with other datatypes in the
set. Example: SEL CASE WHEN 1=1 THEN ByteCol ELSE IntCol END;
Generated By: OPTWEXP
For Whom: The end user.
Remedy: Correct and re-submit SQL query.

Above are list of Teradata Errors or Failure Codes from Error 3789 To 3800 received while performing certain operation against Teradata Database or related products.

What are Teradata Database Errors?

In general, each Teradata error message contains the following information:
• The message number.
• The message text. This text is usually returned with the message number. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.
• Generated-by text that indicates the software module which initiated the message. This field serves a diagnostic purpose for support and development personnel.
• A remedy which suggests how to resolve the condition.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Teradata SQL Error and Failure Codes and Error Messages on Windows, Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *