Alix Jermyn wrote: > Can anyone point me to some documentation on the language/scripting that can be done >within a dbproc? > > I am familar with Transact SQL within stored procs, but new to SAP DB's variant, and >can't find any > documentation apart from an odd snippet here and there in the mailing archives. > > For example, what values does $rc return, and under what conditions
The language used in dbprocs/triggers is described in the reference manual --> data definition --> create dbproc resp. create trigger and further on the possible $rc-values -9799 .. -900 -699 .. 0 .. +750 can be found in the doc named Messages. Usually (no syntax error, privilege, datatype-error and something like this) only positive values (duplicate primary key, timeout) and so on can be found. But during development of a dbproc we have seen so many different errors so far, that it is impossible to say, these errors will be found and those will not. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
