Configuring an Exceptions Table as a Source Table
If you want to publish data from an exceptions table and also want to use this exceptions table as the source table, you cannot use the ADB_ERROR_TEXT or ADB_OPCODE columns.
To avoid using the ADB_ERROR_TEXT or ADB_OPCODE columns in the exceptions table, you can rename these columns.
Procedure
- Create a database view that mirrors the exceptions table, but rename the ADB_ERROR_TEXT and ADB_OPCODE columns so that they do not begin with "ADB_."
- Use the Publish by Reference Object feature and select your view as the referred object. For details about Publish by Reference Object, see Specifying a Reference Object.
Copyright © Cloud Software Group, Inc. All rights reserved.