Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
bhs
Premium Member
Posts: 6 Joined: Sat May 07, 2011 11:51 am
Location: United States
Post
by bhs » Thu Apr 19, 2012 8:43 am
ODBC_Connector_56,0: ODBC function "SQLGetData" reported: SQLSTATE = 07009: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Driver]Invalid Descriptor Index (CC_OdbcInputStream::getTotalSize, file CC_OdbcInputStream.cpp, line 349)
HendrikB
Premium Member
Posts: 15 Joined: Tue Feb 07, 2012 6:01 am
Post
by HendrikB » Wed May 09, 2012 4:36 am
Hi bhs,
getting the same error message today when reading a nvarchar(max) column out of SQL Server using ODBC connector.
Your workaround may help me.
Thanks and regards,
Hendrik
sri_vin
Premium Member
Posts: 20 Joined: Wed Aug 25, 2010 10:58 pm
Post
by sri_vin » Mon Jul 23, 2012 12:56 am
Hi
Please check your SQL code. It might have some un-printable character in it. You may need to replace them.
regards
Sriram
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Jul 23, 2012 7:40 am
This suggests it is not a data issue.
-craig
"You can never have too many knives" -- Logan Nine Fingers
leomauer
Premium Member
Posts: 100 Joined: Mon Nov 03, 2003 1:33 pm
Post
by leomauer » Tue Jul 31, 2012 1:01 pm
Today we got the same error and learned that varchar(max) is treated as CLOB (text) field and has to go to the bottom of the Select statement:
SELECT
<all non CLOB fields>
<all CLOB fields>
FROM
<table name>
....