The following items were done to an existing table:
- Dropped and recreated the table adding a column. The column added was a char(1) and a constant value of 'Y' added to existing data. The column is nullable.
- Recreated a view that used the table.
- Recreated a function - that is also used by that table.
- Rebooted the IQ
The query does not fail per se, it fails with the following error:
- Sybase Server error 13492 (severity 19): SQL Anywhere Error -1000: Temporary space limit exceeded
Same Query ran quickly in IQ before the addition of the new column.
KBA , BC-SYB-IQ , Sybase IQ , How To
About this pageThis 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.