在v8.3中实现更多功能性CLP的梦想 [英] A dream of more functional CLP in v8.3
问题描述
亲爱的IBM DB2支持，
我希望CLP更具功能性。没有生活命令
行我想得到sql返回码解释，标量函数
定义等..
寻找转发v8.3中的CLP增强功能
-mike
所以******* @ gmail.com 写道：亲爱的IBM DB2支持，
我希望CLP功能更强大。没有生活命令行我想得到sql返回码解释，标量函数定义等等。
期待看到v8.3中的CLP增强功能
DB2 V8.3？没有这样的事情。
你试过吗：
？ SQL0204
CLP中的
。 ？给出了SQL CODE和SQLSTATE的解释。
从SYSCAT.ROUTINES中选择文本ROUTINENAME ='''FOO''和
ROUTINESCHEMA =''SRIELAU''
给你功能体（或者你的意思是什么？）
什么是等等???
我正在收集V蛇+ 2，所以狂野:-)
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
" Serge Rielau" < SR ***** @ ca.ibm.com>写道：
新闻：4d ************* @ individual.net ...
我正在收集Viper + 2的要求，所以狂野： - ）
Serge，我很高兴在这里邀请。你能公开获得Viper目前收藏的愿望清单吗？
-
Konstantin Andreev。
Konstantin Andreev写道：" Serge Rielau" < SR ***** @ ca.ibm.com>写道：
新闻：4d ************* @ individual.net ...我正在收集Viper + 2的要求，所以去吧狂野： - ）
塞尔，我很高兴在这里邀请。你能否公开目前收集的Viper愿望清单？
V蛇已经完成并结束......
但是确定我可以快速大脑转储SQL-ish功能请求我是
*行比较（伯纳德的最爱）
CREATE TABLE T1（c1 int，c2 int）;
SELECT * FROM T1 WHERE（c1，c2）> ; （？，？）
* mySQL样式的OFFSET子句：
SELECT * FROM T FETCH FIRST 5 ROWS OFFSET 10
*改进模式演变
例如允许删除对象并使相关对象无效，以便自动重新验证。 （不再需要拆除对象堆栈）
*隐式转换。
DB2似乎是唯一实现SQL标准严格的DBMS
输入...
从改进NULL和参数标记处理到
，允许字符串和数字之间的比较或
字符串和数字：''你好''|| 5 => ''Hello5''
* SQL标准ARRAY类型
*某种全局类型变量
*某种背景 （如登录脚本）
*强化模式的概念
（或引入SQL标准模块）
*乐观锁定 ;
*暴露物理ROWID
* CS隔离而无需读者阻止编写者（反之亦然）
*快照隔离
* SQL PL以外的程序
（概括BEGIN ATOMIC .. END）
* INTERVAL数据类型
* Informix风格DATETIME
日期（每月一天）
或TIME（小时至MILLISOCOND）
* DECFLOAT数据类型（精确数字浮点数）
* BOOLEAN数据类型
* [VAR] BINARY数据类型
*将会话/服务器置于自动提交然后支持的方法
显式启动事务（可能是嵌套的）
*自治事务
* SQL函数中的完整SQL PL支持
*完整SQL触发器中的PL支持
*用户定义的聚合
* _CREATE_ GLOBAL TE MPORARY TABLES（比如DB2 zOS）
* TRUNCATE TABLE语句
嗯......有一件事是肯定的......总有工作......
干杯
Serge
-
Serge Rielau
DB2解决方案开发
IBM多伦多实验室
Dear IBM DB2 support,
I wish CLP would have been more functional. Without living the command
line I would like to get sql return code explanations, scalar function
definitions etc..
Looking forward to see CLP enhancements in v8.3
-mike
so*******@gmail.com wrote:Dear IBM DB2 support,
I wish CLP would have been more functional. Without living the command
line I would like to get sql return code explanations, scalar function
definitions etc..
Looking forward to see CLP enhancements in v8.3
DB2 V8.3? There will be no such thing.
Have you tried:
? SQL0204
in CLP. ? gives SQL CODE and SQLSTATE explanations.
SELECT TEXT FROM SYSCAT.ROUTINES WHERE ROUTINENAME = ''FOO'' and
ROUTINESCHEMA = ''SRIELAU''
Gives you function bodies (or do you mean something else?)
What is etc. ???
I''m collecting requirements for Viper+2, so go wild :-)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
"Serge Rielau" <sr*****@ca.ibm.com> wrote:
news:4d*************@individual.net...
I''m collecting requirements for Viper+2, so go wild :-)
Serge, I''m glad to here the such invitation. Could you make public the
currently collected wish list for Viper?
--
Konstantin Andreev.
Konstantin Andreev wrote:"Serge Rielau" <sr*****@ca.ibm.com> wrote:
news:4d*************@individual.net...I''m collecting requirements for Viper+2, so go wild :-)
Serge, I''m glad to here the such invitation. Could you make public the
currently collected wish list for Viper?
Well Viper is done and over...
But sure I can do a quick brain-dump of SQL-ish feature requests I''m
aware of (in random order) or ideas that I have on my own:
* row-comparisons (Bernard''s favorite)
CREATE TABLE T1(c1 int, c2 int);
SELECT * FROM T1 WHERE (c1, c2) > (?, ?)
* mySQL style OFFSET clause:
SELECT * FROM T FETCH FIRST 5 ROWS OFFSET 10
* improve schema evolution
e.g. allow objects to be dropped and invalidate dependent objects for
auto revalidation. (No more need to tear down the object stack)
* implicit casting.
DB2 appears to be the only DBMS that implements SQL standard strict
typing...
anything from improving NULL, and parameter marker handling to
allowing comparisons between strings and numbers or concatenation of
strings and numbers: ''Hello'' || 5 => ''Hello5''
* SQL Standard ARRAY type
* Some sort of "global" variable
* Some sort of "context" (like a login-script)
* Strengthening the concept of a schema
(or introducing SQL standard MODULES)
* "optimistic locking"
* Expose physical ROWID
* CS isolation without readers blocking writers (and vice versa)
* Snapshot Isolation
* SQL PL outside of procedures
(generalizing the BEGIN ATOMIC.. END)
* INTERVAL data type
* Informix style DATETIME
DATE(MONTH TO DAY)
or TIME(HOUR TO MILLISOCOND)
* DECFLOAT data type (exact numeric floating point)
* BOOLEAN data type
* [VAR]BINARY data type
* A way to put a session/server into auto-commit and then support
explicit start transaction (perhaps nested)
* autonomous transactions
* Full SQL PL support in SQL functions
* Full SQL PL support in Triggers
* user defined aggregates
* _CREATE_ GLOBAL TEMPORARY TABLES (like DB2 zOS)
* TRUNCATE TABLE statement
Well... one thing is for sure.. there is always work....
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
这篇关于在v8.3中实现更多功能性CLP的梦想的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
