It is in the sql reference somewhere.
You can call a database proceudure, or define the functionality in the trigger definition.
Laszlo
ps: you run sapdb on freebsd?
Fernando Alberto Velasquez wrote:
Hi Thomas
The db-procedures can be included or execute from a trigger ?
Tanks
+------------------------------------------------------------------------+
| UNIX is user friendy, but it knows to , , |
| choose very well to his friends. /( )` Peace, Love |
| \ \___ / | and |
| Fernando A. Velasquez /- _ `-/ ' Opensource |
| Administrador de Red (/\/ \ \ /\ |
| [EMAIL PROTECTED] / / | ` \ |
| Tel ++57 2 665 2107 O O ) / | |
| Fax ++57 2 665 2107 `-^--'`< ' |
| Cali, Valle (_.) _ ) / |
| Colombia, Sudamerica `.___/` / |
| For PGP/GPG Public Key E-Mail Me `-----' / |
| <----. __ / __ \ |
| <----|====O)))==) \) /==== |
| +----------------------+ <----' `--' `.__,' \ |
| | Jesus Save, | | | |
| | but only Buda made | \ / |
| | incremental Backups. | ______( (_ / \______ |
| +----------------------+ ,' ,-----' | \ |
| `--{__________) \/ |
| If this message dont have a |
| PGP/GPG signature, dont trust! Powered by FreeBSD |
+------------------------------------------------------------------------+
CREATE DBPROC lafuncion(out result int) AS
VAR
idnum INTEGER;
begin
select max(id) into :idnum from dba.latabla;
if idnum is null
then
result = 1
else
if idnum >= 1
then
result = idnum + 1;
end;
Please note that this creates a db-procedure, not a db-function, i.e.
you cannot use this db-procedure in any sql statement except the
call statement.
db-functions aren't supported by SAPDB yet.
Regards,
Thomas
--
Thomas Anhaus
SAP DB, SAP Labs Berlin
[EMAIL PROTECTED]
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
.
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
