Logo SQLinForm

 

[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.
Re: Teradata lists only seem to be formated in SELECTs
October 03, 2015 01:37PM
Thanks for this suggestion. Ill add it to the next release
Regards
Guido
Re: Teradata lists only seem to be formated in SELECTs
December 06, 2015 10:12PM
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.
Author:

Your Email (Optional):


Subject:


Spam prevention:
Please, solve the mathematical question and enter the answer in the input field below. This is for blocking bots that try to post this form automatically.
Question: how much is 5 plus 1?
Message: