Search results for query: *

Hi, I used db2look to generate a DDL file but for procedure give me this type CREATE PROCEDURE "x "."ffddffd" ( IN V_PCHARGEID INTEGER ) DYNAMIC RESULT SETS 1 SPECIFIC SQL050222142447354 EXTERNAL NAME 'db2pvm!pvm_entry' LANGUAGE SQL PARAMETER STYLE GNRLNULL...

Hi, I have a strange problem with IDENTITY_VAL_LOCAL().I am using DB2 UDB Express 8.2 on Windows 2003. Sometimes when I want to insert a values in a table give me the error 'You are attempting to add an entry that already exists. ' - seem that IDENTITY is not incremented by 1. Which can be the...

I resolved the problem, thank you. I had to modify a configuration parameter.

I have a cursor with 2 CASE clause . Every CASE clause has 80 WHEN codndition and every time a ran this procedure I am disconnected from the server. If I let only one CLAUSE it is ok but with both no. Any help? Thanks

Hi, How many WHEN condition can you have in a CASE clause in DB2? Thankns

Which are the values for these parameters if I have 2 GB memory and 3 GHz CPU? Sometimes when I ran big stored procedure I am disconnected from the DB2 SERVER. Thanks

Hi, From Memory Visualizer I saw that Lock Manager Heap is high up to 100%. Which parameters I have to configure? Thanks.

I have a server with CPU 3 GHz, 2 GB memory On this server I have installed DB2 UDB 8.2 – usually I ran stored procedures bigger than 64 K. Which configuration parameters I have to modify on my database to be able to run these stored procedures – very often I am disconnected from the server and...

I can't even look in db2diag.log , the file had over 40 MB and I can't open it. I use DB2 v8.2 on Windows 2003. What can I do ?

Hi, When I am doing an import or when I want to execute a complex procedure DB2 server is shut down. Which can be the cause? Thanks.

Hi, I have this procedure CREATE PROCEDURE t ( IN PUSERID INTEGER, IN PDATE TIMESTAMP, , OUT PSQLCODE INTEGER) RESULT SETS 0 LANGUAGE SQL BEGIN NOT ATOMIC DECLARE SQLCODE INT; DECLARE CONTINUE HANDLER FOR NOT FOUND SET AT_END = 1; DECLARE EXIT HANDLER FOR SQLEXCEPTION SET PSQLCODE = SQLCODE...

Hi, I create a function and I want for NO FOUND (no data found) or for too many rows to have some exceptions messages. If ASS is null to have an exception message if ASS return more than one row to have an exception message. How can I do this? My function is : CREATE FUNCTION test ( pid FLOAT )...

...integer,EmpName varchar(30)) WITH REPLACE ON COMMIT PRESERVE ROWS NOT LOGGED; DECLARE temp_cursor CURSOR WITH HOLD WITH RETURN TO CLIENT FOR select * from SESSION.tmpaccref; INSERT INTO session.tmpaccref( SELECT a,b FROM x_table); updatex_table set a='222' when a is null; open temp_curosr; end

How to use CASE here?

Hi, I want to create a procedures with over 1200 lines but I get this error Communication link failure. SQLSTATE 40003. In the procedure I have a cursor with a CASE expression with over 180 WHEN conditions. If I try to create this procedure step by step - first to create with only 10 WHEN...

Hi, How ca I do this in DB2 ? SELECT ISNULL(A & B, 0) THANKS

Hi, I have in a procedure create procedure x .... DECLARE temp_cursor CURSOR WITH HOLD WITH RETURN TO CLIENT FOR SELECT v_UNIQUEID FROM SYSIBM.SYSDUMMY1; insert into y select from .......; values IDENTITY_VAL_LOCAL() INTO v_UNIQUEID; (IDENTITY_VAL_LOCAL() is the identity from y...

Hi, How I can create an user in DB2 and grant EXECUTE privilege on all the packages for this user? Thanks

Hi, Which is the command in DB2 to give EXECUTE privileges for a user? ( I want to use a single command for all the packages, procedures, functions). I don't want to use this: GRANT EXECUTE ON PACKAGE x.P0002089 TO USER X; Thanks.

Hi, Please help me with these questions: 1. Which are equivalents views in DB2 for ALL_USER and ALL_TAB_PRIVS from Oracle? 2. Can I used EXECUTE IMMEDIATE in DB2 to create dynamic, in a procedure, a user and then to grant privileges to this user? P.S I am new in DB2 so I appreciate your help...