topic Re: EXEC SQL STATEMENT in Application Development and Automation Discussions

EXEC SQL STATEMENT

Former Member — Tue, 28 Nov 2006 13:34:57 GMT

Is there something wrong with this EXEC SQL Statement...

        EXEC SQL PERFORMING sr_STORE_data.
          select *
                 into :<FS_wt> @:c_db
                 from (lwt_source-PS_STRUCT)
                 where sb_effdt = :p_date
        ENDEXEC.

Re: EXEC SQL STATEMENT

Former Member — Tue, 28 Nov 2006 13:59:45 GMT

Try this way...

EXEC SQL.

OPEN C1 FOR

SELECT A,B,C,D

FROM SAPTEST.XX1

ENDEXEC.

Re: EXEC SQL STATEMENT

Former Member — Tue, 28 Nov 2006 14:31:50 GMT

hi,

Check whether the table name can be passed dynamically by specifying it in parantheses.

check this sample code, it might help you,


**** A field-symbol to access that work area 
  assign NEW_LINE->*  to <wa_it>. 
*PERFORMING loop using <wa_it> changing itab_test 

  EXEC SQL. 
   open c for 
   SELECT 
   HOB_KH_IK as Ik, count(*) as ANZAHL, 
   AVG(ENTL_DATUM - HOB_AUFN_DAT) AS VWD, 
   SUM(KOSTEN_GESAMT/100)  as KOSTEN 
  FROM BUSI.BW02_K_FALL 
  GROUP BY HOB_KH_IK 

  ENDEXEC. 


 DO. 
      EXEC SQL. 
        fetch next c into :<wa_it> 
      ENDEXEC. 
      IF sy-subrc <> 0. 
        EXIT. 
      ENDIF. 
      append <wa_it> to itab_test. 
    ENDDO. 

    EXEC SQL. 
      close c 
    ENDEXEC. 

    write: / 'OK ?'.

Regards,

Sailaja.

Message was edited by:

Sailaja Nalam

Re: EXEC SQL STATEMENT

sridhar_k1 — Tue, 28 Nov 2006 14:35:25 GMT

@: not allowed after INTO, use : before a variable.

Dynamic table assignment not allowd, use table name after FROM instead of a variable.

Regards

Sridhar