topic Re: Fields fetched from an external DB connection. in Application Development and Automation Discussions

Fields fetched from an external DB connection.

Former Member — Tue, 13 Oct 2009 06:51:11 GMT

Hi Gurus,

I am analysing an already implemented code.

The DB connection is stored in the DBCON table.

After fetching DB name,

EXEC SQL.
          CONNECT TO :DB_CONNAME AS :SY-UNAME
      ENDEXEC.

Now my question, how can i find what are the fields fetched from this DB_CONNAME, can it be found from SAP system itself ?

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on Oct 13, 2009 8:58 AM

Re: Fields fetched from an external DB connection.

Former Member — Tue, 13 Oct 2009 07:22:34 GMT

Hi Deepan,

I am not sure I understand well your question, but if it is to know what are the values contained in variable DB_CONNAME, since it is an ABAP variable (without the ":" at the beginning), you can search it in the program where you have the EXEC SQL and try to pass the program in debug to see where it is filled, isn't it?

Best regards!

Samuel

Re: Fields fetched from an external DB connection.

Former Member — Tue, 13 Oct 2009 08:47:10 GMT

Hi Samuel,

Thanks for the reply.

Yes you got it wrong. I know the name of the connection. ( i.e DB_CONNAME's value).

I want to know how to find what are the fields fetched from the DB through this connection. since that is from a different system (SQL), how to find this.

Thanks,

Deepan.

Re: Fields fetched from an external DB connection.

Former Member — Tue, 13 Oct 2009 10:39:17 GMT

I try again

You want to search the other EXEC SQL command that appears for this connection? I guess that just below in your code there is a SELECT using this connection no?

Samuel

Re: Fields fetched from an external DB connection.

Former Member — Tue, 13 Oct 2009 11:02:25 GMT

Hi Samuel,

Thanks Again.

Yes, there is another EXEC SQL statement

followed by a select statement.

Does this SELECT answers my question ?

Are these fields fetched using this SELECT are the fields selected from DB connection.

Is it possible to know the details of these fields ? (because on clicking on them it says object doesnt exist).

Thanks,

Deepan.

Re: Fields fetched from an external DB connection.

HermannGahm — Tue, 13 Oct 2009 12:20:08 GMT

> Does this SELECT answers my question ?

> Are these fields fetched using this SELECT are the fields selected from DB connection.

yes, this is most likely the case.

> Is it possible to know the details of these fields ? (because on clicking on them it says object doesnt exist).

details on tables and fields of remote databases are only availalbe in the remote database.

Kind regards,

Hermann