SAP Knowledge Base Article - Preview

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

Symptom

Some  code (either a batch SQL or a stored procedure) could return syntax error near rollback on line 7

For example, 
=====
 
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 or older versions of IQ

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 for Me (Login required).

Search for additional results

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