Creating an Empty Database Table
To create an empty database table
1. With your database server running, verify that you have a Trading Networks database in which to add a table.
Note:
SWIFT Module works with the same database as Trading Networks for the BIC Directory, Bank Directory Plus, SEPA Plus, and SSI Plus feature.
2. Follow your database server's documentation instructions and import the file list into your selected database. Use the following table as a guide to locate the file that corresponds to the type of list you want to import.
Note:
webMethods provides scripts for SQL Server, Oracle, and DB2 databases at the specified location. The db in the file name indicates the name of the database to use. Valid values are SQLServer, Oracle, and DB2.
List Type | File Integration Server_directory \packages\WmFIN\config\bic\... |
BIC | create_BIC_db.sql |
BankDirectoryPlus | create_BankDirectory_Plus_V3_db.sql |
IBANPlus | create_IBANPlus_db.sql |
IBANStructure | create_IS_db.sql |
SEPAPlus | create_SR_db.sql |
SSIPlus | create_SSIPlus_db.sql |