topic Re: Regarding SQL Statment in Application Development and Automation Discussions

Regarding SQL Statment

Former Member — Fri, 31 Jul 2009 08:43:45 GMT

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 — Fri, 31 Jul 2009 08:58:19 GMT

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 — Fri, 31 Jul 2009 09:06:11 GMT

Sachin,

You need to write

CONNECT TO :con_name.

Thanks

Bala Duvvuri

Former Member — Fri, 31 Jul 2009 09:40:33 GMT

hi Guruji,

This statement show error .

EXEC SQL.

SET CONNECTION :con_name

ENDEXEC.

IF sy-subrc <> 0.

EXEC SQL.

CONNECT TO :con_name

ENDEXEC.

IF sy-subrc <> 0.

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