RE: SQL Finding & Using

["Len Grieco" <l_grieco@xxxxxxxxxx>]

All,
	Thank you for all of your responses.  From what I'm reading we need to purchase the development kit.  As for what/why we are looking to SQL, well we used to be a COBOL shop with all in-house home grown apps.  We are in the process of switching to LANSA and have an outside contractor helping us.  He says he/we can be much more productive with SQL.  For as long as I have been here 10+ yrs, we have always used a third party software to get/change/manipulate our data.  
Thanks again for everyone's help
Len  

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of DeLong, Eric
Sent: Thursday, September 20, 2007 2: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 

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