dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

starting problem with stored procedure in ibm db2 - db2-udb

This is a discussion on starting problem with stored procedure in ibm db2 - db2-udb ; I am a newbie of ibm db2 user. My code snippet goes as below: CREATE PROCEDURE DBINST1.GET_WORKING_DAYS (IN EMPNUM DECIMAL, IN SALMONTH DECIMAL) LANGUAGE SQL BEGIN DECLARE STARTDATE DECIMAL(9,2); SELECT MIN(ATTENDANCEDATE) INTO STARTDATE FROM ATTENDANCETTABLE WHERE EMPNO = EMPNUM AND ...


Home > Database Forum > Other Databases > db2-udb > starting problem with stored procedure in ibm db2

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 08-18-2009, 06:58 AM
Database Newbie
 
Join Date: Aug 2009
Posts: 1
sushmidb2 is on a distinguished road
Default starting problem with stored procedure in ibm db2

I am a newbie of ibm db2 user.

My code snippet goes as below:

CREATE PROCEDURE DBINST1.GET_WORKING_DAYS
(IN EMPNUM DECIMAL, IN SALMONTH DECIMAL)
LANGUAGE SQL
BEGIN

DECLARE STARTDATE DECIMAL(9,2);

SELECT MIN(ATTENDANCEDATE) INTO STARTDATE FROM ATTENDANCETTABLE
WHERE EMPNO = EMPNUM AND SALARYMONTH = SALMONTH;

END

This code snippet is not working.
Please help me out.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Stored procedure problem with variable limit Database Administrator mysql 7 03-14-2008 08:12 AM
Problem with LIKE in stored procedure Database Administrator sqlserver-server 4 03-13-2008 11:23 AM
Stored Procedure Security Problem Database Administrator ms-sqlserver 5 11-02-2007 12:07 PM
Stored procedure compilation problem Database Administrator Oracle Server 0 06-29-2004 04:39 PM
Problem with DBMS_JOB within a stored procedure Database Administrator Oracle Server 2 07-08-2003 11:40 AM


All times are GMT -4. The time now is 03:25 AM.