Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
First of all check whether DB connection is done from transaction DBCO. If no connection is made then ask your basis team to do this.
Then is your program were you want to read the table from oracle 9i write a code like this:
The table can be read with the help of declaring a cursor type data.
EXEC SQL.
CONNECT TO 'MYCONNECTION' " Name of DB connection
ENDEXEC.
EXEC SQL.
open c for
SELECT * from PVACCOUNTBALANCE2
ENDEXEC.
DO.
EXEC SQL.
FETCH NEXT c INTO :ithead " internal table for data
ENDEXEC.
append ithead.
IF sy-subrc ne 0.
EXIT.
ENDIF.
ENDDO.
EXEC SQL.
CLOSE c
ENDEXEC.
EXEC SQL.
DISCONNECT :'MYCONNECTION'
ENDEXEC.
First of all check whether DB connection is done from transaction DBCO. If no connection is made then ask your basis team to do this.
Then is your program were you want to read the table from oracle 9i write a code like this:
The table can be read with the help of declaring a cursor type data.
EXEC SQL.
CONNECT TO 'MYCONNECTION' " Name of DB connection
ENDEXEC.
EXEC SQL.
open c for
SELECT * from PVACCOUNTBALANCE2
ENDEXEC.
DO.
EXEC SQL.
FETCH NEXT c INTO :ithead " internal table for data
ENDEXEC.
append ithead.
IF sy-subrc ne 0.
EXIT.
ENDIF.
ENDDO.
EXEC SQL.
CLOSE c
ENDEXEC.
EXEC SQL.
DISCONNECT :'MYCONNECTION'
ENDEXEC.
i mean, what is the structure of the iternal table. Do we need to declare the fileds in the internal table having the same structure of remote server table stucture ?
Bluesky
