Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Appendix A: Connections
  17. Appendix B: Data Type Reference
  18. Appendix C: Function Reference

IBM DB2 and DB2 for z/OS Data Types

IBM DB2 and DB2 for z/OS Data Types

Informatica supports the following IBM DB2 and DB2 for z/OS data types when you use Sqoop:

    Bigint

    Blob (supported only for import)

    Char

    Clob

    Date

    DBClob

    DecFloat (supported only for import)

    Decimal

    Double (supported only for DB2 for z/OS)

    Float (supported only for DB2)

    Graphic

    Integer

    LongVargraphic (supported only for DB2)

    Numeric

    Real

    Smallint

    Time

    Timestamp

    Varchar

    Vargraphic

    XML (supported only for import)



Updated July 10, 2020