Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,204 members, 7,953,756 topics. Date: Friday, 20 September 2024 at 03:45 AM |
Nairaland Forum / Nairaland / General / Education / Loops In Teradata (464 Views)
Three Hours Long Afrobeat Music Loops For Studying, Focus And Concentration / Get Actual Teradata TDBL1-16.00 Exam Questions - Pass With Guarantee / Teradata Online Training And Job Support At Futurepoint (2) (3) (4)
(1) (Reply)
Loops In Teradata by Ttacy341(f): 2:06pm On Sep 19, 2017 |
If<Condition>Then<Statement1>; Else<Statment2>; End If Description If the condition is successes if executes statement1, other wise executes statement2 While loop While(<Condition>Do <SQL Statements> End while; Description If repeats in till condition fails Looping[For Loop] Loop Label: Label- Name <Statements> End loop Label- Name Description Till the condition False the loop will be Repeated These core tutorials will help you to learn the Loops in Teradata. For an in-depth understanding and practical experience, explore Teradata Training PDF. Declaring variable 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 Format command 9 2 Digit Z 2 Zero Suppressed Digit $2Under score etc # 2 Formatting string X 2 Single character B 2 BLANK Formatting Dates DD 2 DAY MMMM 2 Full month YY 2 Year YYYY 2 Full year B 2 Blank etc… 85000 2 $9999 2 $85000 Learn more about Teradata Interview Questions in this blog post. Screenshot_84 Note Formatting command we can execute only in BTEQ for more info about : Teradata |
(1) (Reply)
How I Got Interested In Learning - Atiku Abubakar / Unilorin Program Of Events For 33rd Convocation Ceremony / Any Hope For Me?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 6 |