In JBASE 5.1 with a debt collection software overlay, I have the following
I-type dictionary definition:
DICT DEBTOR PKT-ALL-PMT-DT
Top
001 I
002 TRANS("PACKET",PACKET,19,"X");TRANS("DEBTOR",@1,"51.1","X")
003 D2-
004 PKT-ALL-PMT-DT
005 20R
EOI 005
For conceptual background, in our collection system, a debtor may have a
number of different debts that are joined together in a "packet" by a
unique packet number. This definition reads the packet number for each
account, takes that packet number and reaches into the PACKET file, which
contains at attribute 19 a list of all accounts in the packet, then uses
those account numbers to reach into the DEBTOR file for each account, and
report back the contents of DEBTOR dictionary definition 51.1, which is a
date of last payment. I get back an array of dates consisting of the last
payment date of each account in the packet, in order of the list of
accounts in the packet. The array can vary greatly in the number of payment
dates reported.
What I would like to do is to sort that array and extract only the most
recent payment date from the array using I-type functions or expressions.
But I have not been able to find sufficient documentation on I-types and
I-descriptors to allow me to learn the functions well enough to do so. I
have tinkered with SORT and EXTRACT functions, but SORT places the array in
ascending order, earliest date first, and I don't know how to tell EXTRACT
to grab the last value in the array.
If anyone has any ideas for accomplishing this, I would appreciate any
suggestions. Or, if anyone is aware of a good reference source for I-types
and I-descriptors, which, as I understand it, have their roots in
PICK/Basic, were more fully developed in PRIME and Universe, and are only
partially integrated into JBASE, I would appreciate any leads in that
regard.
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
