I am investigating the possible use of AIF:Procedure Exits to trap
calls to DBUPDATE on our production data bases in order to capture
"before" and "after" images of data set modifications for (almost)
real-time updating of a Microsoft SQL Server data warehouse which
summarizes the Image data.
According to the AIF:PE documentation, AIF:PE handlers can only
contain references to routines in NL.PUB.SYS, not XL.PUB.SYS. Since
the TurboImage routines all reside in XL.PUB.SYS, it would appear
that a DBUPDATE handler could not call DBGET to get a "before" image
of the data set that is being updated.
Am I out of luck trying to write AIF:PE handlers that make TurboImage
calls? Or is there a work-around, such as copying the TurboImage
modules from XL.PUB.SYS to the UDSL containing my AIF:PE handlers?
John Schick
Manager/Technical Support
Times Mirror Higher Education Group