DB2培训文档.ppt

流控制语句 流控制语句 混合语句(compound statements) 5.非原子的混合语句： 6.原子的混合语句 标签语句 条件语句(if 和case)： 循环语句： IBM 软件部 | DB2 信息管理软件 ? 2006 IBM公司 IBM logo must not be moved, added to, or altered inany way. Background shouldnot be modified. Title/subtitle/confidentiality line: 10pt Arial Regular, whiteMaximum length: 1 lineInformation separated by vertical strokes,with two spaces on either side Slide heading:28pt Arial Regular, blue R120 | G137 | B251 Maximum length: 2 lines Slide body:18pt Arial Regular, blackSquare bullet color:teal R045 | G182 | B179Recommended maximum text length: 5 principal points Group name:14pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, white Optional slide number: 10pt Arial Bold, white Template release: Oct 02For the latest, go to /ibm/presentations Indications in green = Live content Indications in white = Edit in master Indications in blue = Locked elements Indications in black = Optional elements IBM软件部 ? 2007 IBM 公司 IBM logo must not be moved, added to, or altered in any way. Indications in green = Live content Indications in white = Edit in master Indications in blue = Locked elements Indications in black = Optional elements Presentation title:28pt Arial Regular, blackRecommended maximum length: 2 lines Group name:17pt Arial Regular, whiteMaximum length: 1 line Copyright: 10pt ArialRegular, white Template release: Oct 02For the latest, go to /ibm/presentations For client presentations, client’s logo may go in this area 混合语句 在混合语句和循环中使用标号语句 条件语句(if和case) 四种循环语句(for,while,repeat和loop) 控制语句中的四种流转语句(goto,leave,iterate,return) 1.混合语句是把相关的一组语句放在一个组里； 2.begin和end是定义混合语句的关键字； 3.在使用混合语句时需要遵循下面的语句编写顺序： begin variable declarations condition declarations cursor declarations handler declarations assignment,flow of control,SQL statement, and other compound statements end 4.混合语句嵌套使用时，变量的作用域 1)外部的嵌套语句看不到内部的嵌套语句中定义的变量； 2)内部的嵌套