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
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.