topic Native Sql in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/native-sql/m-p/6354291#M1399311 <HTML><HEAD></HEAD><BODY><P>hello experts ,</P><P></P><P> 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 ?</P><P></P><P>thanks and regards .</P><P>Vivek Soni</P></BODY></HTML> Mon, 23 Nov 2009 09:53:49 GMT Former Member 2009-11-23T09:53:49Z Native Sql https://community.sap.com/t5/application-development-and-automation-discussions/native-sql/m-p/6354291#M1399311 <HTML><HEAD></HEAD><BODY><P>hello experts ,</P><P></P><P> 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 ?</P><P></P><P>thanks and regards .</P><P>Vivek Soni</P></BODY></HTML> Mon, 23 Nov 2009 09:53:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql/m-p/6354291#M1399311 Former Member 2009-11-23T09:53:49Z Re: Native Sql https://community.sap.com/t5/application-development-and-automation-discussions/native-sql/m-p/6354292#M1399312 <HTML><HEAD></HEAD><BODY><P>Hello Vivek,</P><P></P><P>SAP has provided standard classes for this. (ADBC - ABAP DataBase Connectivity).</P><P></P><P>You can refer to the program ADBC_DEMO for this.</P><P></P><P>BR,</P><P>Suhas</P></BODY></HTML> Mon, 23 Nov 2009 10:05:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-sql/m-p/6354292#M1399312 SuhaSaha 2009-11-23T10:05:05Z