Native SQL

Former Member — Tue, 12 Aug 2008 12:50:15 GMT

People, command SET CONNETION is returned sy-subrc = 4. Table DBCON is customized.

See the code:

EXEC SQL.

SET CONNECTION : 'RH X COMGAS121'

ENDSELECT.

The name: RH X COMGAS121 is field CON NAME of table DBCON.

Can Someone help me?

Thanks a lot,

Eriton

Re: Native SQL

chaouki_akir — Tue, 19 Aug 2008 09:54:48 GMT

Hello,

try to change your ABAP code as follow :

[]

DATA: BEGIN OF wa,
ncli(20) TYPE c,
num(20) TYPE c,
END OF wa.
 
DATA: dbs TYPE dbcon-con_name.
DATA : ls_wa LIKE wa.
 
dbs = 'NEWORA'. "DB Connection in DBCO
 
EXEC SQL.
connect to :dbs "Here the connection is failing.
ENDEXEC.
 
EXEC SQL.
GET CONNECTION :dbs
ENDEXEC.
 
WRITE : dbs.
 
EXEC SQL PERFORMING loop_output.
select bundle_cnt, job_id from GHCBRMRT.RML_BUNDLE into :ls_wa
ENDEXEC.
 
 
FORM loop_output.
WRITE: / ls_wa-ncli,
ls_wa-num.

Cordialement,

chaouki.

topic Native SQL in Application Development and Automation Discussions

Native SQL

Re: Native SQL