回复 4# 新数科技 建立一个schema[db2inst1@DB2 ~]$ db2 "create schema prod"DB20000I The SQL command completed successfully.设置[db2inst1@DB2 ~]$ set schema=prod建立表并且插入数据[db2inst1@DB2 ~]$ db2 "create table test3(a smallint)"DB20000I&...
显示全部回复 4# 新数科技 建立一个schema
[db2inst1@DB2 ~]$ db2 "create schema prod"
DB20000I The SQL command completed successfully.
设置
[db2inst1@DB2 ~]$ set schema=prod
建立表并且插入数据
[db2inst1@DB2 ~]$ db2 "create table test3(a smallint)"
DB20000I The SQL command completed successfully.
[db2inst1@DB2 ~]$ db2 "insert into test3 values (1)"
DB20000I The SQL command completed successfully.
A
------
1
1 record(s) selected.
但是发现无法从prod中查出数据
[db2inst1@DB2 ~]$ db2 " select * from prod.test3 "
SQL0204N "PROD.TEST3" is an undefined name. SQLSTATE=42704
收起