We are attempting to utilize the new in 14.10 DBQLXMLlocktbl. We have turned on the feature, so the table is getting populated with data. Now in an attempt to create the stored procedure SP_Locklog_Shredder to shred the XML data, we are receiving an error that the XML data type is not defined. The odd thing is that we only receive this error on our Dev system. We are able to create this procedure and supporting tables with XML datatype columns on our production system without error.
Both systems are running the same version of the database as shown below, however, our Production box is an Appliance.
Production system: 2700 Appliance
Dev system: 670 SMP
Both systems are running the same release/version.
Is there a setting somewhere that needs to be turned on to allow the XML data type to be configured/defined or enabled?
I found a couple of DBS Control settings, like XMLMemoryLimit and they are set to the default on both systems.
I found that there is one known DR which affects memory usage by the XMLQUERY and XMLTABLE functions (DR167091). This DR was shipped to TD14.10.4 maintenance release. So, I believe our version is later and therefore it does not apply to us.
Thanks in advance,
Just to clarify further, here is a sample table with a column data type of XML that I can successfully create in Production...