db2中truncate命令有吗

zhangzongjun

原帖由 diablo2 于 2009-1-15 09:08 发表
誰翻的洛铁阿

刚发现这是个老贴，
flycat88  你可真够厉害的

Pythagoras

Truncate is a SQL statement, not a command.  And truncate is supported in DB2 9 for z/OS.

oract

原帖由 Pythagoras 于 2009-1-16 08:40 发表
Truncate is a SQL statement, not a command.  And truncate is supported in DB2 9 for z/OS.

这位仁兄搞主机DB2？

Germin

原帖由 Pythagoras 于 2009-1-16 08:40 发表
Truncate is a SQL statement, not a command.  And truncate is supported in DB2 9 for z/OS.

为啥微机环境不支持？

IBM不至于实现不了吧。。。

oract

原帖由 Germin 于 2009-1-17 21:10 发表


为啥微机环境不支持？

IBM不至于实现不了吧。。。

开放DB2和主机DB2在结构上差异很大。
落实到具体的技术层面起码在开放平台V9 里面尚且不支持truncate


db2 => create table test(a  integer)
DB20000I  The SQL command completed successfully.
db2 =>
db2 =>
db2 =>
db2 => insert into test values(1)
DB20000I  The SQL command completed successfully.
db2 => commit
DB20000I  The SQL command completed successfully.
db2 =>
db2 =>
db2 =>
db2 => truncate table test
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "table" was found following "truncate ".  
Expected tokens may include:  "JOIN <joined_table>".  SQLSTATE=42601
db2 =>
db2 =>
db2 =>
db2 =>
db2 => drop table test
DB20000I  The SQL command completed successfully.
db2 =>
db2 =>
db2 => quit
DB20000I  The QUIT command completed successfully.
$
$
$ db2level
DB21085I  Instance "db2inst1" uses "64" bits and DB2 code release "SQL09013"
with level identifier "01040107".
Informational tokens are "DB2 v9.1.0.3", "s070719", "U811590", and Fix Pack
"3".
Product is installed at "/opt/IBM/db2/V9.1".

zhangzongjun

有主机DB2的相关资料吗？
例如 信息中心 啥的？

zhangzongjun

db2 有 “truncate ”，但不是命令，而是函数

oract

原帖由 zhangzongjun 于 2009-1-17 22:58 发表
有主机DB2的相关资料吗？
例如 信息中心 啥的？

其实我对主机系统也仅仅是略微了解，感觉在DB2编程的层次上来说和开放似乎差不多，毕竟大家都是RDBMS嘛，基础的东西都是一样的。但是在架构上就是天壤之别了，例如子系统、database、数据共享等好多概念是紧密和MVS结合的。如果想搞主机DB2还是要先搞搞MVS（z/OS或S/390）之类的。

oract

db2 =>
db2 =>
db2 =>
db2 =>
db2 => select truncate(2.1234567,3) from SYSIBM.SYSDUMMY1

1         
----------
2.1230000

  1 &Igrave;&otilde;&frac14;&Ccedil;&Acirc;&frac14;&Ograve;&Ntilde;&Ntilde;&iexcl;&Ocirc;&ntilde;&iexcl;&pound;

db2 =>


是对数字类型的变量进行小数位数精度指定的函数

fandy81

学习!