Hi,
I created a table in oracle database using following query
create table salma(customerid number, ename varchar2(20),jansales decimal(12,2),febsales decimal(10,2))
My design is odbc---->pivot---->odbc.
Iam calling this table in my source odbc stage.
when i run the job ,iam getting peculiar error.
ob2..ODBC_0.DSLink3: DSD.BCIOpenR results of SQLColAttributes(CUSTID) gave MetaData mismatch
COLUMN.TYPE Expected = Integer Actual = Decimal.
when seeing this error.i tried to change the datatype in my created table in oracle to decimal but its not accepting.
I really feel embrassed to post this error, but please help me to analyze the error.
cheers;
vijay
Regarding pivot stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Change CUST_ID to Integer in your job. Oracle uses NUMBER, which imports as Numeric, but SQLColAttributes() understands ODBC conventions rather than Oracle conventions. This can lead to minor inaccuracies when importing metadata from Oracle tables. You must make the metadata match.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Gurus,
Still getting the same error.
I used the following create command in SQL.
create table saama(custid number,custname varchar2(12),jansales decimal(12,2),febsales(10,2)
In the odbc properties.
i defined my column properties as
Name sql type length
custid integer 17
i checked my table using sql command desc saama
EMPNO NUMBER
CUSTNAME VARCHAR2(19)
JANSALES NUMBER(14,2)
FEBSALES NUMBER(12,2)
ob2..ODBC_2.DSLink4: DSD.BCIOpenW call to SQLColAttributes(CUSTID) failed.
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client]Invalid cursor state.
gurus please help me in analyzing problem
Still getting the same error.
I used the following create command in SQL.
create table saama(custid number,custname varchar2(12),jansales decimal(12,2),febsales(10,2)
In the odbc properties.
i defined my column properties as
Name sql type length
custid integer 17
i checked my table using sql command desc saama
EMPNO NUMBER
CUSTNAME VARCHAR2(19)
JANSALES NUMBER(14,2)
FEBSALES NUMBER(12,2)
ob2..ODBC_2.DSLink4: DSD.BCIOpenW call to SQLColAttributes(CUSTID) failed.
SQLSTATE=24000, DBMS.CODE=0
[DataStage][SQL Client]Invalid cursor state.
gurus please help me in analyzing problem
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America