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: 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 |
|
GRANT |
Grant access privileges to an object. |
|
UPDATE |
Change a column value of an existing row or rows in a table. |
Whe I am trying to use a float value, suppose 0.00, the result comes out to be 0.000E000 kind. Any solution for that?
Hi Yogesh,
Can you please try to you your float column as below-
(TRIM((COALESCE(“Column_Name”,”))))/1.00