Skip to Content

Select statement in SAP JCo

Dear Experts,

I would like use Open SQL statements in SAP JCo. As of my knwoledge, my query will hit application server not the database, since it is an open SQL statement. So i need only SAP user credentials not database credentials. But i have seen in many examples they used database credentials.

Is it neccessary to have database credentials to use Open SQL in SAP JCO? If so will SAP client provide their DB credentials?

Please guide me. Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on May 13, 2015 at 10:02 AM

    Hi Remya,

    Afaik JCo won't deal with DB user directly.

    You can refer to below link for reference. It provides an example you might be interested in:
    Using dynamic Open SQL to perform joins on SAP transparent tables

    BR, Tom

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.