Connect by oracle to teradata


Connect by oracle to teradata

Can any body please help me convert the following oracle query to Teradata.

SELECT DISTINCT DECODE(product_id,'product1',0,'product2',0,'product3',0,LEVEL) Node_level,
USE,product_id,template ,header,tit1,num_chrts,product_order,producttext FROM productdata where use = 5
CONNECT BY product_id = PRIOR header AND LEVEL=2
START WITH product_id ='product1234' ORDER BY product_order

I tried with recursive, but how can I specify level = 2.