Re: Embedded SQL does not work

[Chris.Spirinckx@xxxxxxxxxxxxxxxx (Chris Spirinckx)]

On Wed, 13 Jan 1999 12:49:51 -0000, you wrote:

>Hello!
>I am trying to do an update in a table B with data from table A, for that I 
>use a cursor. Here is the code:
>
>     IDSA         DS
>     I                                        1  10 FCTNA
>     I                                       11  11 CASSA
>     I                                       12  15 POSNA
>     I                                       16  65 FCDS
>     I                                       66  90 FCSD
< snip >

Silvio,

I've experienced a similar problem in V2R3 some years ago.
Apparently SQL wasn't working properly when using subfields.

I suggest that you define the fields in the "DSA" data structure as
separate fields ( by means of the "*like  DEFN" for example ) 

Hope this helps


Chris



          .                        \\|//                        .
 ._O_.   . ________________________(o o)________________________ .   ._O_.
/_\o/_\ .                    -oOOO--(_)--OOOo-                    . /_\o/_\
  /H\  .          live : Chris.Spirinckx@village.uunet.be          .  /H\
 (=O=).           ICQ  : 14033396                                   .(=O=)
   U .            work : chris_spirinckx@pee.pioneer.be              . U
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *