Table of Contents


  1. Preface
  2. Part 1: Version 10.4.1
  3. Part 2: Version 10.4.0
  4. Part 3: Version 10.2.2
  5. Part 4: Version 10.2.1
  6. Part 5: Version 10.2
  7. Part 6: Version 10.1.1
  8. Part 7: Version 10.1

Schema Names in IBM DB2 Connections

Schema Names in IBM DB2 Connections

Effective in version 10.1, when you use an IBM DB2 connection to import a table in the Developer tool or the Analyst tool, you can specify one or more schema names from which you want to import the table. Use the ischemaname attribute in the metadata connection string URL to specify the schema names. Use the pipe (|) character to separate multiple schema names.
For example, enter the following syntax in the metadata connection string URL:
jdbc:informatica:db2://<host name>:<port>;DatabaseName=<database name>;ischemaname=<schema_name1>|<schema_name2>|<schema_name3>
This feature is also available in 9.6.1 HotFix 4. It is not available in 10.0.
For more information, see the
Informatica 10.1 Developer Tool Guide
Informatica 10.1 Analyst Tool Guide


We’d like to hear from you!