topic Re: Read data from secondary database in Application Development and Automation Discussions

Read data from secondary database

Former Member — Fri, 18 Jan 2013 11:50:59 GMT

Hi guys,

i want to read data from a secundary database.

Syntax:

Select * from <table> connection ( ‘DB2’ ) …

When I start the report, I get a runtime exception:

“Table unknown or does not exist.” (DBIF_RSQL_TABLE_UNKNOWN)

The table do exist on secundary database. How can I specify a database scheme?

Jörg

Re: Read data from secondary database

Former Member — Fri, 18 Jan 2013 12:03:01 GMT

Hi Joerg,

regarding the schema: when you configure the secondary connection via the DBACOCKPIT you specify a user name. This defines in particular the schema in the secondary DB when using Open SQL (via native SQL (e.g. using ADBC) you can also specify the schema but then of course the user requires access to the respective schema).

Regarding your scenario note that in order to use Open SQL via secondary connection it is required that the table/view exists in the dictionary of your local system. But I guess this is the case because otherwise you would have gotten a syntax error (unless you used dynamic SQL and specified the table name as a string).

Cheers,

Eric

Re: Read data from secondary database

former_member184871 — Fri, 18 Jan 2013 12:15:08 GMT

Hi Jörg Lutzke

It seems you forgot to mention the INTO TABLE - clause.

Request you to try this :

SELECT * FROM <TABLE> CONNECTION ('HDB1')

INTO TABLE lt_xyz "(Name of the Internal Table)

WHERE parameter = 'Some value'.

Regards

Kumar.