HPE NonStop SQL/MX Error – 2096 A source file statement has already appeared in this module. The previous source file is being retained and this latest one ignored.

In this blog post, let’s learn about the error message “2096 A source file statement has already appeared in this module. The previous source file is being retained and this latest one ignored.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

2096 A source file statement has already appeared in this module. The previous source file is being retained and this latest one ignored.

Reason for the Error

MXCMP was invoked on a module definition file that contains more than one SOURCE_FILE statement. A module definition can have only one SOURCE_FILE statement that specifies that module’s SQL source file.

Solution

Edit the module definition file so that it contains no more than one SOURCE_FILE statement, and rerun MXCMP on the module definition

Leave A Reply

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

You May Also Like

In this blog post, let’s learn about the error message “1104 Default value string is too long for column column-name.”...
  • December 3, 2024
In this blog post, let’s learn about the error message “3165 The precision or exponent value specified in value was...
  • December 3, 2024
In this blog post, let’s learn about the error message “2051 Either control optionoption name or value ‘value’is not valid.”...
  • December 3, 2024