RE: embedded sql not compiling

["Schutte, Michael D" <Michael_Schutte@xxxxxxxxxxxx>]

Is that a space between the colon and variable?  Doesn't the space need to be removed?  Also try wrapping your select in parenthesis.  Personally, I've never tried to do it this way.  Change to do a select into statement.  

FYI, SET isn't just for an update.  I use this code all the time  Exec SQL set :myField = Lower(:myField);



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, November 18, 2010 6:12 AM
To: Midrange Systems Technical Discussion
Subject: embedded sql not compiling

Hi,

What's wrong with my statement?

             EXEC SQL
                SET : NSQNO = SELECT MAX(NSQNO) + 1
                FROM NPAI WHERE NENVCD = : wEnvCd AND NDOSNO = : wNoRf;

Here's an extract from the compile listing :

.+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+.
   SET : NSQNO = SELECT MAX(NSQNO) + 1               

                      MESSAGES DE DIAGNOSTIC         
TEXTE                                                
Position 38 Elément syntaxique MAX n'est pas correct.

Thanks.