在 IBM Data Studio 中运行 SQL 查询的简单方法
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/14816329/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Simple way to run SQL queries in IBM Data Studio
提问by Udo Held
How can I run a simple query like:
我如何运行一个简单的查询,如:
select current timestamp from sysibm.sysdummy1
In the old "Command Center" if was simply able to run such a command without creating a script/project, using a query builder etc.. However the old command center was replaced with the new Data Studio during an update.
在旧的“命令中心”中,如果能够在不创建脚本/项目、使用查询构建器等的情况下简单地运行这样的命令。但是,在更新期间旧的命令中心被新的 Data Studio 替换。
I'm trying to reproduce an error that doesn't pop up when using my usual Aqua Data studio. However running the procedure with JDBC and/or the Data Studio throws an exception.
我正在尝试重现使用我常用的 Aqua Data 工作室时不会弹出的错误。但是,使用 JDBC 和/或 Data Studio 运行该过程会引发异常。
回答by sunny_dev
1) Open "Database Administration" perspective in data studio
1)在数据工作室中打开“数据库管理”透视图
2) To launch the SQL editor, go to Administration Explorer on the left panel and click New > New SQL Script (Refer screenshot below)
2) 要启动 SQL 编辑器,请转到左侧面板上的管理资源管理器,然后单击新建 > 新建 SQL 脚本(请参阅下面的屏幕截图)
This way you can run your normal sql queries without creating a script/project, etc. Please refer to IBM official site herefor more details.
这样,您就可以在不创建一个脚本/项目等运行正常的SQL查询,请参考IBM官方网站点击这里了解更多详情。