ABS function
ACCOUNT - Getting Account number
ADD MONTHS
ADD MONTHS with INTERVAL
ADD DAYS
ADD YEARS
SUBTRACT MONTHS
ADD MONTHS in Arithmetic Operations on DATE
Adding column in a table
Adding FOREIGN KEY to a table
Adding PRIMARY KEY to a table
AGE calculation
AND
ASIN
ATAN
ATAN2
AVG - Average
BETWEEN
BETWEEN for DATE types
Boolean type
BTEQ - Break a line to have sections
BTEQ - How to break a line
BTEQ - Change your password
BTEQ - Changing the screen width
BTEQ - Changing the TDPID
BTEQ - Checking Teradata version
BTEQ - Commands for File control
BTEQ - Commands for Session control
BTEQ - Commands overview
BTEQ - Compile
BTEQ - Continuing BTEQ commands
BTEQ - Creating and calling Macro
BTEQ - Creating RUN FILE
BTEQ - Default
BTEQ - ECHOREQ - Echo required function
BTEQ - Entering DOS commands
BTEQ - ERRORCODE - Checking for errors
BTEQ - ERROROUT
BTEQ - Executing stored procedure
BTEQ - EXIT or QUIT
BTEQ - Exporting results to a file
BTEQ - Exporting under VM
BTEQ - Exporting under MS-DOS, UNIX
BTEQ - FOLDLINE
BTEQ - FORMCHAR
BTEQ - FULLYEAR - Setting year in YYYY format
BTEQ - Get Help
BTEQ - Giving comments
BTEQ - Giving comments in ANSI mode
BTEQ - GOTO - Redirecting the control
BTEQ - HANG - Put a pause
BTEQ - Identifying input and output file undes MS-DOS
BTEQ - If Else Command
BTEQ - INDICDATA
BTEQ - Inserting a Line of Underline Characters
BTEQ - Inserting blank lines
BTEQ - LOGOFF
BTEQ - LOGON
BTEQ - LOGON with TDPID
BTEQ - Bypassing Logon Prompts
BTEQ - MACRO
BTEQ - Omit
BTEQ - OS
BTEQ - Listing example on various platforms
BTEQ - OS under MS-DOS
BTEQ - PAGELENGTH
BTEQ - QUIET
BTEQ - REMARK command
BTEQ - REPEAT command
BTEQ - REPEAT with = (Equivalent)
BTEQ - REPEAT command with Multiple sessions
BTEQ - REPEATSTOP
BTEQ - REPEAT in ANSI mode
BTEQ - Representing NULL values
BTEQ - RETCANCEL
BTEQ - RETLIMIT
BTEQ - RETRY
BTEQ - Return codes
BTEQ - Run file (Batch mode)
BTEQ - Script structure
BTEQ - An Example for script structure
BTEQ - SESSION TRANSACTION
BTEQ - SHOW CONTROLS
BTEQ - Single statement processing
BTEQ - Multiple statement processing
BTEQ - SKIP LINE and SKIP DOUBLE
BTEQ - Specify Multiple sessions
BTEQ - Specifying Sidetitles
BTEQ - SUPPRESS - Deleting Duplicated Data
BTEQ - SYSIN & SYSOUT
BTEQ - TIMEMSG command
BTEQ - To execute the given SQL statement repeatedly
BTEQ - To skip first record while importing
CALENDAR
CASE Statement
Nested Case statement
CAST
Changing a column Datatype length
Changing FLOATs to TIMEs
Checking Rights
COALESCE
Coalesce for Date
COLUMN ALIASING
Common Table Expressions (CTE)
Computing the DAY of a week
CONCAT
Concatenation Operator ||
Connection string - Teradata .Net driver
Connection string - OLE DB Provider for Teradata
.NET Framework Data Provider for OLE DB
Teradata ODBC Driver
.NET Framework Data Provider for ODBC
Converting Columns into Rows
Convert rows into columns
Convert rows into columns for huge rows
Converting DECIMAL to VARCHAR
Converting Decimal type to Char type with leading zeros
COUNT and COUNT(Asterik)
COUNT with GROUP BY
CREATE ERROR TABLE
CREATE ERROR TABLE - Detailed
CREATE GLOBAL TEMPORARY TABLE
CREATE MACRO
Parameterized Macro
CALLING MACRO
DROP MACRO
REPLACE MACRO
CREATE ROLE
CREATE SECONDARY INDEX
CREATE NAMED SECONDARY INDEX
CREATE TABLE
COPY TABLE STRUCTURE and DATA
COPY TABLE STRUCTURE alone
CREATE TABLE As Old Table
CREATE TABLE with UNIQUE PRIMARY INDEX
CREATE MULTISET TABLE with NON UNIQUE PRIMARY INDEX
CREATE TRANSFORM
DROP TRANSFORM
Create Volatile Table
Problems with dynamic creation of Volatile tables
CURRENT_TIMESTAMP
AM and PM format in CURRENT_TIMESTAMP
CURSORS
OPEN CURSOR
CLOSE CURSOR
Data types
DATABASE SIZE AND USAGE
DATE datatype
Determining years (Age) with DATE functions
Arithmetic operations on DATE
DATE to NUMERIC conversion
NUMERIC to DATE conversion
DAYS between DATES
DCL statements
DDL statements
Default DATE setting in BTEQ
DELETE DATABASE
DROP DATABASE
Delete duplicate rows
DELETE records from a table
Difference Between IN andEXIST
Difference between Macro and Stored procedure
Difference between TIMEs
Difference between TIMESTAMP (0) and TIMESTAMP (6)
Difference between UPI vs PI
Difference in days between two dates in a 360 day year with 30 day months
Difference ROW_NUMBER Vs RANK functions
DML Statements
DROP a column in a table
Drop multiple columns
DROP a CONSTRAINT in a table
DROP AUTHORIZATION
DROP CAST
DROP CAST with Data types
DROP ERROR TABLES
Drop Statistics on a column
DROP multi column statistics
Drop All Statistics
Drop index stats
DROP TABLE
DROPPING SECONDARY INDEX
EQUI JOIN
EQUI JOIN with USING construct
Error 3523: User does not have Select Grant Option on the table
Error 3806: Table/view/trigger name is ambiguous
ESCAPE Sequence
Escaping special character
EXCEPT
EXISTS
NOT EXISTS
EXP - Exponentiation
Explicit join condition
Implicit join condition
Exponentiation operator in teradata
EXTRACT
Failure 7547 Target row updated by multiple source rows
Failure due to unavailability of loader slots
FALLBACK
FALLBACK in Teradata
email
FIRST DAY of a MONTH
LAST DAY of a month
FIRST/LAST DAY of a MONTH in Teradata v15
first date of a month
Forcing CASE SPECIFIC
FORMAT while CREATING and SELECTING
FULL OUTER JOIN
Fully qualified name
Getting Current date and time
GLOP SETS
GROUP BY
HASH functions
Hashrow
Hashbucket
HASHAMP
HAVING - Retrieval with GROUP BY
HELPSTATS
HH:MI (Hour and Minutes format) in 24 hours time format
HH:MI (Hour and Minutes format) with AM, PM notification
How much space are your tables using?
How to find join indexes defined on your table
How to submit a BTEQ script in Batch mode
HYPERBOLIC Functions
COSH
SINH
TANH
ACOSH
ASINH
ATANH
IDENTITY column
NO CYCLE in Teradata
IN
NOT IN
INNER JOIN
INSERT records to a table
INSERT/SELECT
INSERT/SELECT - Making it faster
Integer to Time conversion
LEFT OUTER JOIN
Left Padding - Adds spaces or zeros at the start of the string
Right Padding - Add spaces or zeros at the end of the string
LENGTH
Length of data types
LIKE
LIKE with CASE SPECIFIC
LIKE for Range Of Values
LIKE for List Of Values
LIKE with ESCAPE SEQUENCE
LN - Natural log
LOG
LOWER
MAX
MAX() with group by
MIN
MAX
MINUS
Mod
MULTILOAD - Example
NATURAL JOIN
Nested CTE
NULL
Manipulating NULLS
Searching for Nulls and Non-Nulls Together
NULL with ORDER BY
NULL and Unique Indexes
NULL with COUNT(*)
NULLIFZERO
ZEROIFNULL
Nulls and Aggregate Functions
OR
ORDER BY
ORDER BY DESC
ORDER BY on two columns
Order of precedence
PERMANENT JOURNAL
BEFORE JOURNAL
AFTER JOURNAL
DUAL AFTER JOURNAL
DUAL BEFORE JOURNAL
PRODUCT JOIN
CROSS JOIN
Query to find SKEW FACTOR of a particular table
RANDOM
RANK
RELEASE MLOAD
Remove characters after "-"
Remove characters before"-"
Remove spaces in string
RENAME a column
RENAME a MACRO
RENAME a table
Replacing a string using oreplace
Removing any character in a string or column
Replacing a string in a column using oreplace
Return codes for severity errors
Returning multiple rows in one string ( In one row)
RIGHT OUTER JOIN
ROW_NUMBER
SELECT from a table
Selecting records using QUALIFY
SELF JOIN
SELF JOIN
Setting default DATABASE
SLEEP
SPARSE JOIN INDEX
SQRT - Square Root
STORED PROCEDURE
Creating STORED PROCEDURE
Modifying STORED PROCEDURE
Executing STORED PROCEDURE
Recompiling STORED PROCEDURE
Deleting STORED PROCEDURE
Renaming STORED PROCEDURE
Getting Stored Procedure Information
HELP on Stored Procedure Language (SPL)
SUBSTR
SUBSTRING
SUM
SUM with DISTINCT
SUM with GROUP BY
SYS_CALENDAR
TENACITY
TENACITY and SLEEP
teradata
TERADATA with JAVA
TIMESTAMP
Difference between TIMESTAMPS
Comparing TIMESTAMPS
To abort session without PEMON or TDManager
To check the rights given for a database for creating a table in it
To check whether a table is locked or not
To combine date and time into a timestamp
To find duplicates in a table
To find maximum length in a column
To find out the list of indexes used
To find previous month last date
To find current month first date
To find next month first date
To find next month last date
To find previous month first date
To find current month last date
To find the no of AMPs in the Teradata Database
To find the Table Space Size of your table across all AMPs
To find the Teradata release and version information from Data Dictionary table
To get all the column names used in database
To get all the tables
To get all views in Teradata
Including No Primary Index (NoPI) tables.
To get current database
To get highest n values from a table
To get SESSION number
To identify PPI columns
To list all the objects available in given database
To restart MULTILOAD if it fails
To Track Login Parameters of users
To view every column and the columns contained in indexes
TOP
TOP with PERCENT
To Select first N records from a table
TRANSACTION
BTEQ utility without explicit transaction
TRIM
LTRIM
RTRIM
Trimming Leading spaces
Trimming Trailing spaces
Trimming a character in a string
TRUNCATE
UNION
UNION ALL
UPDATE multiple columns from another table
UPDATE table
UPPER
WHERE
WHERE and HAVING in a SQL
Why BTEQ Scripts - What is the special in it ?