SAP Knowledge Base Article - Preview

3017669 - Syntax error after upgrading to IQ 16.1 - SAP IQ

Symptom

The following code started returning syntax error near rollback on line 7
 
=====
 
if 688476 = 688476
then
print '#+ '||@@rowcount||' 688476 Success';
commit tran
else
print '#- '||@@rowcount||' 688476 Fail';
rollback tran
end if
 
====

This started after upgrading to IQ16.1 SP04.07 from IQ16.0 SP11.PL22

1) SAP IQ 16.0 SP11 PL22 
 
1> if 688476 = 688476
2> then
3> print '#+ '||@@rowcount||' 688476 Success';
4> commit tran
5> else
6>  print '#- '||@@rowcount||' 688476 Fail';
7>  rollback tran
8> end if
9> go
#+ 0 688476 Success
 
=====
 
2) SAP IQ 16.1 SP04 PL07
 
1> if 688476 = 688476
2> then
3> print '#+ '||@@rowcount||' 688476 Success';
4> commit tran
5> else
6>  print '#- '||@@rowcount||' 688476 Fail';
7>  rollback tran
8> end if
9> go
SQL Anywhere Error -131: Syntax error near 'rollback' on line 7
 
=====


Read more...

Environment

SAP IQ 16.1 SP04 PL07

Product

SAP IQ 16.1

Keywords

Watcom Transact-SQL T-SQL SQL Anywhere Error -131 Syntax error near on line , 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.