|
If you want to stay with a file structure, I would suggest you use a
database trigger program. You can set a program to be called based on a
write to any AS/400 file. The trigger time (before, or after the action
has completed), the operation (Insert, Update, Delete...) is passed as
well as the value(s) of the record. Your program could decide what to do
based on which action and data being passed and act accordingly.
I have used Data Queues for many years and have not had a problem
exceeding the number of records in a data queue. As long as the
job(s)/program(s) to process the data queue entries are sufficient to
keep the number of records low, you should be safe. In addition, when
you create your data queue(s), you have the option of forcing them to
disk. The maximum record length for a data queue is 64,512 characters,
and I haven't seen a number of records recently, but I regularly have
them in the 100,000 range.
|