Helpful Information
 
 
Category: DB2 Development
getting SQL0035N while creating procedures in DB2

Hi,
I have db2 v8.1.2 over linux.
I have opened the development centre and i have tried to create a stored procedure.

It has thrown error saying
[IBM][CLIDRIVER][DB2/LINUX] SQL0035N.
The file P2494298.msg cannot be opened.

I do not know how to overcome this error and where to locate this file.

Can anyone give me the path and the solution to overcome this error so that i can start creating the stored procedures and migration without problems.

Thanks in advance

Ksr

I am having the same problem....

SQL0035N The file "<name>" cannot be opened.
Explanation: The message file "<name>" could not be opened.
Binding or precompilation has been terminated.
User Response: Ensure that the system can access the file.

I am on a windows environment, i've given my user admin rights to everything so far as i know. I know my C compiler is fine because it creates stored procedures fine with other databases. It's not the code because I keep changing it and getting the same errors here's my most recent, simplest code it is erroring on.

CREATE PROCEDURE CHECK()
LANGUAGE SQL
BEGIN
DECLARE test DECIMAL(3,2);
END@

Any help would be extremely apprciated.
Thanks in advance
-Brian

Hi brain,

I was getting the same error in linux,there are some permissions to be set to the tmp folder which exists under the sqllib directory,u have to go down some tree strucure to reach this folder,generally you will see this path when u try to build the stored procedure..

Just move to that folder and give the read,write permissions.
It should work.

If it is windows,check the compiler path settings with your db2 settigns using db2set -all .



Sri










privacy (GDPR)