call of sqls

[Ina Schmitz]

Hello,

is there any possibility to call a .sql-file directly by giving the path of
the file instead of copying the whole content of the file to the editor of
db2 (I am using ibm db2 universal database 8.2)?
In Oracle, there is the syntax @'path to the sql' for that. Is there an
equivalent for db2?

Thanks a lot in advance for help.

Cheers,
ina

[Knut Stolze]

Ina Schmitz wrote:

Hello,

is there any possibility to call a .sql-file directly by giving the path
of the file instead of copying the whole content of the file to the editor
of db2 (I am using ibm db2 universal database 8.2)?
In Oracle, there is the syntax @'path to the sql' for that. Is there an
equivalent for db2?

db2 -f /path/to/file

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Ina Schmitz]

Hello again,

db2 -f /path/to/file

Thanks for the answer. Unfortunately, I didn't succeed in using this yet.
Where exactly do I have to type this command? I typed it in the
"Befehlseditor" of DB2 (sorry, I don't know the exact translation for this).
Do I have to start anything else than "db2start" before?
I got the following message:
"SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu
den
möglichen Token gehören: "SELECT". SQLSTATE=42601
SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu den
möglichen Token gehören: "SELECT".
[...]"
So I suppose, that in the "Befehlseditor" only select commands could be
executed?

Could you please tell me some online documentation about this? I didn't find
anything in the db2 online help to this topic.

Thanks a lot!
Cheers,
Ina

[Serge Rielau]

Ina Schmitz wrote:

Hello again,

db2 -f /path/to/file

Thanks for the answer. Unfortunately, I didn't succeed in using this yet.
Where exactly do I have to type this command? I typed it in the
"Befehlseditor" of DB2 (sorry, I don't know the exact translation for this).
Do I have to start anything else than "db2start" before?
I got the following message:
"SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu
den
möglichen Token gehören: "SELECT". SQLSTATE=42601
SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu den
möglichen Token gehören: "SELECT".
[...]"
So I suppose, that in the "Befehlseditor" only select commands could be
executed?

Could you please tell me some online documentation about this? I didn't find
anything in the db2 online help to this topic.

The command noted by Knut invokes the "Befehlseditor". So you do it from
the shell.You can try:
!db2 -f ...
The bang (!) is used to initiate a system call from CLP.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[shiggy]

Ina Schmitz wrote:

Hello again,

db2 -f /path/to/file Thanks for the answer. Unfortunately, I didn't succeed in using this

yet. Where exactly do I have to type this command? I typed it in the
before this try: db2 connect to :)))

and then use: db2 -t -f path
option -t means that statements are terminated with ; .
"Befehlseditor" of DB2 (sorry, I don't know the exact translation for this). Do I have to start anything else than "db2start" before?
I got the following message:
"SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu den
möglichen Token gehören: "SELECT". SQLSTATE=42601
SQL0104N Auf "ANWEISUNG-ANFANG" folgte das unerwartete Token "db2". Zu den möglichen Token gehören: "SELECT".
[...]"
So I suppose, that in the "Befehlseditor" only select commands could be executed?

Could you please tell me some online documentation about this? I didn't find anything in the db2 online help to this topic.

in db2 command prompt type ?<enter>, also if db2 reports SQLXXXXN error
you
can try

db2>? SQLXXXXN and you will get detaild explanation of error with
possibile solution..