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
