Skip to Content
author's profile photo Former Member
Former Member

sql>>>?

hi ppl,

what is open sql?

what is the diffrece b/w open and native sql??

what are the areas where opne sql is used?

thanx in advance!!!

regards,

b.s

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 06:43 AM

    From the help on "open SQL"

    Open SQL

    Open SQL is a set of ABAP/4 commands which perform operations on database tables. The results of these operations and associated error messages are independent of the database system used. Open SQL thus offers you unified SQL syntax and semantics for different database systems (see Portability). An ABAP/4 program which uses these commands can be run on database systems supported by SAP without modification.

    From the help on Native SQL

    Native SQL

    Native SQL allows you to perform operations on databases over and above those in the Open SQL command set. In contrast to Open SQL, Native SQL supports not only operations on the local database active in the R/3 System, but also on any external databases.

    We normally use open SQL, but in some case when you want to say look at the upper case value of an upper/lower case field in a database, you can use native SQL.

    Native SQL seems somewhat slower and you have to know which databse you will be using it on before coding.

    For more information type EXEC in the editor and press F1.

    Click the below link for OPEN SQL

    http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3969358411d1829f0000e829fbfe/content.htm

    Click the below link for Native SQL

    http://help.sap.com/saphelp_47x200/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 06:52 AM

    Hi,

    Pls chek this link for the diff between native and open SQL:

    open-sql-and-native-sql

    http://help.sap.com/saphelp_46b/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

    Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program.

    To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP.

    A database interface translates SAP's Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly

    Regards,

    Anjali

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 06:57 AM

    Hi Swaminathan,

    You can refer these SDN links as well..

    Open Sql and Native Sql

    Regards,

    SP.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 07:42 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2006 at 08:39 AM

    Hi,

    <b>OPEN SQL</b>

    In the R/3 System, long-life data is stored in relational database tables. Structured Query Language (SQL) was created for accessing relational Database. SQL has two statement types: Data Definition Language (DDL) statements and Data Manipulation Language (DML) statements.

    TO include SQL statements in an ABAP/4 program, use Native SQL. To avoid incompatibilities between different database tables and also to make ABAP/4 program independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements, which are specific to SAP. Using Open SQL enables you to access any database tables available to the SAP system regardless of the manufacturer be it Oracle, Informix etc.

    <i>The difference between Open SQL and Native SQL is as follows:</i>

    A database interface translates SAP’s Open SQL statements into SQL commands specific to the database in use. Native SQL statements access the database directly.

    Open SQL keywords

    Keywords Used for

    • SELECT: Reading Data from Database Tables

    • INSERT: Adding Lines to Database Tables

    • UPDATE: Changing Lines in Database Tables

    • MODIFY: Adding or Changing Lines

    • DELETE: Deleting Lines from Database Tables

    Thanks,

    Ramya

    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.