Re: RE: Embedded SQL does not work

[Brian.Johnson@xxxxxxxxxxxxxxx]

O.K.  I'll give it a try.  Here's part of the text for message SQL7008:

Message ID . . . . . . . . . :   SQL7008
Message file . . . . . . . . :   QSQLMSG
  Library  . . . . . . . . . :     QSYS

Message . . . . :   &1 in &2 not valid for operation.
Cause . . . . . :   The reason code is &3:

You should be seeing this message in the job log.  The reason code
identifies the specific condition causing the error.

Brian Johnson
Software Engineer
Help/Systems, Inc.
brian.johnson@helpsystems.com
www.helpsystems.com
(612) 933-0609


> From: Silvio Santos [mailto:Silvio.Santos@biw-ag.de]
> Sent: Wednesday, January 13, 1999 7:50 AM
> To: 'RPG400'
> Subject: Embedded SQL does not work
>
>
> 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:
>
..
>
> But the update is not working. I also tried to run the debug an I saw
that
> the sqlcod is with the value = 0 before the update, but after it contains
> -7008,





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *