So write an RPG stub, put the SQL in it and test it there!



"J Franz" wrote in message news:mailman.1293.1386105360.2717.midrange-l@xxxxxxxxxxxx...

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

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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 on our policy page. If you have questions about this, please contact [javascript protected email address].