Top Posters
Since Sunday
25
21
20
17
16
15
15
14
14
14
14
14
New Topic  
wrote...
Posts: 98
2 months ago
What is embedded SQL, and what considerations are necessary when using it in an application?
Source  Download
Database Processing: Fundamentals, Design, and Implementation
Edition: 15th
Authors:
Read 7 times
2 Replies
Replies
Answer verified by a subject expert
wrote...
Posts: 104
2 months ago
Sign in or Sign up in seconds to unlock everything.
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.
1
Related Topics
wrote...
2 months ago
You make an excellent tutor!
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers.
Learn More
Improve Grades
Help Others
Save Time
Accessible 24/7
  269 People Browsing
 112 Signed Up Today
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 151

Related Images
 3454
 704
 83