2016年8月11日
直接放个DB2 SQL STATEMENT大全好了！
摘要： 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 盛小胖 阅读(941) 评论(0) 推荐(0)
瞧一瞧迷一般的SQLDA
摘要： 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 盛小胖 阅读(230) 评论(0) 推荐(0)
再来一发！DB2 应用程序如何从数据库取数据 Fetch
摘要： 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 盛小胖 阅读(2199) 评论(0) 推荐(0)
DB2 嵌入式应用中定义游标（开放平台上）
摘要： 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 盛小胖 阅读(390) 评论(0) 推荐(0)
DB2应用中嵌入式SQL取值入本地变量
摘要： 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 盛小胖 阅读(394) 评论(0) 推荐(0)
2016年8月9日
DB2 for Z/os Statement prepare
摘要： 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 盛小胖 阅读(429) 评论(0) 推荐(0)
Foreign key (referential) constraints on DB2 LUW v105
摘要： 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 盛小胖 阅读(388) 评论(0) 推荐(0)
复制Informational constraints on LUW DB2 v105
摘要： 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 盛小胖 阅读(240) 评论(0) 推荐(0)
2016年8月2日
DB2 SQL Mixed data in character strings
摘要： 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 盛小胖 阅读(379) 评论(0) 推荐(0)
2016年8月1日
DB2 create partitioned table
摘要： 在Z上和开放平台上的创建方法还不太一样，两套人马开发出来的就是牛！ 蛋疼…… 贴不同类型的几个例子感受一下，Z上的ASC，DESC不见了： 阅读全文
posted @ 2016-08-01 13:35 盛小胖 阅读(1025) 评论(0) 推荐(0)