RE: When ILI file has "LZ" status??

["Lacelle, Marc" <LACELLE@xxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Hi Ho.

        Well believe it or not it snowed last weekend, not much, but the
darn stuff is back. I closed the swimming pool since the water temp was a
comfortable 43f.

        The old INV970D. DANGER DANGER DANGER. Only run prior month end.
NEVER RUN THE INV970D DURING MONTH. All users must be logged off. Here is a
little trick from Hi Ho.

Run these SQL Statements. Only after month end or before beginning of new
month.
DELETE FROM BPCSXXXF/ILI WHERE (LOPB + LRCT + LADJU - LISSU) Ð0.
DELETE FROM BPCSXXXF/IWI WHERE (WOPB + WRCT + WADJ - WISS) Ð0

These two statements will remove even more unwanted records.

        Hope this helps
Marc Lacelle
> ----------
> From:         Roy Smith[SMTP:bpcsusergroup0@yahoo.com]
> Reply To:     bpcs-l@midrange.com
> Sent:         Thursday, October 11, 2001 1:51 AM
> To:   bpcs-l@midrange.com
> Subject:      When ILI file has "LZ" status??
>
>
> Hello!!
> We are on BPCS 6.1.01, mix mode on AS400.
> We have thousand of records in ILI file, with
> lidÒLZ". In which condition record becomes "LZ",
> And what should we do to remove such records
>
> Thanks for any response!!!
>
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Make a great connection at Yahoo! Personals.
> http://personals.yahoo.com
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
> or email: BPCS-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>
>
__________________________________________________

The Royal Canadian Mint is proud to be among the "35 Best Companies to Work
For in Canada" in 2001, according to the Globe and Mail's Report On Business
Magazine.

La Monnaie royale canadienne est fière de se retrouver, pour l'an 2001,
parmi les «35 meilleures entreprises où travailler au Canada», selon la
revue Report On Business du Globe and Mail.