topic Re: Select statement to execute dynamically in Application Development and Automation Discussions

Select statement to execute dynamically

Former Member — Fri, 05 Feb 2010 20:45:55 GMT

Hi,

I just want to execute the Select statement dynamically using open cursor statement and without Open cursor statment (Just Select statement).....

How can i do that in the program...

data s_cursor type cursor.
data:it_mara TYPE TABLE OF mara,
     v_stmt type string.

* Case 1 - Open cursor
v_stmt = 'SELECT * FROM MARA.'.
OPEN CURSOR WITH HOLD s_cursor FOR 
  v_stmt . "How can i execute the Select statement here

DO.
  FETCH NEXT CURSOR s_cursor APPENDING TABLE it_mara.
  IF sy-subrc  <> 0.
    EXIT.
  ENDIF.
ENDDO.

* Case 2- No Open Cursor
v_stmt.

Re: Select statement to execute dynamically

Former Member — Fri, 05 Feb 2010 21:22:41 GMT

Have you tried normal dynamic SELECTs here?

rob

Re: Select statement to execute dynamically

Former Member — Fri, 05 Feb 2010 21:27:01 GMT

I am sorry, I don't know... what is that means....

Re: Select statement to execute dynamically

Former Member — Fri, 05 Feb 2010 21:32:17 GMT

Check the ABAP documentation for SELECT and look at the columns and source areas. That shows you how to do exactly (I think) what you want. Get back to the forum if you have problems after reading that.

Rob

Re: Select statement to execute dynamically

Former Member — Fri, 05 Feb 2010 23:14:47 GMT

I used normal Select like the below. But i want to execute dynamic open SQL statments using Open Curosr, This is my requirement.

Like this OPEN CURSOR WITH HOLD s_cursor FOR (Open SQL statement).

data s_cursor type cursor.

data:it_mara TYPE TABLE OF mara.

v_stmt type string.

Case 1 - Open cursor
v_stmt = 'SELECT * FROM MARA.'.

OPEN CURSOR WITH HOLD s_cursor FOR

select * from mara.

DO.

FETCH NEXT CURSOR s_cursor APPENDING TABLE it_mara.

IF sy-subrc 0.

EXIT.

ENDIF.

ENDDO.

Case 2- No Open Cursor

select * from mara into table it_mara.

Re: Select statement to execute dynamically

Clemenss — Sat, 06 Feb 2010 00:12:20 GMT

Hi fract_get,

I wonder why you want to use OPEN CURSOR at all because I can not imagine any requirement that makes it obligatory. You may correct me when I say that OPEN CURSOR and FETCH are from the very early times when the database interface could not really help you much.

Using an ECC600 system this is simply obsolete. There are better ways.

Please convince me there are good reasons to use OPEN CURSOR WITH HOLD. What are the 'dynamics'?

I'm always happy if I can learn something.

Regards,

Clemens

Re: Select statement to execute dynamically

Former Member — Sun, 07 Feb 2010 16:34:26 GMT

I am using OPEN CURSOR for downloading the table data in multiple files based on package size. I want to use Open sql statment as a input from file. Here is my requirement...How can i make it executable the Open SQL statements here OR Is there any other way.....

DATA: BEGIN OF  IT_OPEN_SQL OCCURS 0,
        QUERY TYPE STRING,
        END OF  IT_OPEN_SQL.
DATA: V_SIZE TYPE I.

LOOP AT IT_OPEN_SQL.
  OPEN CURSOR WITH HOLD C_CURSOR FOR
      (IT_OPEN_SQL-QUERY).
  DO.
    FETCH NEXT CURSOR C_CURSOR INTO TABLE <F_FS> PACKAGE SIZE V_SIZE.
    IF SY-SUBRC NE 0.
      CLOSE CURSOR C_CURSOR.
      EXIT.
    ENDIF.
* Downloading into file.......
  ENDDO.
ENDLOOP.

Re: Select statement to execute dynamically

Former Member — Sun, 07 Feb 2010 20:09:23 GMT

I solved my problem with the following link.