Easy way to run SQL queries in IBM Data Studio

Question

How can I run a simple query, for example:

select current timestamp from sysibm.sysdummy1 

In the old "Command Center", if he could just run such a command without creating a script / project, using the query builder, etc. However, the old command center was replaced by the new Data Studio during the upgrade.

I am trying to reproduce an error that does not appear when using my regular Aqua Data studio. However, executing the procedure using JDBC and / or Data Studio throws an exception.

Answer 1

1) Open "Database Management" in the data studio

2) To start the SQL editor, open Explorer in the left pane and click New> Create SQL

This way you can run your regular SQL queries without creating a script / project, etc. Please refer to the official IBM site here for more details.