Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Appendix A: Datetime and Numeric Formatting
  24. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

File Archive Transaction Restore URL Syntax

File Archive Transaction Restore URL Syntax

The URL that runs the file archive transaction restore has the following syntax:
http://<host>:<port>/API/fileArchiveTxnRestore.htm?definitionId=<definitionId>& whereClause=<whereClase>& username=<username>& password=<encryptedPassword>
The parameters are included in brackets. When you formulate the URL, you insert values for all of the parameters and remove the brackets.
The following table describes the parameters to form the URL:
Parameter
Description
definitionId
File archive transaction restore API definition ID. Required.
After you create the definition in the user interface, you can obtain the definition ID by running the following command on the ILM repository database:
SELECT MAX(DEFN_ID) from AM_DEFN
whereClause
Where clause to filter and restore the data. Required.
Username
Data Archive username. Required.
Password
Encrypted password returned by the encryptPassword.bat or encryptPassword.sh utility. Required when the property "informia.api.authentication" is enabled in the
conf.properties
file. Use this parameter only when "informia.api.authentication" is enabled in the
conf.properties
file. If "informia.api.authentication" is not enabled, you do not need to use this parameter in the URL. For more information, refer to the topic "API Authentication" in this chapter.
The whereClause parameter uses special formatting for conditions and operators. The following table describes the formatting for conditions and operators:
Condition or Operator
WHERE_CLAUSE Format
>=
###GTEQ###
<=
###LTEQ###
=
###EQ###
<>
###NEQ###
>
###GT###
<
###LT###
In
###IN###
Not In
###NOT_IN###
Is Null
###IS_NULL###
Is Not Null
###NOT_NULL###
Like
###LIKE###
Like (Starts with)
###STARTS_WITH###
Like (Ends with)
###ENDS_WITH###
Like (Contains)
###CONTAINS###
Not Like (Does not start with)
###NOT_START_WITH###
Not Like (Does not end with)
###NOT_END_WITH###
Not Like (Does not contain)
###NOT_CONTAIN###

0 COMMENTS

We’d like to hear from you!