Teradata BTEQ Introduction and Demo

In this session we are discussing about the following things:
- What is teradata BTEQ?
- What is its compatibility with platforms?
- What kind of actions we can perform using BTEQ? etc

Sample Scripts:
============

========
.logon 192.168.1.9/dbc,dbc;
select * from profiles;
.logoff;

==========
.logon 192.168.1.9/dbc,dbc;
select * from accessrights;
select * from profiles;
.logoff

=========
.logon 192.168.1.9/dbc,dbc
.set width 150
delete from hosts;
select * from hosts;
insert into hosts values (1,'test_hem',2);
insert into hosts values (2,'test_kar',3);
insert into hosts values (3,'test_Jag',4);
insert into hosts values (4,'test_Tej',5);
select * from hosts order by 1;
.logoff

[surajabburiveera]

Very useful content. Thank you for sharing these details

[ramum]

Need more vedios on complex bteq logics

[R-Kannada-DevOps]

Hi when i execute, LOGON ip/dbc, dbc;
I am getting RDBS stopped/crashed error, how to solve this

[manokhan]

Hi guys, also can you please make a video about how to run a jar function to encryption and dycription of specific column in teradata?

[manokhan]

Can you pmease upload the Mini-Batch in tpt?

[makbaeful]

can you help me. I have no problems with connection. Bteq works. But when I put cyrillic symbols in file location, bteq stops. Tried to convert in utf-8… no results.

Code: . Login …; .run file = K:\user\файлы\test.sql; .logoff .quit