RE: embedded sql not compiling

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.