この例のスクリプトでは、TABLEコマンドと「INSERT <TABLENAME>.*」機能を使用します。
.LOGTABLE TPLOG0096; .LOGON NODEID/HEMANTHDB,HEMANTHDB; DROP TABLE TPTBL0096; DROP TABLE TPERR0096; CREATE TABLE TPTBL0096, FALLBACK( F0 integer, F1 integer, F2 integer, F3 CHAR(38)) UNIQUE PRIMARY INDEX (F0); .BEGIN LOAD SESSIONS 8; .LAYOUT LAY0096; .TABLE TPTBL0096; .DML LABEL LABEL0096 ; INSERT INTO TPTBL0096.*; .IMPORT INFILE datafile1 LAYOUT LAY0096 APPLY LABEL0096 FROM 1 THRU 111; .END LOAD; .LOGOFF; 12:58 PM 2/6/2014
次のような結果となります。以下の結果を確認する際、TABLEコマンドで生成された出力フィールド内で、テーブルの基本索引からのフィールドに対して"KEY"修飾子が含まれていることに着目してください。これにより、"SERIALIZE"オプションの使用が可能になります。
========================================================================
= =
= Teradata Parallel Data Pump Utility Release 17.20.00.02 =
= Platform WIN 64-bit =
= PID 14184 =
= =
========================================================================
= =
= Copyright 1997-2022 Teradata. All rights reserved. =
= =
========================================================================
**** 04:11:13 UTY2411 Processing start date: FRI MAY 20, 2022
========================================================================
= =
= Logon/Connection =
= =
========================================================================
0001 .LOGTABLE TPLOG0044;
0002 .LOGON NODEID/FLUSER,;
**** 04:11:13 UTY8400 Teradata Database Release: 17.20.00.00
**** 04:11:13 UTY8400 Teradata Database Version: 17.20.00.00
**** 04:11:13 UTY8400 Default character set: ASCII
**** 04:11:13 UTY8400 Current RDBMS has UDT support
**** 04:11:13 UTY8400 Current RDBMS has Large Decimal support
**** 04:11:13 UTY8400 Current RDBMS has Statement Info Parcel support
**** 04:11:13 UTY8400 Maximum supported buffer size: 1M
**** 04:11:13 UTY8400 Upsert supported by RDBMS server
**** 04:11:13 UTY8400 Data Encryption supported by RDBMS server
**** 04:11:13 UTY8400 Array Support supported by RDBMS server
**** 04:11:13 UTY8400 Statement Independence supported by RDBMS server
**** 04:11:13 UTY6211 A successful connect was made to the RDBMS.
**** 04:11:13 UTY6217 Logtable 'FLUSER.TPLOG0044' has been created.
========================================================================
= =
= Processing Control Statements =
= =
========================================================================
0003 DROP TABLE TPTBL0096;
**** 04:11:13 UTY1016 'DROP' request successful.
0004 DROP TABLE TPERR0096;
**** 04:11:13 UTY1008 RDBMS failure: 3807, Object 'TPERR0096' does not exist.
0005 CREATE TABLE TPTBL0096, FALLBACK(
F0 integer, F1 integer,
F2 integer, F3 CHAR(38))
UNIQUE PRIMARY INDEX (F0);
**** 04:11:13 UTY1016 'CREATE' request successful.
0006 .BEGIN LOAD SESSIONS 8;
=======================================================================
= =
= Processing TPump Statements =
= =
=======================================================================
0007 .LAYOUT LAY0096;
0008 .TABLE TPTBL0096;
**** 04:11:14 UTY6009 Fields generated by .TABLE command begin.
**** 04:11:14 UTY6010 *** .FIELD F0 * INTEGER KEY;
**** 04:11:14 UTY6010 *** .FIELD F1 * INTEGER;
**** 04:11:14 UTY6010 *** .FIELD F2 * INTEGER;
**** 04:11:14 UTY6010 *** .FIELD F3 * CHAR(38) MACROCHARSET LATIN;
**** 04:11:14 UTY6011 Fields generated by .TABLE command end.
0009 .DML LABEL LABEL0096 ;
0010 INSERT INTO TPTBL0096.*;
0011 .IMPORT INFILE datafile1
LAYOUT LAY0096
APPLY LABEL0096 FROM 1 THRU 111;
0012 .END LOAD;
**** 04:11:14 UTY6609 Starting to log on sessions...
**** 04:11:15 UTY6610 Logged on 8 sessions.
========================================================================
= =
= TPump Import(s) Beginning =
= =
========================================================================
**** 04:11:15 UTY6630 Options in effect for following TPump Import(s):
. Tenacity: 4 hour limit to successfully connect load sessions.
. Max Sessions: 8 session(s).
. Min Sessions: 6 session(s).
. Checkpoint: 15 minute(s).
. Errlimit: No limit in effect.
. Restart Mode: ROBUST.
. Serialization: OFF.
. Packing: 20 Statements per Request.
. StartUp Rate: UNLIMITED Statements per Minute.
**** 04:11:15 UTY8802 WARNING: Rate Monitoring turned off - database
TPumpMacro does not exist.
**** 04:11:15 UTY6608 Import 1 begins.
**** 04:11:16 UTY6641 Since last chkpt., 111 recs. in, 111 stmts., 6 reqs
**** 04:11:16 UTY6647 Since last chkpt., avg. DBS wait time: 96.17
**** 04:11:16 UTY6612 Beginning final checkpoint...
**** 04:11:16 UTY6641 Since last chkpt., 111 recs. in, 111 stmts., 6 reqs
**** 04:11:16 UTY6647 Since last chkpt., avg. DBS wait time: 96.17
**** 04:11:16 UTY6607 Checkpoint Completes with 111 rows sent.
**** 04:11:16 UTY6642 Import 1 statements: 111, requests: 6
**** 04:11:16 UTY6643 Import 1 average statements per request: 18.50
**** 04:11:16 UTY6644 Import 1 average statements per record: 1.00
**** 04:11:16 UTY6645 Import 1 statements/session: avg. 13.88, min. 0.00, max.
20.00
**** 04:11:16 UTY6646 Import 1 requests/session: average 0.75, minimum 0.00,
maximum 1.00
**** 04:11:16 UTY6648 Import 1 DBS wait time/session: avg. 72.13, min. 0.00,
max. 405.00
**** 04:11:16 UTY6649 Import 1 DBS wait time/request: avg. 72.13, min. 0.00,
max. 405.00
**** 04:11:16 UTY1823 Import processing statistics
. IMPORT 1 Total thus far
. ========= ==============
Candidate records considered:.... 111 111
Apply conditions satisfied:...... 111 111
Records logable to error table:.. 0 0
Candidate records rejected:...... 0 0
**** Statistics for Apply Label : LABEL0096
Type: I
Database: TPUSER
Table or Macro Name: TPTBL0096
Activity: 111
**** 04:11:16 UTY6677 Loading phase statistics
Elapsed time: 00:00:00:01(dd:hh:mm:ss)
CPU time: 0 Seconds
MB/sec: 0.00555
MB/cpusec: N/A
**** 04:11:16 UTY0821 Error table TPUSER.M20160729_041114_11655_001_ET is
EMPTY, dropping table.
0013 .LOGOFF;
========================================================================
= =
= Logoff/Disconnect =
= =
========================================================================
**** 04:11:16 UTY6216 The restart log table has been dropped.
**** 04:11:16 UTY6212 A successful disconnect was made from the RDBMS.
**** 04:11:16 UTY2410 Total processor time used = '1.12321 Seconds'
. Start : 04:11:13 - FRI MAY 20, 2022
. End : 04:11:16 - FRI MAY 20, 2022
. Highest return code encountered = '0'.