RE: dynamic embedded SQL

What about PTF's. And also DB2 Group PTF SF99103 on V4R3.


-----Original Message-----
From: Erick Garske [mailto:erick@formationmg.com]
Sent: Thursday, June 29, 2000 1:17 AM
To: midrange-l@midrange.com
Subject: dynamic embedded SQL


I have an issue with a dynamic embedded SQL statement within an RPG program.
When I compile and test the program on a development machine, the code works
correctly. When I send the program out to another machine, the code does not
work correctly. The program was generated using V4R4 but compiled to a
target release of V4R3. The other machine is at V4R3.

The compile options used for V4R4 are:

COMMIT(*CHG) and RDB(*NONE)

Does anyone have any idea what could be wrong?

Thanks in advance,

Erick

 C                   ExSr      BuildSQL

  * Construct the SQL statement that sets all flags on that
  * satisfy the criterion specified by the user
 C                   Move      s1proc        procval
 C                   Eval      SqlStmStr =   'UPDATE FRMPPOF '
 C                                         + 'SET VRPROC = '
 C                                         + procds
 C                                         + ' WHERE '
 C                                         + %Trim( Selection )
  * Use dynamic embedded SQL to execute this statement
 C/Exec SQL
 C+  EXECUTE IMMEDIATE :SqlStmStr
 C/End-Exec



Erick Garske
Programmer/Analyst

Phone: (949) 598-8890 x 108
Fax: (949) 598-8899
mailto:erick@formationmg.com
http://www.formationmg.com

Eliminate the cost of preprinted forms and checks forever


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