RE: SQL Finding & Using

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

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