Connectivity Guide For Oracle Databases IBM Info Sphere Data Stage And Quality Version 11 Release 3
User Manual: Pdf
Open the PDF directly: View PDF
Page Count: 195 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Contents
- Chapter 1. Connector Migration Tool
- Chapter 2. Configuring access to Oracle database
- Chapter 3. Oracle connector
- Setting required user privileges
- Designing jobs that use the Oracle connector
- Importing Oracle metadata
- Defining a job that includes the Oracle connector
- Defining a connection to an Oracle database
- Reading data from an Oracle database
- Writing data to an Oracle database
- Looking up data in an Oracle database
- Generating SQL statements in the connector at design time
- Validating SQL statements in the connector at design time
- Troubleshooting the Oracle connector
- Reference
- Runtime mappings between InfoSphere DataStage columns and SQL statement parameters
- Data type mapping and Oracle data types
- Properties for the Oracle connector
- Enable quoted identifiers property
- Isolation level property
- Array size, buffer size, and record count properties
- Properties to run an SQL statement before or after processing data
- Properties that control job failure
- Transparent application failover properties
- Properties for managing connections
- Read properties
- Write properties
- Lookup properties
- Runtime column propagation
- Partitioned read methods
- Oracle connector partition type
- Supported write methods
- Reject conditions
- White space characters, NULL values, and empty string values
- Dictionary views
- Exceptions table
- Environment variables that the Oracle connector uses
- Chapter 4. Oracle Enterprise stage
- Chapter 5. Oracle OCI stage
- Functionality of the Oracle OCI stage
- Configuration requirements of the Oracle OCI stage
- Oracle OCI stage editor
- Defining the Oracle connection
- Defining character set mapping
- Defining input data
- Writing data to Oracle
- Defining output data
- Reading data from Oracle
- DATE data type considerations
- Oracle data type support
- Handling $ and # characters
- Chapter 6. Oracle OCI Load stage
- Chapter 7. Building SQL statements
- Starting SQL builder from a stage editor
- Starting SQL builder
- Building SELECT statements
- Building INSERT statements
- Building UPDATE statements
- Building DELETE statements
- The SQL builder interface
- Selection page
- Group page
- Insert page
- Update page
- Delete page
- SQL page
- Expression editor
- Joining tables
- Properties windows
- Chapter 8. Environment variables: Oracle connector
- CC_GUARDIUM_EVENTS
- CC_IGNORE_TIME_LENGTH_AND_SCALE
- CC_ORA_BIND_DATETIME_AS_CHAR
- CC_ORA_BIND_FOR_NCHARS
- CC_ORA_BIND_KEYWORD
- CC_ORA_CHECK_CONVERSION
- CC_ORACLECONNECTOR_DEFAULT_CONNECTION_VERSION
- CC_ORA_DEFAULT_DATETIME_TIME
- CC_ORA_DEFAULT_DATETIME_DATE
- CC_ORA_DROP_UNMATCHED_FIELDS_DEFAULT
- CC_ORA_INDEX_MAINT_SINGLE_ROW
- CC_ORA_INVALID_DATETIME_ACTION
- CC_ORA_LOB_LOCATOR_COLUMNS
- CC_ORA_MAX_ERRORS_REPORT
- CC_MSG_LEVEL
- CC_ORA_NLS_LANG_ENV
- CC_ORA_NODE_PLACEHOLDER_NAME
- CC_ORA_NODE_USE_PLACEHOLDER
- CC_ORA_NULL_CHAR_ACTION
- CC_ORA_OPTIMIZE_CONNECTIONS
- CC_ORA_PRESERVE_DATE_TYPE_NAME
- CC_ORA_ROWS_REJECTED_MSG_INFO
- CC_ORA_UNBOUNDED_BINARY_LENGTH
- CC_ORA_UNBOUNDED_STRING_LENGTH
- CC_ORA_XMLTYPE_CSID_BLOB
- CC_SE_TIMESTAMP_FF
- CC_TRUNCATE_STRING_WITH_NULL
- CC_TRUNCATE_NSTRING_WITH_NULL
- CC_USE_EXTERNAL_SCHEMA_ON_MISMATCH
- Appendix A. Product accessibility
- Appendix B. Reading command-line syntax
- Appendix C. How to read syntax diagrams
- Appendix D. Contacting IBM
- Appendix E. Accessing the product documentation
- Appendix F. Providing feedback on the product documentation
- Notices and trademarks
- Index