Native SQL and FOR ALL ENTRIES statement

[stefan_kolev4]

Hi,

I need to retrieve all records from external Oracle database using Native SQL for all records in an internal table in my program.

How can I do that ?

Cheers,

Stefan

[Former Member]

Hi

The first problem is to know if both db are linked by a dblink for example, then you can use the oracle native sql in your program see the help for EXEC SQL/ENDEXEC

But I don't think the option FOR ALL ENTRIES is supported by native sql: here you need to do a symple SELECT and load your internal table

Max

[stefan_kolev4]

Hi,

Thanls for your fast responce.

Imagine we have an internal table in our program and we want to retrieve all equal records from external db using native sql.

Should I insert all records in an internal table and then use read table statement ?

Stefan

[Former Member]

Should I insert all records in an internal table and then use read table statement ?

That depends on how you need to arrange your program, I can't understand what " all equal records" means

Max

[stefan_kolev4]

I am trying to do the same as SELECT....FOR ALL ENTRIES, but in Native SQL.

Stefan

[Former Member]

Hi

That mean you have an internal table with data from SAP and you need to load the data from extranal db in according to them?

If it's so I don't believe FOR ALL ENTRIES is supported and I don't know if there's a command like that, I think you have to upload record by record:

LOOP AT ITAB.
   EXEC SQL.
       SELECT * INTO :WA
            FROM <TABLE>
                  WHERE <FIELD> = :WA-FIELD.
     ENDEXC.
    IF SY-SUBRC = 0.
      APPEND WA TO ITAB2.
    ENDIF.
ENDLOOP.

mAX

[Former Member]

Hi Max,

     Thanks for your reply.

I have one different requirement like can we load data from external DB based on internal table field condiition

LOOP AT ITAB.
   EXEC SQL.
       SELECT * INTO :WA
            FROM <TABLE>
                  WHERE <FIELD> = :WA-FIELD AND <FIELD1> = ITAB-FIELD1.
     ENDEXC.
    IF SY-SUBRC = 0.
      APPEND WA TO ITAB2.
    ENDIF.
ENDLOOP.

Please see the underlined where clause and suggest accordingly.

Thanks in advance.

-- MRM