QSYS type *LIB not found

[lee.swanson]

Hi,

I am trying to run a create procedure statement and I am getting the
following error with a create table statement within the procedure
highlighted:

[SQL0204] [my user name] in QSYS type *LIB not found. Cause . . . . . :
SWANSONL in QSYS type *LIB was not found. If this is an ALTER TABLE
statement and the type is *N, a constraint was not found. If this is
not an ALTER TABLE statement and the type is *N, a function, procedure,
or trigger was not found. Recovery . . . : Change the name and try
the request again. If the object is a node group, ensure that the DB2
Multisystem product is installed on your system and create a nodegroup
with the CRTNODGRP CL command.

I created a cut-down version of the stored procedure that also throws
the error:

CREATE PROCEDURE [library].Lee_Test (
OUT SUCCESS INTEGER )
LANGUAGE SQL
SPECIFIC [library].Lee_Test
NOT DETERMINISTIC
MODIFIES SQL DATA
CALLED ON NULL INPUT
BEGIN
CREATE TABLE TMP_Lee ( ORDERNO INT , ORDERTYPE CHAR ( 2 ) , COMPANYNO
CHAR ( 5 ) , LINENO INT ) ;
DROP TABLE TMP_Lee;
END;

It appears to be trying to use my username as the library name when
creating the table. I can fix it by explicitly entering the library in
the create table statement, but I would rather not create a dependency
on the current library that I have to change when I migrate.

The stored procedure is currently running fine in another library and I
am just trying to copy it to a new one.

Any help would be appreciated.

Thanks