[WEB400] Re: Net.Data Error Question

[Diane Nott <dnott@xxxxxxxxxxxxx>]

NET.DATA DTW_SQL Error: Function function1: The statement failed. 
Comparison operator = operands not compatible. (SQLSTATE 42818, SQLCODE 
-401)

Here is also part of the SQL function:
%FUNCTION(DTW_SQL) function1() {
 SELECT BWNMID, BWCQAA, BWCMAA,
   BWOKAX as PTFT, BWLOAA as CR, C3U2A2 as disable,
   SDIGAA as hrsenroll
 FROM XXXCMFIL.NSLTRL0
      INNER JOIN XXXCMFIL.BIOMSL0 ON (bwnmid=c3nmid)
      INNER JOIN XXXCMFIL.STMSML0 ON (bwnmid=sdnmid)
 WHERE BWNMID = '$(CGIINP03)' and BWCQAA = '$(CGIINP01)' and BWCMAA = 
'$(CGIINP02)'
       and BWLOAA = "CR"
%MESSAGE {
100:{@dtw_assign(ret_cde,"1")%}:continue
%}

I hope you can help.
Diane

> date: Thu, 17 Jul 2003 15:06:27 -0400
> from: "Peter Vidal" <Peter_Vidal@xxxxxxxx>
> subject: Re: [WEB400] Net.Data Error Question
>
>
> "I am new to Net.Data. I get this error code -407. What does it mean?
> Also, I created a Net.Data group at yahoo groups for anyone interested.
> Diane"
>
> There is not enough data, nor message -407 appeared in the Net.Data Error
> Messages List.   Can you sent us the whole error message?
>
> Peter Vidal
> Pall Aeropower Corp.
> SR Programmer Analyst
> WWW.Pall.com / 727-539-8448, x2414