SQLCODE -449 - www.cadcobol.com.br

SQLCode -449

Causa

CREATE OR ALTER STATEMENT FOR FUNCTION OR PROCEDURE routine-name CONTAINS AN INVALID FORMAT OF THE EXTERNAL NAME CLAUSE OR IS MISSING THE EXTERNAL NAME CLAUSE

An error was found in the EXTERNAL NAME clause of the CREATE FUNCTION, CREATE PROCEDURE, ALTER FUNCTION, or ALTER PROCEDURE statement for routine-name, or the clause is needed but was not specified.
- For a LANGUAGE JAVA or COMPJAVA stored procedure, or LANGUAGE JAVA user-defined function, the name must be specified and it must contain a valid external-java-routine-name of the following form:
```
jar-name:package-id...class-id.method-id(method-signature)
```
  - Do not include blanks.
  - For LANGUAGE COMPJAVA, do not specify a jar-name.
  - The method-name consists of the list of package-ids, class-id, and method-id, and must not be longer than 254 bytes.
  - For LANGUAGE JAVA, zero or more package-ids may be specified preceding the class-id
  - For LANGUAGE COMPJAVA,
  - The method-signature is optional, and is a list of Java data types that are separated by commas.
    If specified, the method-signature must not be longer than 1024 bytes.
  - If multiple strings are specified, the total length of all the strings concatenated together for the external-java-routine-name must not be greater than 1305.
- For external routines with a language other than JAVA or COMPJAVA, the external name must be a short identifier with letters or digits.
  The first character must be a letter. (This is the MVS naming convention for load modules).
  A possible cause for this error is the inclusion of a blank in the name.
  If the clause is omitted, the external name defaults to function-name.
  However, for CREATE FUNCTION or CREATE PROCEDURE if the function or procedure name is longer than eight characters then the EXTERNAL NAME clause must be explicitly specified to specify a valid short identifier as the external name.

Ação do sistema

The statement cannot be executed.

Resposta ao Desenvolvedor

Correct the syntax of the SQL statement. Refer to the DB2 SQL Reference for information on the EXTERNAL NAME clause.
When LANGUAGE is JAVA or COMPJAVA, possible causes include:
- Omitting hte EXTERNAL NAME clause.
- Including a blank.
- Having the '!' at the beginning or end of the name.
- Specifying an invalid external-java-routine-name.
SQLSTATE: 42878