RE: SQL pre-compiler & the new Template keyword

Interesting. I suppose one caveat is that these are procedure parameters defined like template data structure subfields. Are you doing that as well?

Thanks,
Kurt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Campin
Sent: Tuesday, April 05, 2011 2:40 PM
To: RPG programming on the IBM i / System i
Subject: Re: SQL pre-compiler & the new Template keyword

It was at V6R1. I do it all the time

On Tue, Apr 5, 2011 at 10:53 AM, Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx

wrote:

Does anyone know if we can expect the SQL pre-compiler to be updated
any time soon to allow for the use of variables that have been defined
like a variable/DS that has the Template keyword specified? We use
the Template keyword a lot. Most of our file encapsulated service
programs include a template of the file in the copybook that the
service program uses for defining pretty much all variables related to
the file (and for prototypes, which is why it's in the copybook).

I'm taking a stab at creating a file encapsulated service program
using SQL instead of native I/O and quickly discovered that the SQL
pre-compiler is not a fan of templates.

I'm at IBM i 6.1.

Thanks,
Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.