RC/Query and Altering XML Table Spaces
search cancel

RC/Query and Altering XML Table Spaces

book

Article ID: 257039

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

Does RC/Query support the altering of XML table spaces?


Environment

Release : 20.0

Resolution

No RC/Query does not support the altering of XML table spaces.
 

The main reason for XML tablespaces not being supported (alterable) 
in RC/QUERY is that they are not creatable objects.

That is there is no CREATE syntax for an XML tablespace, rather they are 
only implicitly created via a CREATE TABLE statement that includes an XML column. 

RC/QUERY supports generation of both CREATE and ALTER TABLESPACE statements as needed.
As the XML tablespaces are always implicitly created(meaning no CREATE TABLESPACE statement is required),
the support for generating ALTER  statements on XML objects is not implemented currently.