Menu
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.
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.
228
On the toolbar of the Administration Explorer, click the downward-pointing arrow next to the New button. Select New SQL Script from the menu. In the blank space of the Script<x>. sql workspace that opens on the upper right, type or paste the SQL statement.
1) Open "Database Administration" perspective in data studio
2) To launch the SQL editor, go to Administration Explorer on the left panel and click New > New SQL Script (Refer screenshot below)
This way you can run your normal sql queries without creating a script/project, etc. Please refer to IBM official site here for more details.
166
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
