Database crash with select command !?????????????

[Beermann, Albert]

Hello Everybody

 

I want to extract material data  from a structured table(instueckliste)
with an recursive query!

(all material needed for l_startstl)

My application connects via odbc

 

l_cmd = "DECLARE RNAME CURSOR FOR WITH RECURSIVE TMPOBJ " +;

        "(LEVEL,stlnr,stlbezeich,posnr,matnr,matbezeich,menge,me,ekz)  "
+;

        " AS (SELECT 1, instueckliste.instlnr as
stlnr,stlbeze.inbezeich_d as stlbezeich," +;

        "instueckliste.instlposnr as posnr," +;

        "instueckliste.inmatnr as matnr,matbeze.inbezeich_d as
matbezeich," +;

        "instueckliste.instlmenge as menge," +;

        "matbeze.inmatme as me,instueckliste.inekz as ekz " +;

        " from instueckliste " +;

        " join inmaterialstamm stlbeze on instueckliste.instlnr =
stlbeze.inmatnr " +;

        " join inmaterialstamm matbeze on instueckliste.inmatnr =
matbeze.inmatnr " +;

        " where instueckliste.instlnr = ?l_startstl " +; 

        " UNION ALL SELECT TMPOBJ.LEVEL + 1, instueckliste.instlnr as
stlnr,stlbeze.inbezeich_d as stlbezeich," +;

        " instueckliste.instlposnr as posnr," +;

        " instueckliste.inmatnr as matnr,matbeze.inbezeich_d as
matbezeich,"+;

        " instueckliste.instlmenge * tmpobj.menge as menge," +;

        " matbeze.inmatme as me,instueckliste.inekz as ekz " +;

        " from tmpobj,instueckliste " +;

        " join inmaterialstamm stlbeze on instueckliste.instlnr =
stlbeze.inmatnr " +;

        " join inmaterialstamm matbeze on instueckliste.inmatnr =
matbeze.inmatnr " +;

        " where instueckliste.instlnr = tmpobj.matnr) " +;

        " SELECT tmpobj.* FROM TMPOBJ " +;

        " order by level,stlnr,posnr"

 

=sqlexec(connnr,l_cmd,"ERGEBNIS")

 

Everything OK!

I get the wanted result in 1 second.

 

 

Now i tried to extract the same data for building l_startstl twice

l_startmenge = 2

l_cmd = "DECLARE RNAME CURSOR FOR WITH RECURSIVE TMPOBJ " +;

 
"(LEVEL,stlnr,stlbezeich,posnr,matnr,matbezeich,menge,me,ekz)  " +;

            " AS (SELECT 1, instueckliste.instlnr as
stlnr,stlbeze.inbezeich_d as stlbezeich,instueckliste.instlposnr as
posnr," +;

            "instueckliste.inmatnr as matnr,matbeze.inbezeich_d as
matbezeich," +;

            "instueckliste.instlmenge * ?l_startmenge as menge," +;

            "matbeze.inmatme as me,instueckliste.inekz as ekz " +;

            " from instueckliste " +;

            " join inmaterialstamm stlbeze on instueckliste.instlnr =
stlbeze.inmatnr " +;

            " join inmaterialstamm matbeze on instueckliste.inmatnr =
matbeze.inmatnr " +;

            " where instueckliste.instlnr = ?l_startstl " +; 

            " UNION ALL SELECT TMPOBJ.LEVEL + 1, instueckliste.instlnr
as stlnr,stlbeze.inbezeich_d as stlbezeich,instueckliste.instlposnr as
posnr," +;

            " instueckliste.inmatnr as matnr,matbeze.inbezeich_d as
matbezeich,"+;

            "instueckliste.instlmenge * tmpobj.menge as menge," +;

            " matbeze.inmatme as me,instueckliste.inekz as ekz " +;

            " from tmpobj,instueckliste " +;

            " join inmaterialstamm stlbeze on instueckliste.instlnr =
stlbeze.inmatnr " +;

            " join inmaterialstamm matbeze on instueckliste.inmatnr =
matbeze.inmatnr " +;

            " where instueckliste.instlnr = tmpobj.matnr) " +;

            " SELECT tmpobj.* FROM TMPOBJ " +;

            " order by level,stlnr,posnr"

            

 =sqlexec(connnr,l_cmd,"ERGEBNIS")

 

 DATABASE CRASH !!!!!!!!!

 1526

Connectivity-Fehler: [SAP AG][SQLOD32 DLL][MaxDB] General error;800
Implicit SERVERDB restart (connection aborted)

[SAP AG][SQLOD32 DLL][MaxDB] General error;800 Implicit SERVERDB restart
(connection aborted)

S1000

800

1

 

A) Database crash with select command ??????????????????????????

b) How to extract all material that is needed to build l_startstl n
times ???????????????

 

Any help welcomed

Best regards

Albert