OPEN SQL

                                                                  OPEN SQL
                                       (THE SQL IS DATABASE DEPENDENT)




OPEN SQL:
        THE STATEMENT  ARE SUBSET OF STANDARD SQL THAT IS FULLY INTEGRATED IN ABAP. THEY ALLOW TO ACCESS DATA IRRESPECTIVE OF THE DATA BASE SYSTEM THAT THE R/3 INSTALLATIONS IS USING.

      (OPEN SQL MODULES, TABLE MODULE , BUFFER MANAGEMENT IN APPLICATION SERVER )






NATIVE SQL:
   
                   IT IS ONLY LOOSELY INTEGRATED INTO ABAP, AND ALLOWS ACCESS TO ALL OF THE FUNCTIONS CONTAINED IN THE PROGRAMMING INTERFACE OF THE RESPECTIVE  DATABASE SYSTEM.

    ALL STATEMENT  THAT CAN BE  STATICALLY TRANSFERRED TO NATIVE SQL INTERFACE OF DATABASE INTERFACE,

  DO NOT FALL  WHICH THE LANGUAGE SCOPE OF ABAP
  DO NOT FOLLOW ABAP SYNTAX.

  SYNTAX:
   
   EXEC SQL PERFORMING <FORM>.

  < NATIVE SQL  STATEMENT >.
   
   END EXEC.



OPEN SQL:


                                    1.DDL (DATA DEFINITION LANGUAGE)
                                    2.DML(DATA MANIPULATION LANGUAGE)
                                    3.DCL(DATA CONTROL LANGUAGE)

1.DDL (DATA DEFINITION LANGUAGE)

      STATEMENTS OF CREATING AND ADMINISTERING DATABASE TABLES.
 

•     CREATE ,ALTER.

2.DML(DATA MANIPULATION LANGUAGE)

      STATEMENTS OF READING AND CHANGING DATA IN DATABASE TABLES.

•   SELECT,INSERT, UPDATE.

      

                    READING DATABASE (SELECTs)

                    CHANGING DATABASE (INSERT, UPDATE , MODIFY, DELETE. 

3.DCL(DATA CONTROL LANGUAGE).

     STATEMENTS OF AUTHORIZATION AND CONSISTENCY CHECKS.

•     COMMIT, ROLLBACK.