Delete ALL

Database

Delete ALL

For Teradata 12  does a DELETE (without ALL ) statement in Teradata mode in a BTEQ use the Transient Journal.

3 REPLIES
Junior Contributor

Re: Delete ALL

There's no difference between DELETE and DELETE ALL, ALL is optional.

If there is no open transaction (i.e., no previous BT) it's FastPath if there's no Permanent Journal/Trigger/Join Index/Hash Index and it's not a temporal table.

Dieter

Re: Delete ALL

Thanks

Re: Delete ALL

Hi ,

For converting decimal column to varchar .One of the method is given below

INSERT INTO C

(

A,

B

)

SELECT 

A,

(CAST(CAST(B AS FORMAT'Z(I)') AS VARCHAR(50))) 

FROM D ;

If anyone hav any method for change the column means reply me.