If<Condition>Then<Statement1>;
Else<Statment2>;
End If
If the condition is successes if executes statement1, other wise executes statement2
While(<Condition>)Do
<SQL Statements>
End while;
If repeats in till condition fails
Loop Label: Label- Name
<Statements>
End loop Label- Name
Till the condition False the loop will be Repeated
Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training
Syntax - Declare<Variable name><Data type>;
Ex - Declare Dept name Varchar(30);
Assigning values to variables;
Syntax - Set < Varchar >=<value>or<variable>or<columnname>
Ex:
Set Dept name=D Name1;
Set Dept name= IT
9 
Digit
Z Zero Suppressed Digit
$Under score etc
# Formatting string
X Single character
B BLANK
DD DAY
MMMM Full month
YY Year
YYYY Full year
B Blank etc…
85000 $9999 $85000
Note:
Formatting command we can execute only in BTEQ.
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
