SAP Knowledge Base Article - Preview

2540796 - SUBSTR fires invalid parameter 3 (-1) when involved in joins - SAP IQ

Symptom

SUBSTRING function returns the error below when it is involved in joins.

The same SUBSTRING runs successfully on a single table with the same data.

select dp_id
from T1 , T2 , T3 , T4
where
      substring(T1.dp_id,1,charindex('.', T1.dp_id)-1) = T2.olas_id
      and T3.file_id = T1.dp_id
      and T4.file_id = T1.dp_id
      and T4.ingestion_date between '2017-03-03 19:39:13.626' and '2017-06-30 16:23:52.630'

Function 'SUBSTR' has invalid parameter '3' ('-1')
SQLCODE=-1090, ODBC 3 State="08004"
Line 1, column 1


Read more...

Environment

SAP IQ 16.0 SP 11 PL 11

Product

SAP IQ 16.0

Keywords

CR#811011 ;  CR811011 ; 811011 ; SUBSTR ; SQLCODE=-1090 ; -1090 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.