Teradata FastExport - Part 2

Teradata FastExport Sample Script

.LOGTABLE MYDB.STUDENT; /* define restart log */
.LOGON ip_address/username,password; /* DBC logon string*/

.BEGIN EXPORT SESSIONS 10; /* begin export with number of sessions to be used */ 
.EXPORT OUTFILE filepath/output.txt mode record format text; /* identify the destination */

SELECT ((TRIM((COALESCE("TITLE",''))))
 ||'|'||
(TRIM((COALESCE("FIRST_NAME",''))))
 ||'|'||
(TRIM((COALESCE("LAST_NAME",''))))
 ||'|'||
(TRIM((COALESCE("MIDDLE_NAME",''))))
 ||'|'||
(TRIM((COALESCE("EMAIL_ID",''))))
 ||'|'||
(TRIM((COALESCE("MOBILE_NUMBER",''))))
 ||'|'||
(TRIM((COALESCE("MARKS",''))))
 ||'|'||
(TRIM((COALESCE("PERCENT_MARKS",''))))
)(TITLE '') FROM MYDB.STUDENT;

.END EXPORT ; /* terminate the export */
.LOGOFF ; /* disconnect from the DBS */

FASTEXPORT COMMANDS:-

Task Commands-

BEGIN EXPORT	Begins the export task and sets the specifications for the number of sessions with Teradata.
END EXPORT	Ends the export task and initiates processing by Teradata.
EXPORT	Provides two things which are: The client destination and file format specifications for the export data retrieved from Teradata A generated MultiLoad script file that can be used later to reload the export data back into Teradata
FIELD	Constitutes a field in the input record section that provides data values for the SELECT statement.
FILLER	Specifies a field in the input record that will not be sent to Teradata for processing. It is part of the input record to provide data values for the SELECT statement.
IMPORT	Defines the file that provides the USING data values for the SELECT.
LAYOUT	Specifies the data layout for a file. It contains a sequence of FIELD and FILLER commands. This is used to describe the import file that can optionally provide data values for the SELECT.

SQL Commands-

ALTER TABLE	Change a column or table options of a table.
CHECKPOINT	Add a checkpoint entry in the journal table.
COLLECT STATISTICS	Collect statistics for one or more columns or indexes in atable
COMMENT	Store or retrieve a comment string for a particular object.
CREATE DATABASE	Creates a new database.
CREATE TABLE	Creates a new table.
CREATE MACRO	Creates a new macro.
DELETE	Delete rows from a table.
DROP DATABASE	Drops a database
DATABASE	Specify a default database for the session.
GIVE	Transfer ownership of a database or user to another user.
DELETE DATABASE	Removes all tables, views, macros, and stored procedures from a database.
GRANT	Grant access privileges to an object.
UPDATE	Change a column value of an existing row or rows in a table.

Post Views: 1,777

You may also like this!