RE: Running SQL commands from CL (or elsewhere)

Often this sort of interface includes everything but select, can you
make a test table and then try to update it?

Chris

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Nathan Andelin
Sent: Monday, June 05, 2006 3:39 PM
To: Midrange Systems Technical Discussion
Subject: Re: Running SQL commands from CL (or elsewhere)

I could use an example too.  When I tried a simple Select statement the
command responded with an SQL CLI error in referencing the table name.
The table was in a library that was in my library list before evoking
the QSH command, but there must be more to it than that.  I tried using
a qualified library/table name in the Select statement, but that didn't
work either.

Nathan.



----- Original Message ----
From: Michael Ryan <michaelrtr@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Monday, June 5, 2006 10:27:29 AM
Subject: Re: Running SQL commands from CL (or elsewhere)

Um..yeah...

QSH cmd('db2 "sql command"')

On 6/5/06, fbocch2595@xxxxxxx <fbocch2595@xxxxxxx> wrote:

Any examples of how to run these commands from a CL?