Re: (SQL) problems during select (QRY2283)

["Desta, Wes" <DESTAW@xxxxxxxxxxxxxxxxxxx>]

Yivi,

What is the actual HEX value in that filed? 


Wes

"Yivi" <nardus-Re5JQEeQqe8AvxtiuMwx3w@xxxxxxxxxxxxxxxx> wrote in message
news:<d8e67ab40603022332r34a3ccban8477fc3e15fdb0b1@xxxxxxxxxxxxxx>...
> >
> > Why can't you correct the file contents?  You have an externally
described
> > file with corrupt data, and you want to leave it that way?
> 
> No, I don't want to, but I have to earn the right to change this things
over
> here.
> 
> I already alerted people of the problem, but until it escalates to the
right
> person, the problem is evaluated, and time is assigned to actually be
> actually fixed some time may pass. I'd like to continue with my
application
> regardless.
> 
> I am still the new guy at the company, the youngest one around, and a most
> obvious newbie at iSeries. I wasn't confronted with these 'old time' files
> and programs until today.
> 
> 
> >  1) Write a RPGLE program using FIXNMR(*INPUTPACKED) to process the file
> > one
> >
> Again, time to show my newbieness. What's "FIXNMR"? Searched for it but
> found no results.
> 
> 
> >  2) Attach a trigger to the file using *BEFORE and *ALWREPCHG then have
it
> 
> Sounds like a great idea. Whenever I am allowed to, I'll try to put in in
> practice; or I'll pass it along to whomever takes care of it.
> 
> 
> > However, for this to continue to occur, it implies the rogue program(s)
> > are
> > either using program-described files or file level checking has been
> 
> Program described files it is.
> 
> 
> > Have you tried IS NOT NULL. I'm not sure if it would fix it but it's
worth
> > a
> > try...
> 
> Yes, it was one of my first ideas. It didn't work. :(
> 
> And neither did this:
> 
> > I would try derivations of the following.
> >        HEX(ANOVTO) <> x'40404040' and ANOVTO >= 2006
> 
> 
> 
> 
> > What happens if you create a view where ANOVTO is a character field?
> >
> I will give it a try today. Not feeling overly optimistic, but the idea
> deserves a chance! :)
> 
> Best regards everybody,
> 
> I.-
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L-Zwy7GipZuJhWk0Htik3J/w@xxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request-Zwy7GipZuJhWk0Htik3J/w@xxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
>