Re: RPG SQL precompiler

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Tom

That's a verrrrry eeeenteresting idea - to hide stuff like this.

Actually this was an accident - I'd brought some code in from another 
program - i've been dancing around some /copy members but they aren't 
useful for everything i've done here - maybe - or perhaps if I had 
more time I'd find a way - sigh!

LOL - there was no "want to" as far as exposing one or the other 
variable - I just thought I'd tell y'all what happened, so that if 
you get odd incorrect results from you embedded SQL, y'all could look 
for the problem in duplicate names that are hidden in things like 
F-specs or maybe external data structures.

Thanks
Vern

At 03:13 PM 6/20/2007, you wrote:

> Vernon Hamberg wrote:
> >    4. Re: RPG SQL precompiler (Vernon Hamberg)
> >
> > I just got bit by this "feature" of the precompiler - have a program
> > that has embedded SQL - when I put in  some SQL CLI stuff, to use a
> > stored procedure with result set in RPGLE, I got a message saying
> > that a certain column in a file was an invalid timestamp.
> >
> > The thing that broke it was when I declared a variable in a
> > subprocedure that had the same name as a column from a table used in
> > an embedded select statement - and I also had an f-spec for that
> > table. What happened is, the precompiler mapped the select field list
> > to positions in the input buffer - please don't correct me too hard
> > here if i'm a little off - it's close enough for me to solve the
> > problem - heh.
>
> Vern:
>
> This seems to be a potential spot for a /COPY member. Use /COPY (not
> /INCLUDE) for the proc statements. The pre-compiler shouldn't see the
> 2nd variable definition. No?
>
> Or was it the other way around -- you wanted it to see the variable from
> the proc rather than from the F-spec? Or it needs to see both at the
> same time -- global and local?
>
> Tom Liotta
>
> > When the variable with the duplicate name was present, that field was
> > completely omitted from the mapping that the precompiler did - and in
> > this case it moved what it thought was a timestamp to the start of
> > the field that should have been there - nasty, what?
>
> --
> Tom Liotta
> The PowerTech Group, Inc.
> 19426 68th Avenue South
> Kent, WA 98032
> Phone  253-872-7788 x313
>        253-479-1416
> Fax    253-872-7904
> http://www.powertech.com
>
> --
> This is the RPG programming on the AS400 / iSeries (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.