数据库系统概念高级.pptVIP

*/70 Embedded SQL (Cont.) cp88 The open statement causes the query to be evaluated EXEC SQL open c END-EXEC 把查询结果元组放进主语言用fetch ，（可循环调用） The fetch statement causes the values of one tuple in the query result to be placed on host language variables. EXEC SQL fetch c into :cn, :cc END-EXECRepeated calls to fetch get successive tuples in the query result . 第31页，共70页。 */70 Embedded SQL (Cont.) cp88 通讯区SQLCA，SQL与主语言共享，互通信息 A variable called SQLSTATE in the SQL Communication Area (SQLCA) gets set to ‘02000’ to indicate no more data is available 结束，删除临时结果 The close statement causes the database s