Re: HereDoc

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