Native Sql

[Former Member]

hello experts ,

i want to transfer all the data from MS SQL View to an internal table . i am currently using EXEC SQL PERFORMING LOOP_OUTPUT to transfer the data line by line . Is there any other efficient way transfer all the data at one time ?

thanks and regards .

Vivek Soni

[Former Member]

hello experts ,

i want to transfer all the data from MS SQL View to an internal table . i am currently using EXEC SQL PERFORMING LOOP_OUTPUT to transfer the data line by line . Is there any other efficient way transfer all the data at one time ?

thanks and regards .

Vivek Soni

[SuhaSaha]

Hello Vivek,

SAP has provided standard classes for this. (ADBC - ABAP DataBase Connectivity).

You can refer to the program ADBC_DEMO for this.

BR,

Suhas