Re: iSphere source file search issue

Charles,

Of course there is nothing to add regarding to SQLCODE/SQLSTATE. I am as
sure as I could be that also the OD (original developer) knows about
that. He might not payed attention for it in FNDSTR, because he might
rated SYSTABLES as "rock solid".

Regards,

Thomas.

Am 21.10.2015 um 01:26 schrieb CRPence:

On 20-Oct-2015 11:01 -0500, Tools/400 wrote:

On 20-Oct-2015 03:22 -0500, James Evans wrote:

When I run a search over a simple 4 letter string it falls over on
this line

LILINE = %SubSt(SRCDTA : LISTR : LILNG);

<<SNIP>>

It seems as if your SYSTABLES file in QSYS2 does not return a row for
your source file <<SNIP>>

FWiW, one might expect that a failure to find a "row for your source
file" would be exposed at that point in time; i.e. when\because the
SELECT ... INTO ... did not return a row, then an error would be
manifest in response to the sqlcode\sqlstate immediately after the
query, instead of allowing a number of lines of later code to operate
against the effective garbage-in established for the values of the
host-variables?