× 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.



Larry,

There may be more than one way to skin a cat, but the easiest way that I've found is drill down to the Databases...Schemas...

"Run an SQL Script" is an option in the Task Pad at the bottom. If you don't have the Task Pad available, set it through the View menu option.


* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Leibowitz, Larry wrote:
How do you get to the "iSeries Navigator's Run SQL Script facility" I am
in our Navigator and can not find it?
TIA

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
Sent: Thursday, September 20, 2007 3:13 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Finding & Using

Len, you did say administration right? Even without the SQL Development Kit you can use RUNSQLSTM command to
process SQL statements listed in the source member. Multiple statements
are
separated by a semicolon.

An easier route for a novice though is iSeries Navigator's Run SQL
Script
facility. This comes free of charge with the purchase of the system so
you
already have this.

Elvis

RPG & DB2 Summit | Minneapolis | October 1-4
Mike Cain - DB2 for i5/OS Temporary Indexes - The Good, The Bad, The
Ugly
October 16 2007 System i Fall Technical Conference | Orlando | November 4-7
Celebrating 10-Years of SQL Performance Excellence on IBM System i,
eServer
iSeries and the server affectionately known as the AS/400
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DeLong, Eric
Sent: Thursday, September 20, 2007 1:43 PM
To: Midrange Systems Technical Discussion
Subject: RE: SQL Finding & Using

More to the point, the SQL runtime is a standard part of OS400.
Programs
developed with the SQL development tools can be restored to any box and
run
as expected.
The SQL development tools are a chargable feature.
Even without the SQL development tools, you can potentially use the
SQL-CLI
api's, or the Process Extended Dynamic SQL api.... This can be a
difficult
way to get started, but a few well-designed service programs can quickly
take the pain out of this...
Can you discuss your shop's intent? If this is a modernization
initiative
(developer roadmap), then I'd recommend purchasing the development tools
to
help maximize your developer's productivity.

hth,
Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
Sent: Thursday, September 20, 2007 1:22 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Finding & Using


the SQL software is a separate package and you'll have to purchase it.

Thanks,
Tommy Holden



"Len Grieco" <l_grieco@xxxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/20/2007 01:18 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<MIDRANGE-L@xxxxxxxxxxxx>
cc

Subject
SQL Finding & Using






All,
I have been given the task of implementing the use of SQL. Forgive
me if I do not fully state my question correctly, I'm am a rookie when it comes to systems administration. We have a 270 running v5r4. I was
told that SQL comes with the system? Can some one point me to any documentation/manuals... that can help me find/use this. I used
DSPSFWRSC and GO LICPGM opt 10, but could not find anything relating to SQL

Thank you
*************************************** Len Grieco iSeries/LANSA Programmer
William S. Hein & Co., Inc. 1285 Main Street Buffalo, NY 14209 Phone (716) 882-2600 Ext. 131 Fax (716) 883-8100 l_grieco@xxxxxxxxxx
***************************************


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.