SQL serves connection and sql table update

[Former Member]

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.

[former_member222709]

Hi,

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

Refer this link:

[;

Regards,

Pranav.

[Former Member]

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.

[former_member222709]

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.

[Former Member]

Hi

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

[SuhaSaha]

> 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