IIUG Software Repository Files

Subject: TRIGGER AND STORED PROCEDURE HELP NEEDED
From: "Leffler, Jonathan" <jleffler@visa.com>
Date: Thu, 14 May 1998 14:04:47 -0700

Ramki Natesan (rnatesan@bactc.com) asked:

>I have the following trigger stmnt.

>create trigger get_wo_num
>insert on workorder
>after (execute procedure create_wo_for_nt())

Q: Can I do this in isql mode?

JL: Yes.  ISQL can handle any statement which does not have semi-colons in 
the middle of it.  The statements which have such semi-colons are CREATE 
PROCEDURE statements.  For those, you need to use DB-Access.

>then, p1.sql file has the following:-

>CREATE PROCEDURE create_wo_for_nt()
    [...several statements, hence several semi-colons...]
>END PROCUDERE;

>Q:  Can I run this (p1.sql) file in isql mode?

No, because there are semi-colons in the middle of the statement and ISQL 
gets confused.


Use DB-Access.  If that isn't available, go to the server machine where the 
database is and use the copy of DB-Access which is on that.  Or, if you 
have ESQL/C, you can either collect SQLCMD from the IIUG software archives 
at http://www.iiug.org or you can use the program MKPROC in the shell 
archive below which will execute the CREATE PROCEDURE statements from a 
source file (or any other statements which return no data to the caller).

If none of this is feasible, then you need to chat to your System 
Administrator and/or DBA and get DB-Access on your machine.

Yours,
Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h>


:	"@(#): shar.sh,v 1.11 1998/03/16 20:36:16 jleffler Exp $"