Q: Programs: Inserting database information in spool files.

Question:
I have a database containing customer information. I want to condition what to do with spool pages for specific customers

depending on information in my database. Can Interform400 do that?

Answer:
Yes. Using a split definition will enable the use of exit programs.

Using this program you can send data from your spool file to your exit program. The program must return the result of a lookup
in your database. This information is placed in the spool file and can be used for further conditioning - e.g. splitting and sorting.

You specify where to place the information returned from your exit-program.

Examples of exit split programs can be seen in source file: APF3812/APISRC in members: SPLEXIT, SPLEXIT02, SPLEXIT03.

You can also use the Create Page Builder Spooled File (command: APF3812/CRTPBSPLF) to search for and change up to 10 fields on each spooled file page.
(See example of a source for a page builder program in member PAGBLDPGM in source file APF3812/APISRC).


TIP: Specify the insert positions to the right of the original spool contents in order to make sure, that you do not overwrite information
from the original spool file.