What is the difference between open sql & native sql ?
Answer Posted / sugandha verma
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. Open SQL (Subset of standard SQL
statements), allows you to access all database tables
available in the R/3 System, regardless of the manufacturer.
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.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
How many types of tables exist and what are they in data dictionary?
stock transfer from one plant to another plant ? i want the total description.
What are the attributes of the data in data dictionary? : abap data dictionary
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
What is the diffreence between bdc_close_group and bdc_close_dataset? : abap bdc
Differentiate between report and dialog program
What is the difference between field-group header and other field groups?
Is sap xi intended to replace ale?
What is the difference between skip and reserve?
What are the function of the transport system and workbench organiser? : abap data dictionary
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
Does every abap/4 have a modular structure?
What is processing class, where we do them and why? : sap abap hr
Can i Have Some Examples on Enhancements.
A field containing quantity amounts (data type quan) must be assigned to a referencetable and a reference field. Explain?