生成n到m之间随机数db2 -x "select 'USER'||(n+cast(rand()*(m-n) as int)) from sysibm.sysdummy1" >username.delimport from username.del of del into yourtable;
显示全部生成n到m之间随机数
db2 -x "select 'USER'||(n+cast(rand()*(m-n) as int)) from sysibm.sysdummy1" >username.del
import from username.del of del into yourtable;
收起