Teradata: What is the difference between CASESPECIFIC and NOT CASESPECIFIC data type attributes?

When you create tables, you can set a lot of data type attribues like CHARACTER SET, FORMAT, UPPERCASE or (NOT) CASESPECIFIC. CASESPECIFIC attribute specifies case for character data comparisons and…

Continue Reading Teradata: What is the difference between CASESPECIFIC and NOT CASESPECIFIC data type attributes?
[SOLVED] Teradata: Error 3504 [SQLState HY000] Selected non-aggregate values must be part of the associated group.
Photo by John Schnobrich on Unsplash

[SOLVED] Teradata: Error 3504 [SQLState HY000] Selected non-aggregate values must be part of the associated group.

In this post, I will explain why you encountered an error [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group while executing the SQL query…

Continue Reading [SOLVED] Teradata: Error 3504 [SQLState HY000] Selected non-aggregate values must be part of the associated group.
Teradata: How to install Teradata Express on VMware Workstation Player on Windows operating system
Photo by Florian Krumm on Unsplash

Teradata: How to install Teradata Express on VMware Workstation Player on Windows operating system

In this post I will show you how to install Teradata Express (VMware) version 16.20 on VMware Workstation 15.5.0 Player on the Windows operating system. A few words about technologies…

Continue Reading Teradata: How to install Teradata Express on VMware Workstation Player on Windows operating system
SQL Developer:  How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?
Photo by Campaign Creators on Unsplash

SQL Developer: How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?

Oracle SQL Developer provides the feature to connect to many databases, including to Teradata, Microsoft SQL Server, IBM DB2, Sybase, MySQL and even Microsoft Access. All you need is the…

Continue Reading SQL Developer: How to connect to the Teradata / MS SQL Server database in Oracle SQL Developer?
[SOLVED] Teradata: Error 3653 [SQLState 21S02] All select-lists do not contain the same number of expressions.
Photo by Blake Connally on Unsplash

[SOLVED] Teradata: Error 3653 [SQLState 21S02] All select-lists do not contain the same number of expressions.

In this post, I will explain why you encountered the error message [Error 3653] [SQLState 21S02] All select-lists do not contain the same number of expressions, also known as Failed…

Continue Reading [SOLVED] Teradata: Error 3653 [SQLState 21S02] All select-lists do not contain the same number of expressions.