Backup.Task table not found in SQL
Hi,
I'm trying to run an SQL against Backup.Task table.
There is this class:
Class Backup.Task
documented here:
The documentation says:
“SQL Table Name: Backup.Task”
However when I run this SQL from the Management Portal:
select * from Backup.Task
I get this error.
SQLCODE: -30
Message: Table 'BACKUP.TASK' not found
Why is this the case?
How do I fix this?
Product version: IRIS 2025.1
Discussion (1)0
Comments
The Backup.Task is deliberately not registered as an SQL table, despite what the autogenerated documentation header says.
If you run the following SQL (in %SYS, using $system.SQL.shell) you get 0 results:
SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'Backup'
You can however work with this table in COS objects