Re: RPG-SQL error

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

John,

Do STRDBG just before you run the application, then check the joblog.
Chance's are that you'll find your answer. If you don't, then set a
breakpoint in your program just after the SQL statement, and check the
SQLCODE. That should tell you exactly what's going on.


John Taylor
Canada

> -----Original Message-----
> From: jpcarr@TREDEGAR.COM [mailto:jpcarr@TREDEGAR.COM]
> Sent: Friday, April 27, 2001 8:02 AM
> To: RPG400-L@midrange.com
> Subject: RPG-SQL error
>
>
>
>
> Hey guys
>
> Has anyone one had this situation?
>
> SQL RPG program,   Compiled,   Everything works ok.
>
> When run against a different Library(same file name)  or Restored and run
> against a file and we get no results.
>
>
> So problems when restoring RPGSQL programs or Running against same file
> different library.
>
> Any thing ring a bell??
>
> John Carr
>


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