14 July, 2018
Write short note on embedded SQL SQL provides a powerful declarative query language writing queries in SQL is topically much is a easier than is coding the same queries in a general purpose programming language .
SQL in a variety of programming language program writing in a host language can use the embedded SQL Syntax to access and update data stored in a database the embedded form of SQL extends the programmers ability to manipulate the database even feather in embedded SQL all queries processing is performed by the database system the result of the query is then made available to the program tuple a time .
In embedded SQL program must be processed by a special preprocessor prior to compilations . SQL requested or replaced with host language declarations and and procedures calls that allowed and time execution of the database accesses than the resulting programming is compiled complete by the host in language compiler to identify embedded SQL request to the preprocessor .
EXEC SQL <SQL DATA >END EXECThe exact Syntax the embedded SQL request depends on the language in which SQL is embedded for instance semi-colon is used instead on end e x e c when SQL is embedded in C or Pascal.
we place the statement SQL included in the program to identify the place where the processor preprocessor should insert the special variety used for communications between the program and the database system variables of the host language can be used within embedded SQL statement what they must be preceded by a colon them from SQL variables .
EXES SQL<SQL YOUR STATUS>END EXES