When using the PDC Setup page, you can use Save As to save a Database configuration File (DCC). This file can also be manually edited to add additional configuration parameters, these are detailed below.
Write Protection
Write-protecting the ‘master’ DCC file will also prevent accidental changes to the configuration. If the file is write-protected, the Setup dialog will help you out by presenting much of the information as ‘read only’. Once this protection is removed, the file can be edited.
Excluding Tables from the Database Connection Setup
By default, all tables in your database will be made available for inclusion in the Pulsonix Database Connection. Even though a given table may not be chosen to be visible it will still be accessed to provide details to the Setup dialog. There can be occasions where it is desirable to exclude certain tables so they are completely ignored by the database connection, for example, a temporary or non-standard table can sometimes prove problematic to the connection process.
To achieve this, it is possible to manually edit the DCC file, using Windows Notepad for example, to add an Exclusions section naming tables to be completely ignored by the database connection. The Exclusions section should be added to the end of the DCC file immediately before the closing bracket as shown in the example below. For brevity, the detail of other sections is shown as ’…‘.
(Pulsonix
(HEADER
...
)
(Contents
...
)
(Mappings
...
)
(Exclusions
(TableName "TempTab")
(TableName "User")
)
)
If the reverse situation is true and only a relatively few of the total number of database tables available need to be made accessible, an Inclusions section may be used instead. This is very similar in format to the Exclusions section shown above but is introduced by the keyword Inclusions rather than Exclusions. If an Inclusions section is present, only the tables it names will be accessible to the database connection and all other tables will be completely ignored.
Overriding the Default Database Query Timeout
By default, all queries sent to the database will time out after a set period to avoid permanently blocking Pulsonix, causing it to freeze. This period will vary and will be defined by system parameters. Sometimes, particularly a with very large database, the time out period can be too short to allow the Database Connection to complete fetching the data it requires. In this case, it is desirable to be able to override the default time out period for Pulsonix without affecting the system wide default setting.
To achieve this, it is possible to manually edit the DCC file, using Windows Notepad for example, to add a Settings section that defines an alternative query timeout period. The Settings section should be added to the end of the DCC file immediately before the closing bracket as shown in the example below. For brevity, the detail of other sections is shown as ’…‘.
(Pulsonix
(HEADER
...
)
(Contents
...
)
(Mappings
...
)
(Exclusions
...
)
(Settings
(QueryTimeout 45)
)
)
Related Topics
Pulsonix Database Connection | Database Bar | Database Type | PDC Setup