topic Re: PACKAGE SIZE SELECT LOOP with incorporated function call? in Application Development and Automation Discussions

PACKAGE SIZE SELECT LOOP with incorporated function call?

jensbilgrav — Wed, 30 Jul 2008 06:39:35 GMT

Hi,

I am trying to minimize the amount of memory used by a report.

One of the ways of doing this is to use the PACKAGE SIZE addition to the SELECT statement.

However, as the data extracted needs to be either stored on the application server or downloaded to a PC, I also want to create the file using the option to APPEND the data extracted for each package a little at a time.

Here comes the problem: If I try to call function module GUI_DOWNLOAD inside the PACKAGE SIZE SELECT - ENDSELECT loop, I get the DBIF_RSQL_INVALID_CURSOR CX_SY_OPEN_SQL_DB exception at the beginning of the second loop.

Is there any way to avoid this?

Thanks in advance,

Jens

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

jordi_escodaruiz — Wed, 30 Jul 2008 10:42:14 GMT

Hi Jens:

You cannot call FM to write to a file inside a SELECT .. ENDSELECT Loop. This interrupts the database access.

If possible, try to reduce the amout of used memory by fetching only the required fields in your select.

Best regards

Jordi

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

Former Member — Wed, 30 Jul 2008 10:44:08 GMT

use the free statement for the internal tables...if the table data is sent to some other internal table then clear the memory of the internal tables which had no use at the end of the program

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

Former Member — Wed, 30 Jul 2008 10:45:00 GMT

It causes lot of performance. it is not advisable to use GUI_DOWNLOAD inside the select endselect.

and you are using PACKAGE SIZE.

You select them one shot and send it to GUI_DOWNLAOD.

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

Former Member — Wed, 30 Jul 2008 10:45:13 GMT

Hi,

Usually this error (DBIF_RSQL_INVALID_CURSOR ) comes if you are Select Statement is missing some fields please do have a look around with your SELECT statement.

Thanks

Sudharshan

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

jensbilgrav — Wed, 30 Jul 2008 11:25:19 GMT

What I find strange, though, is that it does not cause any problems to create the file on the application server, appending the data extracted for each package a little at a time.

It is only when using FM GUI_DOWNLOAD.

Maybe another function module for downloading the data exists?

Re: PACKAGE SIZE SELECT LOOP with incorporated function call?

ThomasZloch — Wed, 30 Jul 2008 11:47:06 GMT

It's not that strange. While you are only using the DATASET related ABAP statements when writing a file to the application server, the function GUI_DOWNLOAD might contain statements that invalidate the database cursor, such as COMMIT WORK.

Maye you can set up an automatic transfer of the complete file from the application server to the desired destination via FTP (or similar products) as a second step.

Thomas