2407912 - Different 'UserDatatype' are returned between IQ12.7 and 16, when DataStage(9.1.2) executes 'count(*)' function | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2407912 - Different 'UserDatatype' are returned between IQ12.7 and 16, when DataStage(9.1.2) executes 'count(*)' function

Symptom

  When DataStage(9.1.2) sent 'count(*)' query as dynamic query to IQ, IQ server returned  result value and 'Data type' value.
  Problem is that returned Data Type values are different between IQ12.7 and IQ15.4 (IQ16 too).
  This caused error "Unsupported Data Type 84".

  DataStage has been used 'usertype' item to get data type of result column from IQ12.7.
  On 'count(*)' query, 'usertype' returns 35 (unsined bigint) from IQ12.7,  but IQ15.4 & IQ16 returns value '84'. 
  However '84' isn't valid data type at all. 
  
  Error =>  
     > SQL : select count(*) AS COL1 from test_ds_varchar
     > Error : DataStage Error Message : "Unsupported Data Type 84"


Read more...

Environment

  • SAP IQ16
  • SAP IQ15.4

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

"TDS specification" , "DataStage V9.1.2" , , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.