RE: SQL Finding & Using

["Leibowitz, Larry" <Larry.Leibowitz@xxxxxxxxxxxxxxx>]

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 

***************************************