topic Re: open sql and negative sql in Application Development and Automation Discussions

open sql and negative sql

Former Member — Fri, 16 May 2008 05:14:50 GMT

what is open sql ?

what is negative sql ?

what is difference between open and negative sql ?

kindly help me.

Re: open sql and negative sql

Former Member — Fri, 16 May 2008 05:20:53 GMT

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

Re: open sql and negative sql

Former Member — Fri, 16 May 2008 05:21:33 GMT

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

Re: open sql and negative sql

Former Member — Fri, 16 May 2008 05:23:59 GMT

\[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

Re: open sql and negative sql

Former Member — Fri, 16 May 2008 05:42:03 GMT

\[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

Re: open sql and negative sql

Former Member — Fri, 16 May 2008 05:52:11 GMT

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

Re: open sql and negative sql

Former Member — Tue, 19 Aug 2008 14:16:46 GMT

\[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

Re: open sql and negative sql

Former Member — Tue, 19 Aug 2008 14:29:39 GMT

SARITHA,

refer

[THIS IS ANSWERED TODAY|]

Re: open sql and negative sql

JanStallkamp — Tue, 19 Aug 2008 14:40:51 GMT

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