RE: dynamic SQL in RPG

[rob@xxxxxxxxx]

In most places I have replaced my use of SQLCOD with SQLSTT.  HOWEVER 
there are a few places where more than one SQLCOD is equal to the same 
SQLSTT.  And in one application I performed a different operation based on 
which of the two SQLCOD's I received.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Wills, Mike N. (TC)" <MNWills@xxxxxxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
04/01/2004 09:20 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: dynamic SQL in RPG






What is the difference between SQLSTT and SQLCOD?  I have always used 
SQLCOD
then if it is +-100 (don't remember which) then there is no results, if it
is 0 everything is okay, if it is anything else, then there is a problem.

Mike Wills
Lawson Programmer/Administrator
Taylor Corporation
Email: mnwills AT taylorcorpNOSPAM DOT com
AIM: iSeriesCodePoet

-----Original Message-----
From: Buck

Two suggestions:
1) In debug, look at sqlstatement to make certain there is a properly 
formed
statement.  I catch a lot of my oopsies this way.
2) Check the value of SQLSTT after the PREPARE FROM:

C/EXEC SQL
C+ PREPARE S1 FROM :sqlstatement
C/END-EXEC

if sqlstt <> '00000'
// uh-oh...

There is an example of dynamic SQL in the FAQ at http://faq.midrange.com
Search for 'indirect'

  --buck



_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, 
or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.