Regarding SQL Statment

[Former Member]

Hi Guriji,

What is the SQL statment we are using in ECC 6.0 in place of ECC 4.7.

The SQL Statment is.

EXEC SQL.

SET CONNECTION :con_name

ENDEXEC.

thanks.

[Former Member]

Hi Sachin,

This is very basic. Check SAP help for more help on OPEN SQL and NATIVE SQL.

In case of NATIVE SQL all statements come under EXEC and these statement are database specific.

Thanks,

Augustin,

[Former Member]

Sachin,

You need to write

CONNECT TO :con_name.

Thanks

Bala Duvvuri

[Former Member]

hi Guruji,

This statement show error .

EXEC SQL.

SET CONNECTION :con_name

ENDEXEC.

IF sy-subrc <> 0.

• Connection not yet opened.

EXEC SQL.

CONNECT TO :con_name

ENDEXEC.

IF sy-subrc <> 0.

• error handling

ENDIF.

Error analysis

An exception occurred that is explained in detail below. The exception, which is assigned to class 'CX_SY_NATIV

caught and therefore caused a runtime error. The reason for the exception is:

Triggering ABAP/4 statement: Connect to "ORCL"

In Place of this statment what code we are using..

Thanks