ARIS6FTD is a FORTRAN language sample program for VSE systems that is shipped with the the DB2 Server for VSE product. ARIS6FTC is a FORTRAN language sample program for VM systems that is shipped with the the DB2 Server for VM product. It resides on the production disk for the base product. You may find it useful to print this sample program before going through this appendix as the hard copy will provide an illustration for many of the topics discussed here.
Note, for example, how the program satisfies the requirements of the application prolog and epilog. Near the beginning of the program all the host variables are declared, and error handling is defined. Near the logical end of the program, the database changes are rolled back, to assure the database remains consistent for each use of the sample program. For your own applications, of course, you will enter a commit. the host variables are declared, and error handling is defined.
The data description statements for the host variables are determined by referring to Figure 125. When you are coding your own applications you will need to obtain the data types of the columns that your host variables interact with. This can be done by querying the catalog tables. See the DB2 Server for VSE & VM SQL Reference manual for more information on catalog tables.