DSXchange

Problem:::

I tried to open the existing server job in datastage designer, but unable to view the data in the respective input and output stages. I got the following error "IRATEST..ORAOCI8_10: ORA-00932: inconsistent datatypes IRATEST..ORAOCI8_10.DSLink1: DSP.Open GCI $DSP.Open error -2. "

Any solution to the above said problem.......

Welcome aboard! :D

This message usually indicates that the column definitions in your job design (in the OCI stage) do not match the data type in the actual columns in the Oracle table.

Make sure that they match absolutely.

Import the table definition using the OCI plug-in (in Manager use Import > Table Definitions > Plug-In Meta Data Definitions...) and inspect the result. (You can use View Data if one table has been selected.)

Perhaps even clear the column definitions from your OCI stage and load the freshly-imported ones.