Messages Reference

Chapter 9. SQJ Messages

This section contains the DB2 Embedded SQLJ in Java (SQLJ) messages. The messages are listed in numeric sequence.

SQJ0001W Customizing profile "<profile-name>".

Cause: This message is written to the standard output device when the precompiler begins processing. The token "<profile-name>" refers to the particular profile being customized.

Processing continues.

Action: No action is required.

SQJ0100E Invalid option specified "<option>".

Cause: The specified option is invalid.

Action: Check the syntax and resubmit the command with the valid option and parameter. The format is -<option>=<parameter>.

SQJ0101E Unknown option "<option>".

Cause: The option is unknown or unsupported.

Action: Execute the command alone without specifying options for usage help. Resubmit the command with a valid option.

SQJ0102E No <option> specified.

Cause: An option is missing.

Action: Resubmit the command specifying the required option.

SQJ0103E No profile specified.

Cause: The profile name is required but missing.

Action: Resubmit the command with the profile name.

SQJ0104E Unable to load profile "<profile>".

Cause: The specified profile cannot be found or does not exist.

Action: Make sure the profile exists or the profile name is correctly specified.

SQJ0105E Unable to customize profile "<profile>".

Cause: The profile cannot be customized due to system or internal error.

Action: Contact IBM service for assistance.

SQJ0106E Invalid syntax "<command-syntax>".

Cause: The syntax of the specified option is invalid.

Action: Resubmit the command with the correct syntax.

SQJ0200E An internal error has occured.

Cause: An unexpected internal error has occurred.

Action: Turn trace on and retry the steps that caused the error. If the problem reoccurs, save the trace information to a file and contact IBM Support with the following information:

Problem description
Message number
Trace file

SQJ0201E An internal error has occurred during profile customization. Reason code "<reason-code>".

Cause: An unexpected internal error has occurred when customizing a profile.

Action: Turn DB2 and CLI trace on and retry the steps that caused the error. If the problem reoccurs, save the trace information to a file and contact IBM Support with the following information:

Problem description
Message number
Reason code
Trace file

SQJ0202E An internal error has occurred during precompilation. Reason code "<reason-code>".

Cause: An unexpected internal error has occurred when precompiling.

Action: Turn trace on and retry the steps that caused the error. If the problem reoccurs, save the trace information to a file and contact IBM Support with the following information:

Problem description
Message number
Reason code
Trace file

SQJ0203E An internal error has occurred when processing the command. Reason code "<reason-code>".

Cause: An unexpected internal error has occurred when processing the command.

Action: Turn trace on and retry the steps that caused the error. If the problem reoccurs, save the trace information to a file and contact IBM Support with the following information:

Problem description
Message number
Reason code
Trace file

SQJ4011E Invalid SQL sub-statement in a Compound SQL statement.

Cause: This error is returned when an invalid sub-statement is detected in a Compound SQL statement. Valid statements are:

ALTER TABLE
COMMENT ON
CREATE INDEX
CREATE TABLE
CREATE VIEW
Searched DELETE
DROP
GRANT
INSERT
LOCK TABLE
REVOKE
SELECT INTO
Searched UPDATE
COMMIT; only when specified as the last sub-statement.

Action: Resubmit the command without the invalid sub-statement.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]