What is basic teradata query language?
Submitted by: AdministratorBTEQ(Basic teradata query)
It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.
The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is
compulsary to terminate the SQL statement.
BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it.
Submitted by: Administrator
It allows us to write SQL statements along with BTEQ commands. We can use BTEQ for importing,exporting and reporting purposes.
The commands start with a (.) dot and can be terminated by using (;), it is not mandatory to use (;). SQL statements doesnt start with a dot , but (;) is
compulsary to terminate the SQL statement.
BTEQ will assume any thing written with out a dot as a sql statement and requires a (;) to terminate it.
Submitted by: Administrator
Read Online Teradata Job Interview Questions And Answers
Top Teradata Questions
| ☺ | What is stored procedure in Teradata? |
| ☺ | What is the difference between start schma and Fsldm? |
| ☺ | What are the enhanced features in Teradata V2R5 and V2R6? |
| ☺ | How teradata makes sure that there are no duplicate rows being inserted when its a SET table? |
| ☺ | What is an optimization and performance tuning and how does it really work in practical projects? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
