Re: IBM Data Studio - SQL script

Newsgroups	comp.databases.ibm-db2
Date	2018-08-12 09:50 -0700
References	<0e1db43c-ab55-476e-802f-fa91c6373122@googlegroups.com>
Message-ID	<ba6c8bbd-7124-455e-97a4-7e7cefa0a36b@googlegroups.com> (permalink)
Subject	Re: IBM Data Studio - SQL script
From	Joachim Tuchel <jtuchel@objektfabrik.de>

Show all headers | View raw

There is not much point in issueing an SQL statement "into the universe". You need a table to select/insert/delete/update from/into (DML) or a database to make any changes to (DDL).

The few exceptions that come to mind are create and/or drop database, force application or start/stop DBM. In Data Studio, you can do that visually in the left pane, but afaik not per SQL script. You still need to be talking to an existing DB Server or Instance.

Joachim



Am Sonntag, 12. August 2018 03:59:24 UTC+2 schrieb SANDRO HAIDEN TEIXEIRA:
> Regarding IBM Data Studio 4.1.3 Client, do I really need to be connected to a database in order to run an sql script?
> 
> Because when I want to create another database through the script, Data Studio requires me to connect to a database. Is there any way to disable this requirement?
> 
> grateful for the attention.

Back to comp.databases.ibm-db2 | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

IBM Data Studio - SQL script SANDRO HAIDEN TEIXEIRA <sandrohc2010@gmail.com> - 2018-08-11 18:59 -0700
  Re: IBM Data Studio - SQL script Joachim Tuchel <jtuchel@objektfabrik.de> - 2018-08-12 09:50 -0700
  Re: IBM Data Studio - SQL script mikeodba@yahoo.com - 2018-09-27 02:01 -0700
    Re: IBM Data Studio - SQL script "Peter H. Coffin" <hellsop@ninehells.com> - 2018-09-27 10:10 -0500

csiph-web