Re: HereDoc -- RPG400-L

× 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.

Yes, for static SQL. Unfortunately I needed to be able to use the set schema command, and that only works for dynamic SQL as discussed earlier on this list. I guess I was looking for a way to make dynamic SQL as nice as static SQL has become recently.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx

-----rpg400-l-bounces@xxxxxxxxxxxx wrote: -----
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
From: Joe Pluta
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
Date: 01/20/2011 12:45PM
Subject: Re: HereDoc

On 1/20/2011 11:22 AM, Mark Murphy/STAR BASE Consulting Inc. wrote:

The goal is to put a fully formed SQL statement in the source in context
so that it can be easily read and understood in that context rather than
shuffled off to some other location where I would have to go and find it
while going through the code. A list of all the SQL statements used in
the program placed in a compile time array does not achieve that goal. The
quoted string does a better job, just not very prettily. I have a
workaround to the lack of HereDoc support, it just isn't very pretty. I
guess that this is all it is about.

Isn't that exactly what embedded SQL does?

Joe

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.