摘要: SQL statements This topic contains tables that list the SQL statements classified by type. SQL schema statements (Table 1) SQL data change statements 阅读全文
posted @ 2016-08-11 14:17 盛小胖 阅读(901) 评论(0) 推荐(0) 编辑
摘要: With static SQL, host variables used in embedded SQL statements are known at application compile time. With dynamic SQL, the embedded SQL statements a 阅读全文
posted @ 2016-08-11 14:09 盛小胖 阅读(213) 评论(0) 推荐(0) 编辑
摘要: The FETCH statement positions a cursor on the next row of its result table and assigns the values of that row to target variables. Invocation Although 阅读全文
posted @ 2016-08-11 14:02 盛小胖 阅读(2164) 评论(0) 推荐(0) 编辑
摘要: DECLARE CURSOR statement The DECLARE CURSOR statement defines a cursor. Invocation Although an interactive SQL facility might provide an interface tha 阅读全文
posted @ 2016-08-11 13:59 盛小胖 阅读(369) 评论(0) 推荐(0) 编辑
摘要: Declare section for host variables in C and C++ embedded SQL applications You must use an SQL declare section to identify host variable declarations. 阅读全文
posted @ 2016-08-11 13:53 盛小胖 阅读(378) 评论(0) 推荐(0) 编辑
摘要: The PREPARE statement creates an executable SQL statement from a string form of the statement. The character-string form is called a statement string. 阅读全文
posted @ 2016-08-09 13:55 盛小胖 阅读(421) 评论(0) 推荐(0) 编辑
摘要: oreign key constraints (also known as referential constraints or referential integrity constraints) enable you to define required relationships betwee 阅读全文
posted @ 2016-08-09 11:16 盛小胖 阅读(342) 评论(0) 推荐(0) 编辑
摘要: An informational constraint is a constraint attribute that can be used by the SQL compiler to improve the access to data. Informational constraints ar 阅读全文
posted @ 2016-08-09 10:56 盛小胖 阅读(226) 评论(0) 推荐(0) 编辑
摘要: Mixed character data and graphic data are always allowed for Unicode, but for EBCDIC and ASCII, the specific installation of DB2® determines whether m 阅读全文
posted @ 2016-08-02 10:38 盛小胖 阅读(362) 评论(0) 推荐(0) 编辑
摘要: 在Z上和开放平台上的创建方法还不太一样,两套人马开发出来的就是牛! 蛋疼…… 贴不同类型的几个例子感受一下,Z上的ASC,DESC不见了: 阅读全文
posted @ 2016-08-01 13:35 盛小胖 阅读(1003) 评论(0) 推荐(0) 编辑