## [solved] Teradata lists only seem to be formated in SELECTs
The easiest way to explain this is with an example:
If I format this: REPLACE VIEW dv.CUST_DIM ( Cust_Key,Cust_Mt_Key,CMbT_Eff_Dt,CMbT_Exp_Dt,Atve_Rec_Ind,Cust_Id ) AS LOCKING ROW ACCESS SELECT a1.Cust_Key,a1.Cust_Mt_Key,a1.CMbT_Eff_Dt,a1.CMbT_Exp_Dt,a1.Atve_Rec_Ind,a1.Cust_Id FROM db.CUST_DIM a1 WHERE a1.Clk_ind = 'N'; I get:
REPLACE VIEW dv.CUST_DIM ( Cust_Key,Cust_Mt_Key,CMbT_Eff_Dt,CMbT_Exp_Dt,Atve_Rec_Ind,Cust_Id ) AS LOCKING ROW ACCESS SELECT a1.Cust_Key ,a1.Cust_Mt_Key ,a1.CMbT_Eff_Dt ,a1.CMbT_Exp_Dt ,a1.Atve_Rec_Ind ,a1.Cust_Id FROM db.CUST_DIM a1 WHERE a1.Clk_ind = 'N'; What I want is:
REPLACE VIEW dv.CUST_DIM ( Cust_Key , Cust_Mt_Key , CMbT_Eff_Dt , CMbT_Exp_Dt , Atve_Rec_Ind , Cust_Id ) AS LOCKING ROW ACCESS SELECT a1.Cust_Key , a1.Cust_Mt_Key , a1.CMbT_Eff_Dt , a1.CMbT_Exp_Dt , a1.Atve_Rec_Ind , a1.Cust_Id FROM db.CUST_DIM a1 WHERE a1.Clk_ind = 'N'; Edited 1 time(s). Last edit at 06/13/2016 11:13PM by guidomarcel.
Hi Darin,
in the new release it is now formatted like this REPLACE VIEW ( Cust_Key , Cust_Mt_Key , CMbT_Eff_Dt , CMbT_Exp_Dt , Atve_Rec_Ind, Cust_Id ) AS LOCKING ROW ACCESS SELECT a1.Cust_Key , a1.Cust_Mt_Key , a1.CMbT_Eff_Dt , a1.CMbT_Exp_Dt , a1.Atve_Rec_Ind, a1.Cust_Id FROM db.CUST_DIM a1 WHERE a1.Clk_ind = 'N'; Regards Guido Edited 2 time(s). Last edit at 12/06/2015 10:13PM by guidomarcel. |