RE: dynamic embedded SQL

["Dave Miller" <dlmiller@xxxxxxxxxx>]

programs with imbedded SQL also have an object called a package created
automatically when the program is created.  Move the program to the target
system and run crtsqlpkg to recreate the package.  A package contains the
sql instructions that will be executed when the program runs.



> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of Erick Garske
> Sent: Wednesday, June 28, 2000 3:17 PM
> 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
+---