What are the advantages of embedded query language, Database Management System

Assignment Help:

What are the advantages of embedded query language? Give an example of an embedded SQL query.

Embedded query language - SQL could be implemented within two ways. It can be used interactively or embedded within a host language or through using API. The use of SQL commands inside a host language (e.g., C, Java, etc.) program is known as embedded query language or Embedded SQL. While same capabilities are supported for a variety of host languages, the syntax sometimes varies. A few of the advantages of embedded SQL are:

SQL statements could be used wherever a statement in the host language is permitted.  It merges the strengths of two programming environments, the procedural characterises of host languages and non-procedural features of SQL.

SQL statements could refer to variables (must be prefixed through a colon in SQL statements) described in the host program. Special program variables (known as null indicators) are used to assign and retrieve the NULL values to and from the database.

The facilities available by the interactive query language are also automatically available to the host programs. Embedded SQL along with host languages could be used to accomplish extremely complex and complicated data access and manipulation tasks.

Example: The subsequent Embedded SQL statement within C inserts a row, whose column values are based on the values of the host language variables holds in it.

 EXEC SQL

 INSERT INTO Sailors VALUES (:c_sname, :c_sid, :c_rating, :c_age);


Related Discussions:- What are the advantages of embedded query language

Assignment, Birla Institute of Technology & Science, Pilani Work-Integrated...

Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG

Ddl compiler-database management system, DDL Compiler The DDL compile...

DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

Project, I need help in doing my dbms project

I need help in doing my dbms project

Parallelism of transaction execution-data fragmentation, Parallelism of tra...

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo...

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Describe database state in details, Describe Database state in details? ...

Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

Data manipulation language, Data Manipulation Language Data manipulatio...

Data Manipulation Language Data manipulation language (DML) describes a set of commands that are used to query and change data within existing schema objects. In this case comm

Differance between open addressing and chaining collision, Differance betwe...

Differance between Open addressing and chaining for collision resolution ? In open addressing , proceeding from the occupied position specified by hash address the program che

Development of an ER diagram and database implementation, i want answers th...

i want answers this assignment now if yiu can maket for me now ?

Special workarea for interface, While using extract datasets it is required...

While using extract datasets it is required to have a special workarea for interface False.  It is not required to have a special workarea for interface

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd