DB2 Database Modification

The following script modifies the DB2® database with the sample XML information that is in the install_directory\check\v305\Gateway\samples\sampleX937routedata.xml file. The database installation scripts for the Transaction Server create an entry for endpoint 0 in the database ENDPOINTS table. To alter the entry for endpoint 0, modify the sampleX937routedata.xml file to contain the required defaults. Update the existing endpoint 0 in the database by using the following commands:
Figure 1. Script modifying the DB2 database
db2 connect to ftmdb;
INSERT into ftm.endpoints (dest_rt, X9.37_route_data) values(0,
DB2XML.XMLCLOBFromFile('C:\Program Files (x86)\IBM\ftm\check\v305\Gateway\samples\sampleX937routedata.xml'));
commit;
Note:
  1. The example script uses the default installation directory. If Gateway Server has been installed in a different directory, the path name in the script needs to be updated before using it.
  2. To avoid losing any customized default values, use a different file name when saving changes to the sampleX937routedata.xml XML file. Sample files are overwritten or removed during product installation and removal.