Table of Contents

Search

  1. Preface
  2. Command Line Programs and Utilities
  3. Installing and Configuring Command Line Utilities
  4. Using the Command Line Programs
  5. Environment Variables for Command Line Programs
  6. Using infacmd
  7. infacmd as Command Reference
  8. infacmd aud Command Reference
  9. Infacmd bg Command Reference
  10. infacmd cms Command Reference
  11. infacmd dis Command Reference
  12. Infacmd es Command Reference
  13. infacmd ipc Command Reference
  14. infacmd isp Command Reference
  15. infacmd ldm Command Reference
  16. infacmd mrs Command Reference
  17. infacmd ms Command Reference
  18. infacmd oie Command Reference
  19. infacmd ps Command Reference
  20. infacmd pwx Command Reference
  21. infacmd rms Command Reference
  22. infacmd rtm Command Reference
  23. infacmd sch Command Reference
  24. infacmd search Command Reference
  25. infacmd sql Command Reference
  26. infacmd tdm Command Reference
  27. infacmd wfs Command Reference
  28. infacmd ws Command Reference
  29. infacmd xrf Command Reference
  30. infacmd Control Files
  31. infasetup Command Reference
  32. pmcmd Command Reference
  33. pmrep Command Reference
  34. Working with pmrep Files

Specifying the Database Type

Specifying the Database Type

When you create a connection, you must enter a database type using the string associated with that database type in
pmrep
. The strings are not case sensitive. Use quotes when entering a string with spaces in an argument.
The following table describes the required
pmrep
database type strings according to database:
Database
Database Type String
HTTP Transformation
Http Transformation
IBM DB2 for Linux, UNIX, and Windows
DB2
Informix
Informix
JMS
JMS Connection
JNDI
JNDI Connection
LMAPI Target
LMAPITarget
Microsoft SQL Server
Microsoft SQL Server
ODBC
ODBC
Oracle
Oracle
PeopleSoft DB2
PeopleSoft DB2
PeopleSoft Informix
PeopleSoft Informix
PeopleSoft MS SQL Server
PeopleSoft MsSqlserver
PeopleSoft Oracle
PeopleSoft Oracle
PeopleSoft Sybase
PeopleSoft Sybase
PowerChannel for DB2
PowerChannel for DB2
PowerChannel for MS SQL Server
PowerChannel for MS SQL Server
PowerChannel for ODBC
PowerChannel for ODBC
PowerChannel for Oracle
PowerChannel for Oracle
DB2 for i5/OS, PowerExchange bulk data movement
PWX DB2i5OS
DB2 for i5/OS, PowerExchange change data capture
PWX DB2i5OS CDC Change
DB2 for i5/OS, PowerExchange change data capture
PWX DB2i5OS CDC Real Time
DB2 for Linux, UNIX, and Windows, PowerExchange bulk data movement
PWX DB2LUW
DB2 for Linux, UNIX, and Windows, PowerExchange change data capture
PWX DB2LUW CDC Change
DB2 for Linux, UNIX, and Windows, PowerExchange change data capture
PWX DB2LUW CDC Real Time
DB2 for z/OS, PowerExchange bulk data movement
PWX DB2zOS
DB2 for z/OS, PowerExchange change data capture
PWX DB2zOS CDC Change
DB2 for z/OS, PowerExchange change data capture
PWX DB2zOS CDC Real Time
Microsoft SQL Server, PowerExchange bulk data movement
PWX MSSQLServer
Microsoft SQL Server, PowerExchange change data capture
PWX MSSQL CDC Change
Microsoft SQL Server, PowerExchange change data capture
PWX MSSQL CDC Real Time
Nonrelational, PowerExchange bulk data movement
PWX NRDB Batch
Nonrelational, PowerExchange change data capture
PWX NRDB CDC Change
Nonrelational, PowerExchange change data capture
PWX NRDB CDC Real Time
Nonrelational Lookup, PowerExchange
PWX NRDB Lookup
Oracle, PowerExchange bulk data movement
PWX Oracle
Oracle, PowerExchange change data capture
PWX Oracle CDC Change
Oracle, PowerExchange change data capture
PWX Oracle CDC Real Time
Sybase, PowerExchange bulk data movement
PWX Sybase
Salesforce
Salesforce Connection
SAP BW
SAP BW
SAP BWOHS READER
SAP_BWOHS_READER
SAP R3
SAP R3
SAP RFC/BAPI Interface
SAP RFC/BAPI Interface
SAP/ALE IDoc Reader
SAP_ALE_IDoc_Reader
SAP/ALE IDoc Writer
SAP_ALE_IDoc_Writer
Siebel DB2
Siebel DB2
Siebel Informix
Siebel Informix
Siebel MS SQL Server
Siebel MsSqlserver
Siebel Oracle
Siebel Oracle
Siebel Sybase
Siebel Sybase
Sybase
Sybase
Teradata
Teradata
Teradata FastExport
Teradata FastExport Connection
Web Services Consumer
Web Services Consumer
webMethods Broker
webMethods Broker


Updated April 22, 2019