Native SQL

[Former Member]

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

[chaouki_akir]

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.