数据库常用命令

1. select：
   选择前3条记录: select * from acl_user fetch first 3 rows only
   查询从第m条到第n条记录:

   select * from (select ROW_NUMBER() over() as a, acl_user from acl_user) as acl_user where a >=5 and a<=30

2.查看db2当前的schema

通过DB2提供的专用寄存器current schema/sqlid可以查看当前的模式,比如

   select current schema from sysibm.sysdummy1
   select current schema from sysibm.dual
   或
   select current sqlid from sysibm.sysdummy1
   select current sqlid from sysibm.dual
   或
   values current schema
   values current sqlid　
   注:dual是一个从sysdummy1中创建而来的view
   
 db2 => connect to db_name
 db2 => select current schema from sysibm.sysdummy1
 db2 => select current schema from sysibm.dual