× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: RE: CL & SQL
  • From: "Gokhan Yildirim (Garanti Teknoloji)" <GokhanY@xxxxxxxxxxxxxx>
  • Date: Wed, 9 May 2001 12:25:43 +0300

Yes, there is a way to do this. You should write SQL Statements into source
and later using with RUNSQLSTM command...

-----Original Message-----
From: Martin Rowe [mailto:martin@dbg400.net]
Sent: Wednesday, May 09, 2001 10:10 AM
To: MIDRANGE-L@midrange.com
Subject: Re: CL & SQL


On Tuesday 08 May 2001 22:43, you wrote:
> Hi All,
>
> I'm new to imbedded SQL.  Can SQL statements be executed from within a
> CL program and if so, what resource should I be looking for to guide me
> in how to do it.  Thanks.
>
> Buzz Fenner
> mailto:bfenner@jonesborocwl.org

Hi Buzz

I don't think there is a CL equivalent to SQLRPG, but there are a few 
options for running SQL from a CL. As long as you have Query Manager (the 
existance of STRQMQRY & CRTQMQRY commands should show that) you can use 
the RUNSQLSTM command to run an existing SQL statement held in a source 
member. An alternative is to use a third party tool that accepts an 
ad-hoc SQL request as a command parameter. There are a few of them around 
including my own EXCSQL (see the Extras section on my home page - see 
.sig below) that do this fine. It supports output (if any) to screen, 
report or *OUTFILE.

Regards, Martin
-- 
martin@dbg400.net / jamaro@firstlinux.net
http://www.dbg400.net  DBG/400 - DataBase Generation utilities 
Open Source test environment tools for the AS/400 / iSeries and 
miscellaneous database & spooled file management commands.
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.