Extracting the database and IBM MQ scripts

Database scripts are required to load the FTM for High Value Payments interface and finite state machine configurations into the database. IBM® MQ scripts are required to create the necessary IBM MQ queues that are used to interface with FTM for High Value Payments.

To generate the database scripts for a specific model, select it from the list of models in Rational® Software Architect (RSA). Use its FTM menu to generate each of the following database scripts:

Generate configuration data SQL.
Generate FSM SQL.

To generate the IBM MQ scripts for a specific model, select it from the list of models in RSA. Use its FTM menu to generate the following IBM MQ scripts:

Generate MQ statements.

Note: The scripts which are shipped with FTM for High Value Payments have been extracted from FTM HVP App Model, which itself imports the three scheme specific models and relevant parts of the Common Model.