This topic contains a solution. Click here to go to the answer
« previous next »

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

formula1

  • Hero Member
  • *****
  • Posts: 666
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


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

connor417

  • Sr. Member
  • ****
  • Posts: 329
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


formula1

  • Member
  • Posts: 666
Reply 2 on: Jul 7, 2018
Great answer, keep it coming :)

duy1981999

  • Member
  • Posts: 341
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Adolescents often feel clumsy during puberty because during this time of development, their hands and feet grow faster than their arms and legs do. The body is therefore out of proportion. One out of five adolescents actually experiences growing pains during this period.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Increased intake of vitamin D has been shown to reduce fractures up to 25% in older people.

Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages Demonstrate the Application of Triangular, Figure-Eight, and Tubular Bandages
Forearm application to engage the common fascial restrictions in the trapezius and levator scapula ... Forearm application to engage the common fascial restrictions in the trapezius and levator scapula ...
How to solve application problems containing quadratics (Question 3) How to solve application problems containing quadratics (Question 3)
Advanced functions application Advanced functions application
Application and Integration Application and Integration
Application And Integration Application And Integration
Video: Angiotensin II - kidneys, adrenal glands and dehydration

For a complete list of videos, visit our video library