PowerCenter
- PowerCenter 10.5
- All Products
Control File Statement
| Description
|
---|---|
.LOGTABLE utillog;
| The restart logtable name.
|
LOGON tdpz/user,pswd;
| The database login string, including the database, user name, and password.
|
BEGIN EXPORT
| The first export command.
|
.SESSIONS 20;
| The number of Teradata sessions.
|
.EXPORT OUTFILE ddname2;
| The destination file for the exported data.
|
SELECT EmpNo, Hours FROM charges
| The SQL statements to select data.
|
WHERE Proj_ID = 20
| -
|
ORDER BY EmpNo ;
| -
|
.END EXPORT ;
| Indicates the end of an export task and initiates the export process.
|
LOGOFF ;
| Disconnect from the database.
|