when I try to build a stored procedure I get the error listed below. Can someone help me?

Stored Procedure

CREATE PROCEDURE CIDADM.Proc1 ( )
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
declare tn varchar (40);
SELECT
CIDADM.LOAD_STATISTICS.LDST_TABLE_NAME into tn
FROM
CIDADM.LOAD_STATISTICS;
END P1


ERROR



CIDADM.PROC1 - Create stored procedure returns -14847.

CIDADM.PROC1: 1: [IBM][CLI Driver][DB2/NT] SQL0969N There is no message text corresponding to SQL error "-14847" in the message file on this workstation. The error was returned from module "SQLN 0AF" with original tokens "failed to get tmp path". LINE NUMBER=1.



CIDADM.PROC1 - Build failed.

CIDADM.PROC1 - Changes rolled back.