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.
SAP Knowledge Base Article - Preview