The very basic command is:

db2 -f<input_file>

And if you want the output in a file:

db2 -f<input_file> -z<output_file>


-----Original Message-----
From: B1B2
[mailto:db2udbdba-ezmlmshield-x30441251.[Email address protected]
Sent: Wednesday, May 31, 2006 3:15 PM
To: LazyDBA Discussion
Subject: How to run a SQL script ...


Hi all,

Very new to DB2 and am already tasked to write a script .... can someone

tell me what command to run to execute a SQL script from DB2>. That is,
if I need to run a script like SELECT X FROM TABLE that is saved in a
file, how do I run that via DB2 ....

Just want to know the basics for a start, unfortunately not enough to do

RTFM at the moment ...

Thanks in advance ..




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page