Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Salesforce Accelerator
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Entities for Informix Databases

Entities for Informix Databases

When you create an archive entity for a Informix source database, adhere to the following guidelines:
  • The interim table name must be in uppercase characters.
  • In the default columns of the entity interim table, enter a double quotation mark in the SELECT clause field for the STATS_DATE and ORG_ID columns. Do not leave these fields blank.
  • In the table insert and delete statements, the interim table name and column names must be surrounded by double quotation marks. The entity table name and column names should not be in double quotation marks.
  • Delete statements should not contain a table alias name with the primary key. For example: Change (A. "integer") to (integer).

0 COMMENTS

We’d like to hear from you!