Re: SQL Finding & Using

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

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 
>
> *************************************** 
>
>  
>