DB2查询表结构的SHELL
1.新建一个文件showtab注意: 该文件要建在PATH值所指向的路径下,否则只能敲全路径才能执行
可以在 .bash_profile里面看到 PATH路径 (PATH=$PATH:$HOME/bin)
2.在showtab里面画点东西:
db2 connect to iccarddb user iccard using iccard
db2 "describe select * from $1"
3.为此文件附加可执行权限:
chmod 777 showtab
测试:(如果showtab没放在PATH下 则需要 showtab所在路径/showtab tableName来执行)
showtab tableName
tableName替换成要查的库表名就可以了。
测试结果:
Database Connection Information
Database server = DB2/LINUX 9.7.4
SQL authorization ID = ICCARD
Local database alias = ICCARDDB
Column Information
Number of columns: 30
SQL type Type lengthColumn name Name length
------------------------------------------------------------------------
452 CHARACTER 8JGM 3
452 CHARACTER 40JGMC 4
452 CHARACTER 20JGJC 4
452 CHARACTER 8HQORGNO 7
452 CHARACTER 8SJJGM 5
452 CHARACTER 8SJQSJG 6
452 CHARACTER 8SJGLJG 6
452 CHARACTER 8BBHZJG 6
496 INTEGER 4WDLSH 5
452 CHARACTER 1PZBZ 4
496 INTEGER 4YYJD 4
496 INTEGER 4ZT 2
452 CHARACTER 20KZZ 3
452 CHARACTER 8KBRQ 4
496 INTEGER 4JGLX 4
496 INTEGER 4JGJB 4
452 CHARACTER 60JGFZR
======================================================
搞定!
页:
[1]