Hello,
I am trying to run the below Teradata SQL code in the Connect In-DB tool but I'm getting the error 'Data definition not valid unless solitary'. Can someone help me?
/**********************************Data manipulation piece for DNIS***********************************************/
SELECT * FROM ENTPR_INTEL_CIHUB_USER.GL_Alteryx_Work;
/*This section is to identify and fetch the correct DNIS value*/
/*Adding column Original_DNIS to house the 5 digit DNIS value from the DNIS column*/
BEGIN TRANSACTION;
ALTER TABLE ENTPR_INTEL_CIHUB_USER.GL_Alteryx_Work
ADD Original_DNIS VARCHAR(15);
END TRANSACTION;