SAP Knowledge Base Article - Preview

2355861 - A compound statement without being seperated by a semicolon works fine.

Symptom

The following compound statement without being separated by a semicolon works fine without a syntax error.

create table #TMP(a int) select * from jerry

I. 08/12 02:58:12. 0000000502 Connect: SA connHandle: 7 SA connID: 23 IQ connID: 0000000502 User: DBA
I. 08/12 02:58:12. 0000000502 Cmt 1430624
I. 08/12 02:58:12. 0000000502 PostCmt 0
I. 08/12 02:58:12. 0000000502 Txn 1430625 0 1430625
I. 08/12 02:58:12. 0000000502 Cmt 1430626
I. 08/12 02:58:12. 0000000502 PostCmt 0
I. 08/12 02:58:12. 0000000502 Txn 1430627 0 1430627
I. 08/12 02:58:12. 0000000502 Rbck
I. 08/12 02:58:12. 0000000502 PostRbck
I. 08/12 02:58:12. 0000000502 Disconnect: SA connHandle: 7 SA connID: 23 IQ connID: 0000000502 User: DBA


Read more...

Environment

SAP IQ 15.4
SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

SAP IQ, compound statement, batch, semicolon , 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.