CS348 Lecture Notes - Lecture 6: Database, Embedded Sql, Compile Time
15 Oct 2018
School
Department
Course
Professor
Document Summary
In order to execute a string as a sql statement we need an application that accepts an sql statement as an argument and executes it (printing out any answers) The more you know at compile time, the more readable! The following is a roadmap of dynamic sql (where the sqlda is a runtime data structure that communicates type information between the pl and sql: execution of non-parametric statements without answers: exec sql execute immediate. :string; where :string is a host variable containing the ascii representation of the query. :string may not return an answer nor contain parameters and is compiled every time we pass through: used for constant statements executed only once. Use exec sql execute stmt using :var1 [, , Use a dynamic descriptor area (explicitly sqlda in practice: allocate descriptor descr. Selena latchman: get/set descriptor descr what (where what is the value for count or for the i-th attribute value :i assgn, describe [input|output] stmt into descr.
