Author Question: What is embedded SQL, and what considerations are necessary when using it in an application? What ... (Read 73 times)

formula1 · **on:** Jul 7, 2018

What is embedded SQL, and what considerations are necessary when using it in an application?

What will be an ideal response?

Question 2

Which does the ODBC standard not define a means of doing?

A) Start transactions
B) Rollback transactions
C) Read a Microsoft Word document
D) Issue SQL commands

connor417 · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

Embedded SQL are SQL statements used, or embedded, in program code, triggers or stored procedures. Applications are typically written in program code, using a programming language. There are two problems that arise. First, the results of SQL statements must be assigned to programming language variables. DBMS products typically provide the means of doing this. Second, SQL is table or set-oriented and SQL results use tables or sets of rows, whereas application programming languages are variable or row-oriented. This is resolved by treating SQL results as pseudofiles. A cursor is then used to move through the pseudofile one.

Answer to Question 2

C