PL/SQL

[Former Member]

Hi all,

I am trying to retrieve a group of data using native sql stmts ( sellect stmnt) <> Exec sql and EndExcec .But wat happens is dat only first data gets fetched. Do i have run in it within a loop or add any other coding to retrive a group of data.

Thanks,

Kavitha

[Former Member]

Hi Kavitha,

I think you have to use DO..ENDDO (Loops)

Regards,

Atish

[GrahamRobbo]

Hi Kav,

try using a cursor. This code snippet if from the SAP Help for Native SQL.

DATA: F1(3), F2(3), F3(3). 
F3 = ' 1 '. 
EXEC SQL. 
  OPEN C FOR 
    SELECT CLIENT, ARG1 FROM AVERI_CLNT 
        WHERE ARG2 = :F3 
ENDEXEC. 
DO. 
  EXEC SQL. 
    FETCH NEXT C INTO :F1, :F2 
  ENDEXEC. 
  IF SY-SUBRC <> 0. 
    EXIT. 
  ENDIF. 
  WRITE: / F1, F2. 
ENDDO. 
EXEC SQL. 
  CLOSE C 
ENDEXEC.

Cheers

Graham

[Former Member]

Have a look at the answers to your other PL/SWL posting in Data Transfers too: