topic Re: Open VS. Native in Application Development and Automation Discussions

Open VS. Native

Former Member — Thu, 07 Feb 2008 11:14:33 GMT

Hi,

I need a list of advantages and disadvantages of Native/Open SQL.

Thanks.

Re: Open VS. Native

Former Member — Thu, 07 Feb 2008 11:19:07 GMT

Hi,

Check this link.

Reward points if it helps.

Re: Open VS. Native

Former Member — Thu, 07 Feb 2008 11:19:18 GMT

hi,

ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most

ABAP programs containing database-specific SQL statements do not run with different databases. If

different databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use

the statement EXEC.

Subset of standard SQL statements.

To avoid conflicts between database tables and to keep ABAP programs independent from the database

system used, SAP has generated its own set of SQL statements known as Open SQL.

Using Open SQL allows you to access all database tables available in the R/3 System, regardless of the

manufacturer.

Hope this is helpful, Do reward.

Re: Open VS. Native

Former Member — Thu, 07 Feb 2008 11:20:10 GMT

Hi,

Please refer to the link below :

http://www.erpgenie.com/abaptips/content/view/240/62/

Thanks,

Sriram Ponna.

Re: Open VS. Native

Vijay — Thu, 07 Feb 2008 11:23:44 GMT

Types of SQL’s

Native SQL

Open SQL

Open SQL commands

SELECT

INSERT

UPDATE

MODIFY

DELETE

OPEN CURSOR, FETCH, CLOSE CURSOR

Open SQL – Return codes

Sy-subrc

- Return value after specific ABAP/4 statements

Sy-dbcnt

- DB operations: Number of elements in the edited dataset

Native SQL

EXEC SQL [PERFORMING ENDEXEC.

regards

vijay

reward points if helpful

Re: Open VS. Native

Former Member — Thu, 07 Feb 2008 12:59:48 GMT

hi,

Here;s the advantages and dis advantages

Native SQL Advantages and Disadvantages - EXEC SQL statement

Advantages

Tables are not declared in ABAP Dictionary can be accessed. (e.g. Tables belonging to sys or system user of Oracle, etc.)

To use some of the special features supported by the database-specific SQL. (e.g. Passing hints to Oracle optimizer.)

Disadvanteges

No syntax check is performed whatever is written between EXEC and ENDEXEC.

ABAP program containing database-specific SQL statements will not run under different database systems.

There is no automatic clien handling for client dependent tables.

Care has to be taken during migration to higher versions.

Hope this is helpful, Do reward.