logo  
Google
 

DB2 SQL-Error: -449

SQLState: 42878

Short Description: CREATE OR ALTER STATEMENT FOR FUNCTION OR PROCEDURE 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. v For external routines with LANGUAGE JAVA, 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) – No blanks are permitted within the single quotes. – The method-name consists of the list of package-ids, class-id, and method-id, and must not be longer than 254 bytes. – Zero or more package-ids can be specified, preceding the class-id. – 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.v For external routines with a language other than JAVA, 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.System action: The statement cannot be executed. Programmer response: Correct the syntax of the SQL statement. Refer to the DB2 SQL Reference for information on the EXTERNAL NAME clause. User response: When LANGUAGE is JAVA, possible causes include: v Omitting the EXTERNAL NAME clause. v Including a blank. v Having the '!' at the beginning or end of the name. v Specifying an invalid external-java-routine-name.

 <-  BACK TO INDEX