open sql and negative sql

[Former Member]

what is open sql ?

what is negative sql ?

what is difference between open and negative sql ?

kindly help me.

[Former Member]

hi

by negative sql do you mean Native sql

then answer is

native sql : are not checked and converted they are sent

directly to the database system.allows to use database

specific sqql statements in an abap program.

Open sql: it will work on any r/3 system regardless of the

database system in use.

open sql is not confined to any particular type of database

while a native sql is confined to a particular one.

Reward if helpful

kushagra

[Former Member]

well...don't know where you got the term from...its NATIVE SQL and not NEGATIVE SQL.

Open sql is the SQL that is interpreted by the abap interpreter. Open sql are abap statements which are written to access data dictionary tables.

Native sql statements have to be written within EXEC SQL and ENDEXEC blocks.

The difference is that this block is not checked for syntax errors while checking errors in abap syntax. This block is directly executed at the database level and the relevant database DML/DDL checks are done.

check the following link for further reference...

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

[Former Member]

\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]

Edited by: Jan Stallkamp on Aug 19, 2008 4:25 PM

[Former Member]

\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]

Edited by: Jan Stallkamp on Aug 19, 2008 4:33 PM

[Former Member]

Hi,

Open SQL is the SQL language used internally by the SAP application server. Native SQL is the language used directly by the DB. The application server translates the OpenSQL to native SQL when sending commands to the DB.

Regards

Kiran Sure

[Former Member]

\[removed by moderator as it was just a copy and paste answer of someone else's work without giving a source\]

Edited by: Jan Stallkamp on Aug 19, 2008 4:27 PM

[Former Member]

SARITHA,

refer

[THIS IS ANSWERED TODAY|]

[JanStallkamp]

Hi.

I just noticed this thread because someone added an answer independent of the fact that it was marked as answered and some month old. I had to notice several people giving copy-and-past answers. Note that we don't tolerate that here in the SCN! I had to reassign points as some more or less correct answers did not get any points and the copy-and-paste folks got 6-10 points.

I will lock this thread as people start answering this old question again.

Best regards,

Jan Stallkamp