常用命令列表

当前用户组为GDC

SET CURRENT SQLID='GDC'

 

 

建立两个表
 

 CREATE TABLE TRAN257        
  (CUSTNO   CHAR(8) NOT NULL, 
   ACCTTYP  CHAR(2) ,         
   AMOUNT   DECIMAL(12,2),    
   TRANDATE DATE,             
   PRIMARY KEY (CUSTNO)       
   )                          

  CREATE TABLE MST257             
  (CUSTNO     CHAR(8) NOT NULL,   
   ACCTTYP    CHAR(2) NOT NULL,   
   AMOUNT     DECIMAL(12,2),      
   DATE       DATE,               
   PRIMARY KEY (CUSTNO)           
   )                              

插入数据：

 INSERT INTO GDC.TRAN257                   
VALUES('10000001','10',200,'2008-10-01')                                                      

创建索引

  CREATE UNIQUE WHERE NOT NULL INDEX DEPTI274 ON DEPT274(DEPTNO ASC);

当前用户组为GDC

SET CURRENT SQLID='GDC'

 

119915032
HELP DESK