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

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