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