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




As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.