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. Smart Partitioning
  9. Salesforce Accelerator
  10. SAP Application Retirement Entities
  11. Import Formats for Constraints
  12. 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!