SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-26-2008, 04:21 PM
| ||||
| ||||
 Creating a SP using the control manager Hi there, we are trying to create a stored procedure into a db2 v8 using ther control manager. We are connected to our base wich name is DB_AGRO We typed in the text in the command field as this : CREATE PROCEDURE SYSPROC.SP_COMPTEUR (IN lib VARCHAR(16), OUT val INTEGER) SPECIFIC SP_COMPTEUR LANGUAGE SQL BEGIN IF lib IS NULL THEN SIGNAL lib_is_null SET MESSAGE_TEXT = 'Valeur NULL passée en argument' END IF RETURN -1 END We tryed many syntaxes; Sometimes it fail with a error message saying that an unexpected end of command (SQL0104) and sometimes it accept it without saying anything except command entered. But never the SP appear in the database ! Something is missing I suppose. The question is HOW do we create a simple SP and in wich window, field or command ligne of wich tool ??? Thanks in advance !      |
Linear Mode
