摘要:
在存储过程体内写上DECLARE clientcur CURSOR WITH RETURN TO CALLER;FOR SELECT name, dept, job FROM staff WHERE salary > 15000;OPEN clientcur; 阅读全文
摘要:
//建立数据库DB2_GCB CREATE DATABASE DB2_GCB ON G: ALIAS DB2_GCB USING CODESET GBK TERRITORY CN COLLATE USING SYSTEM DFT_EXTENT_SZ 32 //连接数据库 connect to sample1 user db2admin using 8301206 //建立别名 create al... 阅读全文