Re: RPG SQL precompiler

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.