MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » December 2013

Re: strsql or iNav sql - how to see sqlca detail for errors



fixed

I would not expect to see SQLCA in either interface - that is for embedded SQL only - not in these interfaces. I mean, it may be there, but you won't see it when it's part of another program.

In STRSQL you may see one message - but there might be others preceding it in the job log - here's my suggestion - in STRSQL, cursor to the message and press F1. From there, press F10 - this should take you to the job log.

Let us know of any earlier related messages - they'll be immediately ahead of this one.

HTH
Vern

On 12/3/2013 3:15 PM, J Franz wrote:
Trying to debug a sql statement (normally executed in a c# client using OLEDB connection),
but I copied into STRSQL and also tried iNav.
SQL insert statement, and over a hundred columns - rcv a sql0420 about invalid characters in cast...
but no mention of which column.
Joblog has same generic msg.
I was thinking sqlca data structure like I use in SQLRPGLE might show what I need, but cannot see how to specify & view in either STRSQL screen or iNav Run SQL Statements.
Jim Franz






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 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