Show Text of Statement that Created Compute Group
SHOW COMPUTE GROUP global_grp1;
*** Text of DDL statement returned.
---------------------------------------------------------------------------
CREATE COMPUTE GROUP Global_grp1
USING
Query_Strategy ('STANDARD');
Show XML of Statement that Created Compute Group
SHOW IN XML COMPUTE GROUP Global_grp1;
*** XML of DDL statement returned.
---------------------------------------------------------------------------
<?xml version="1.0" encoding="UTF-16" standalone="no" ?><TeradataDBObjectSet version="1.0" xmlns="http://schemas.teradata.com/dbobject" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://schemas.teradata.com/dbobject http://schemas.teradata.com/dbobject/DBObject.xsd"><ComputeGroup ComputeG
roupName="TEST_GROUP_02"><ComputeGroupClauseList><Clause name="QUERY_STRATEGY" value="STANDARD"/></ComputeGroupClauseList><SQLText><![CDATA[CREATE COMPUTE GROUP TEST_GROUP_02
USING
QUERY_STRATEGY ('STANDARD');]]></SQLText></ComputeGroup><Environment><Server dbRelease="20.00.02.15" dbVersion="20.00.02.15" hostName="POGe8415cca90"/><User userId="00000100" userName="DBC"/><Session charset="ASCII" dateTime="2022-12-02T18:09:57"/></Environment></TeradataDBObjectSet>