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 ...
![]() |
| | LinkBack | Thread Tools | Display Modes |
|
#1
| |||
| |||
| 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. |
![]() |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
| |
| ||||
| 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.




Linear Mode
