Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Usage of Class CL_SQL_CONNECTION

arpitgoyal
Product and Topic Expert
Product and Topic Expert
0 Likes
1,021

Hi All,

The class CL_SQL_CONNECTION Provides a static method GET_CONNECTION which if sent a con_name as +R/3+* will give connection to R/3 DB.

Can I use this connection to get instance of CL_SQL_STATEMENT and create tables, insert data etc and view the changes in se11/se16?

Please help.

Regards,

Arpit

Hi All,

The class CL_SQL_CONNECTION Provides a static method GET_CONNECTION which if sent a con_name as +R/3+* will give connection to R/3 DB.

Can I use this connection to get instance of CL_SQL_STATEMENT and create tables, insert data etc and view the changes in se11/se16?

Please help.

Regards,

Arpit

3 REPLIES 3
Read only

Former Member
0 Likes
777

hi,

check out this link :

http://help.sap.com/abapdocu_70/en/ABENADBC.htm

it contains all the detalis related to your connection object plus the statement object which you can use to implement ddl and dml in sap.

hope this will surely help you!!!

thanks & regards,

punit raval.

Read only

arpitgoyal
Product and Topic Expert
Product and Topic Expert
0 Likes
777

Gone through this link. Doesn't have what I am looking for.

Read only

arpitgoyal
Product and Topic Expert
Product and Topic Expert
0 Likes
777

Got answer from the Author itself.