Exploring the Sysmaster Database
http://www.informix.com.ua/articles/sysmast/sysmast.htm
名詞(TERM)解釋
Creating Dbspaces, Databases, Tables and Indexes in Informix
IBM Informix DB-Access 使用手冊
--
dbaccess 指令
如何查詢某資料庫底下的表格:
法1 :select tabname from systables where tabid > 99 and tabtype = "T";
法2: SELECT tabname FROM systables;
直接透過command line 查詢有哪些表格
dbaccess dbname test.sql
如何查詢有幾個非預設資料庫(test.sql)
select
sysdatabases.name database
from sysdatabases where name not in ('sysmaster','sysutils','sysuser','sysadmin');
dbaccess sysmaster test.sql
以下為備份工具:
(1) use dbschema to backup the tables schema(Logical)
#-t table name or "all" for all tables
dbschema -d your_database -t all db.sql
(2) use unload for each table to backup the data..
(3) ontape command (Physical)
沒有留言:
張貼留言