SAP Knowledge Base Article - Preview

3378177 - BACKUP TABLE statement is not allowed the backup of the empty table - SAP IQ

Symptom

The following error message has report when it did run BACKUP TABLE statement to the empty table.

Sample
(dba)> create table tableA (col1 int)

(dba)> BACKUP TABLE tableA to 'tabeA_backup' PAGING OFF ;
Could not execute statement.
  Backup of empty table is not allowed.
  SQLCODE=-1014064, ODBC 3 State="HY000"

Line 1, column 1
  BACKUP TABLE tableA to 'tabeA_backup' PAGING OFF


Read more...

Environment

  • SAP IQ 16.1

Keywords

0 row, blank, row,  , KBA , BC-SYB-IQ , Sybase IQ , How To

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.