[WEB400] Net.Data Error Question

[Diane Nott <dnott@xxxxxxxxxxxxx>]

a. are numeric fields (all field ending in ID are numeric) the rest are 
character fields
c ,d, e are character fields

I changed the quotes around to these and then got a complete different 
error message:
%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
%}
%REPORT {
%ROW {

Error Message Generated. Doesn't even reach my output html.
NET.DATA DTW_SQL Error: Function function1: The statement failed. Column 
"111067" not in specified tables. (SQLSTATE 42703, SQLCODE -206)

Diane

web400-request@xxxxxxxxxxxx wrote:

> date: Mon, 21 Jul 2003 12:20:54 -0400
> from: "Peter Vidal" <Peter_Vidal@xxxxxxxx>
> subject: Re: [WEB400] Re: Net.Data Error Question
>
> I do not know your file record layouts but my recommendation is to revise the
> comparisons:
>
> a) (bwnmid=c3nmid)
> b)  BWNMID = '$(CGIINP03)'
> c) BWCQAA = '$(CGIINP01)'
> d) BWCMAA = '$(CGIINP02)'
> e) BWLOAA = "CR"
>
> Confirm that these data fields are the same type in between.  I have had
> problems in the past using a single quote over a numeric field and it explodes
> in my face when comparing a numeric field with a "string".... you know what I
> mean?
>
> I am just a rookie on these realms but I hope you can resolve this ASAP.
>
> Best regards,
> Peter Vidal