Coding a transaction
•Typically a computer-based system doing OLTP has a collection of application programs
•Each program is written in a high-level language, which calls DBMS to perform individual SQL statements
–Either through embedded SQL converted by preprocessor
–Or through Call Level Interface where application constructs appropriate string and passes it to DBMS