Fields fetched from an external DB connection.

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[HermannGahm]

Hi

> 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