RE: Embedded Sql problem

Mike,

Have you tried running STRDBG, before running your embedded SQL program. SQL
will then write lots of diagnostic messages to the joblog if you do this.

Cheers
Colin.W

-----Original Message-----
From: Rick DuVall [mailto:R_C_DuVall@xxxxxxxxxx] 
Sent: 20 January 2004 15:02
To: Midrange Systems Technical Discussion
Subject: RE: Embedded Sql problem


Hi Mike,

        I had that problem once and it was an error returned (sqlcod) that
was ignored by the interactive sql but caught by my program.  did you check
the sqlcod after running your embedded statement? what did it show?

regards

Rick DuVall
Systems Manager
Dealer's Auto Auction of Okc, Inc.
Rick@xxxxxxxxxx <mailto:Rick@xxxxxxxxxx>
(405) 947-2886

On Behalf
Of Smith, Mike
Sent: Tuesday, January 20, 2004 7:28 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Embedded Sql problem


I have a SQL statement that i developed using interactive SQL.  I get the
results that i'm looking for.  I then took this SQL and embedded it into an
RPG application. I no longer get the results that I am expecting.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

This e-mail has been sent by a company of Bertram Group Ltd, whose registered 
office is The Nest, Rosary Road Norwich NR1 1TF.
This message, and any attachments, are intended solely for the addressee and 
may contain privileged or confidential information.  If you are not the 
intended recipient, any disclosure, copying, distribution or any action taken 
or omitted to be taken in reliance on it, is prohibited and may be unlawful.  
If you believe that you have received this email in error, please contact the 
sender immediately.
Opinions, conclusions and statements of intent in this e-mail are those of the 
sender and will not bind a Bertram Group Ltd company unless confirmed in 
writing by a director independently of this message.
Although we have taken steps to ensure that this email and any attachments are 
free from any virus, we advise that in keeping with good computing practice the 
recipient should ensure they are actually virus free.