Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Native SQL

Go to solution
Former Member

‎08-12-2008 1:50 PM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
chaouki_akir
Contributor

‎08-19-2008 10:54 AM

0 Kudos

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.

1 REPLY 1

Go to solution
chaouki_akir
Contributor

‎08-19-2008 10:54 AM

0 Kudos

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.