RE: DBPROC issue

[Daniel Dittmar]

It is not possible to write a DBProc which returns a result set. You can
simulate this by:

in the DBProc:
    create table TEMP.somename as select * from .....

after the call to the dbproc:
    select * from TEMP.somename

Tables created as TEMP. are temporary for the session. They are implicitly
deleted after the session has been released. That's why you would have to
put the call to the DBProc and the SELECT into one 'dbmcli' call.

Daniel Dittmar

--
Daniel Dittmar
daniel.dittmar@stripped
SAP DB, SAP Labs Berlin