topic Re: SQL serves connection and sql table update in Application Development and Automation Discussions

SQL serves connection and sql table update

Former Member — Thu, 25 Aug 2011 08:53:43 GMT

Hi,

i want to use sql server database for some purposes, i will fill the sql tales via a job from abap.

but i did not write any code up to this time about abap and sql serves entegration.

how can i do this?

system is as follows:

System Component Version SAP ECC 6.0 /700

DB:DB6_9.7.3

OS:AIX 5.3

Server Name:sapprddb

Client : 006

IP : 10.4.1.1

Sistem no : 00

Sistem Tanım : PRD

from this system i want to connect to sql server and insert data to sql server table, assume customers...

thanks.

Re: SQL serves connection and sql table update

former_member222709 — Thu, 25 Aug 2011 09:08:52 GMT

Hi,

You can search SDN with keywords as Native SQL and you'll get all the info needed.

Refer this link:

[;

Regards,

Pranav.

Re: SQL serves connection and sql table update

Former Member — Thu, 25 Aug 2011 12:34:32 GMT

thanks for reply.

but how can i connect to sql server, do commands change when db is db2 or sql server or oracle?

what should i pay attention on?

please write me about these and if possible a sample code.

thanks.

Re: SQL serves connection and sql table update

former_member222709 — Fri, 26 Aug 2011 05:18:25 GMT

Hi,

I think I got your question. The first step to establish an SQL connection is configure the details using T. Code: DB02. It's done by the BASIS Team, but is pretty self explanatory. Even you can do it, if you have the access.

Regards,

Pranav.

Re: SQL serves connection and sql table update

Former Member — Fri, 26 Aug 2011 06:00:00 GMT

Before writing code it needs to create a link between SAP and SQL server, this can usually be done by a dblink, so you need to ask your basis if he can do it

Max

Re: SQL serves connection and sql table update

SuhaSaha — Fri, 26 Aug 2011 06:26:01 GMT


> but how can i connect to sql server, do commands change when db is db2 or sql server or oracle?

If you've the external DB connection params, you'll have to configure them in DBCO(Tcode).

If you use the ADBC classes(CL_SQL*) you need not worry about the DB platform. The SAP kernel call will handle it for you

BR,

Suhas