Yet we were told that by your having "put the AND there <ed: where I
saw you needed an AND> and formatted again - it went fine." Thus if
what was implied by that commentary is true, then indeed, we know the
formatter used will not be useful to diagnose the improperly qualified
column references.? That is not to say "I told you so", but to
emphasize that any particular SQL /formatter/ might not be capable of
diagnosing problems with the DB2 for i SQL syntax... so the actual
database parser and syntax checker may be effectively required.
On 15 Sep 2013 12:27, Vernon Hamberg wrote:
We don't know WHERE the OP put the missing AND - so we can't speak--
to whether the formatter was useful or not.
On 9/15/2013 2:16 PM, CRPence wrote:
On 15 Sep 2013 10:14, Vernon Hamberg wrote:
I put the AND there and formatted again - it went fine.
And that proves, that SQL formatter, is not entirely helpful with
regard to resolving the SQL5001 error :-(
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact