RE: embedded sql not compiling

I don't know what is wrong with your statement but why don't you use INTO?

exec sql SELECT MAX(NSQNO) + 1
INTO :NSQNO
FROM NPAI WHERE NENVCD = : wEnvCd AND NDOSNO = : wNoRf;

Mihael


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Thursday, November 18, 2010 12:12 PM
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.