We just upgraded to V5R3 and we are having trouble with a couple of 
queries that are using a logical file (which is a separate topic) that has 
RENAMEd fields in it.  If we remove the RENAMEs from the *LF, the query 
works OK.  These queries have always worked well; this is the first time 
they fail.

Message . . . . :   Field ITNBR not found in file *N in *N.  
Cause . . . . . :   Field ITNBR from query format @HISTIF could not be 
found 
  in file *N in library *N format *N join reference 0.  If the file name 
is 
  *N, the field was not found in either the query record format or the 
queried 
  file formats. If the file name is *FUNCTION, the file was user-defined 
table 
  function *N in library *N.  


Physically, the field is ITNBR but in the logical is RENAMEd to AAA123. 

Any reasons why I have this with V5R3?

TIA,

Peter Vidal 
PALL Corporation / SR Programmer Analyst, IT Development Group
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"Courage is the strength or choice to begin a change. Determination is the 
persistence to continue in that change." 
-- Anonymous --

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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

This mailing list archive is Copyright 1997-2024 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.