Sylver B. wrote:
> --- In sapdb-general@y..., "Zabach, Elke"
> <elke.zabach@s...> wrote:
>
> >
> > So, is there any
> > place where I can lear more about the language used
> to define the
> stored
> > procedures? Books, examples... anything? Any
> sophisticated tool
> like Toad
> > for Oracle?
> > Lopez Janariz (D.Lopez@u...) Web Services Computer
> Center Balearic
> Islands
> > University
> -------------------------------------------
> >
> > As I wrote:
> >
> > Unfortunately there is no book available.
> > Some examples can be found searching the mailing
> list.
> > Sorry, but by now that is all I can give.
>
>
> Hello,
>
> SQL-PL syntax for Adabas is the same as sapdb? Can I
> learn dbproc for
> sapdb from the links below?
>
> 1.
> http://www.softwareag.com/adabasd/documentation/docuen/html/sqlpleng8.
> htm
>
> 2.
> http://www.softwareag.com/adabasd/documentation/docuen/html/sqlpleng9.
> htm
>
> Thx in advance
>
> /ab
SQL-PL syntax of ADABAS and the syntax of SAP DB used for stored procedures
and triggers are not the same.
Please use the parts of the reference manual for a description of SAP DB's language:
for a start use this link:
http://www.sapdb.org/htmhelp/a7/41ee11605911d3a98800a0c9449261/frameset.htm
for create dbproc.
Additionally (not in the docu by now) the feature of returning a cursor was included:
Simple Example :
CREATE DBPROC EXAMPLE
RETURNS CURSOR <----- new
AS
DECLARE :$CURSOR CURSOR FOR SELECT * FROM SYSDBA:DUAL;
The new system variable $CURSOR represents the cursor name, which may be
overwritten
in your stored procedure.
Elke
SAP Labs Berlin
