Re: Embedded SQL problem

[Ravi Viswanathan <ravi@xxxxxxxxxxxxx>]

Roger,

SQL error message descriptions are in message file QSYS/QSQLMSG.  A reason  code
is probably associated with SQL7008. You can find specific info in the message
file based on the msg id & reason code.

Ravi

Roger Boucher wrote:

> I am trying to debug a vendor's program with embedded SQL and I regret
> to say I have never had the opportunity to learn how this works.   I am
> using ISDB/400 (IS Debug) and can not follow the lines of code where it
> is executing SQL.  I know that no records are being loaded to the
> subfile and the reason is an "SQL code" of -7008.  Does anyone know what
> this means, or how I might be able to debug the SQL executable
> statements?
>
> P.S.  The Select string that is being built by the application before
> heading into the SQL executable statements is valid and selects the
> proper records when run through STRSQL.
>
> Thanks for any help!
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---