Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Data definition not valid unless solitary error in Connect In-DB tool

Glopez76
6 - Meteoroid

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;

0 REPLIES 0
Labels