この例のスクリプトでは、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.00.00.00 = = Platform WIN 64-bit = = PID 9396 = = = ======================================================================== = = = Copyright 1997-2019 Teradata Corporation. ALL RIGHTS RESERVED. = = = ======================================================================== **** 04:11:13 UTY2411 Processing start date: WED APR 24, 2019 ======================================================================== = = = Logon/Connection = = = ======================================================================== 0001 .LOGTABLE TPLOG0096; 0002 .LOGON 10.25.44.21/TPUSER,; **** 04:11:13 UTY8400 Teradata Database Release: 17.00.00.00 **** 04:11:13 UTY8400 Teradata Database Version: 17.00.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 'TPUSER.TPLOG0096' 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 - WED APR 24, 2019 . End : 04:11:16 - WED APR 24, 2019 . Highest return code encountered = '0'.