Database connection

[Former Member]

Hi,

I've made a connection to an external database with transaction db11.

How can I test this connection?

How can I use this connection in ABAP?

Pls help needed.

[Former Member]

Hi zastwny,

(some steps u have already done with db11)

1. for this u will also require help of basis team.

2. these are the steps.

a) make an entry in DBCON

b) make connection string

(on the physical application server,

so that it can connect to secondary database)

(this will be done by basis team,

in which, they will specify the

IP address of the secondary database server,

the DATABASE ID, and the port number)

c) then using open sql / native sql,

we can use the secondary database connection,

just like normal.

d) if we use open sql,

then there must be Y/Z table on

sap as well as secondary database,

and the field names , their type all should be identical.

regards,

amit m.

[Former Member]

I've never done this yet, co how to open this connection in ABAP?

I don't think using simple select is enough.

Can You give some examples?

Best regards

[Former Member]

Hi again,

1. simple

2. DATA : CON_NAME LIKE DBCON-CON_NAME.

CON_NAME = 'MYCONNECTION'.

SELECT * FROM YTABLE

INTO ITAB

CONNECTION ( CON_NAME )

regards,

amit m.