Re: embedded sql, procedure, and report output

Very informative.
Stick with this - it's good to learn.
Jim Franz

To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Wednesday, October 26, 2005 3:49 PM
Subject: Re: embedded sql, procedure, and report output

  I had my code looking very similar to that without the activation groups

and can not get it to work on V5R2. I am about to give up and convert the

  program back to regular file access as I know it will work.  I wish this
  SQL stuff was easier(I know upgrade to V5R3 and it is!!), thanks

  rob@xxxxxxxxx wrote:

This compiles on my V5R3 machine
     h dftactgrp(*no) actgrp(*caller)
     FQSYSPRT   O    F   80        PRINTER
     D MySub           PR
     D ts              s               z
     C/exec sql
     C+ values current timestamp into :ts
     C/end-exec
      /free
       *inlr=*on;
       return;
      /end-free
     OQSYSPRT   E            H
     O                                           08 'DATE:'
     P MySub           B
     D MySub           PI
      /free
       return;
      /end-free
     P MySub           E

With TGTRLS set to *CURRENT, V5R2M0 or V5R1M0.

Rob Berendt


  --

  Weyco Group -

      Florsheim, Brass Boot, Nunn Bush, Stacy Adams
  Duane Kehoe                       Phone # 414.908.1814
  EC / Programmer / Analyst           Fax # 414.908.1601
                            Email: dkehoe@xxxxxxxxxxxxxx
--
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.