Re: Report help
- From: docdwarf@xxxxxxxxx ()
- Date: Wed, 22 Nov 2006 01:58:40 +0000 (UTC)
In article <8b73d$45639f43$454920f8$1954@xxxxxxxxxxx>,
LX-i <lxi0007@xxxxxxxxxxxx> wrote:
jeff@xxxxxxxxxx wrote:
Does anybody have a good routine I can use to calculate 50 days prior
to todays-date. This will be used for an AR report and I want to be
able to list accounts that have balances over 50 days.
You've gotten some COBOL replies on this. You might also see if however
you're pulling the data can be constrained (i.e., including a date in a
SQL "where" clause).
This is something that I'm teaching my Tech Lead on my present contract.
While I make sure the Olde Stuffe keeps running he's learning PeopleSoft
and SQL for the first time in a 12-year-or-so COBOL career... one of the
things I pointed out was that in a COBOL program one quite often first
gets a record and then applies the edits... all right, now I've got data,
let me see if it matches the conditions for processing.
It may be useful, on the other hand, to think of SQL as establishing the
conditions first and *then* getting the data which satisfy them... oh, and
you have to learn to read the queries from the inside outwards, as well.
DD
.
- Follow-Ups:
- Re: Report help
- From: LX-i
- Re: Report help
- References:
- Report help
- From: jeff
- Re: Report help
- From: LX-i
- Report help
- Prev by Date: Re: Report help
- Next by Date: Re: CICS and COBOL reentrancy was Re: Further discussion on "Something has to be maintained" and lack of OO acceptance.
- Previous by thread: Re: Report help
- Next by thread: Re: Report help
- Index(es):
Relevant Pages
|
|
