?
Solved

SAP 4.0B and "Exec Sql" in ABAP code

Posted on 2003-02-19
2
Medium Priority
?
1,728 Views
Last Modified: 2013-12-08
Hi,

I attempting to use "EXEC SQL" in ABAP code on a SAP 4.0B system to access
Z tables at the
Oracle level and tables in a remote database connected using Oracle's
DBLINK.  The problem I have is that when I do a select on either the
remote table or an SAP table (VBAP)it gives table not found.  I assume
that I am connecting with an id different than the owner of the SAP
tables.  Here is what I need to find out.

1.  Are there special considerations to using the Exec Sql command?
2.  Is there a owner for SAP tables that has to be defined in SQL
statements?
    Is there a command that can establish connection as the owner id
so that subsequent DB activities don't need to qualify the owner.
3.  Is anyone currently connecting to remote Oracle databases via
DBLINK?  I am looking for feedback on how it works.

Thanks

Bill Brennum
0
Comment
Question by:pgwjb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
daravuth earned 600 total points
ID: 7986132
hello,

owner of any sap table in oracle is "sap"
so

SVRMGR> select count(*) from tadir;
select count(*) from tadir
                     *
ORA-00942: table or view does not exist



SVRMGR> select count(*) from sapr3.tadir;
COUNT(*)
----------
    302383
1 row selected.
SVRMGR>

more I don't know, good luck
0
 

Author Comment

by:pgwjb
ID: 7988977
Thanks,  I was able to figure it out yesterday.  But your answer is correct.

Thanks
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 18 hours left to enroll

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question