× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. June 2006

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?

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.