Specifying a Publishing Table

After you create Publication Service and select a table for the service, the Publishing Table field is automatically filled with the name of the selected table, with the prefix "P_".

If the Write to Database on Save check box is selected, when you save the adapter configuration, a publishing table is created automatically in the database. If you want to change the name of the publishing table, you can specify a name in the Publishing Table field.

Publishing Table

Publishing tables mirror the tables that you have identified for monitoring. Publishing tables contain additional columns, primarily a sequence number and delivery status, which are required by the adapter to detect new rows.

When you specify a publishing table, the adapter creates the publishing table in the database and the trigger that automatically populates the values for these additional columns. Do not modify these values.