# スペース計算の例 - Parallel Data Pump

## Teradata® Parallel Data Pump リファレンス

Product
Parallel Data Pump
Release Number
17.00
Published
2020年6月
Language

Last Update
2021-01-07
dita:mapPath
ja-JP/ioq1544831946920.ditamap
dita:ditavalPath
ja-JP/ioq1544831946920.ditaval
dita:id
B035-3021
Product Category

```LOGTABLE CME.TLddNT14H;
.LOGON OPNACC1/CME,CME;
DROP TABLE TBL14TA;
DROP TABLE TBL14TB;
DROP TABLE tlnt14err;
CREATE TABLE TBL14TA,FALLBACK
(ABYTEINT BYTEINT,
ASMALLINT SMALLINT,
AINTEGER  INTEGER,
ACHAR     CHAR (5),
ABYTE     BYTE(1),
AFLOAT     FLOAT,
UNIQUE PRIMARY INDEX (ASMALLINT);
CREATE TABLE TBL14TB,FALLBACK
(ABYTEINT BYTEINT,
ASMALLINT SMALLINT,
AINTEGER  INTEGER,
ACHAR     CHAR (5),
ABYTE     BYTE(1),
AFLOAT     FLOAT,
UNIQUE PRIMARY INDEX (ASMALLINT);
/*****************************************************************/
/* BEGIN TLOAD WITH ALL THE OPTIONS SPECIFIED SUCH AS ERRLIMIT, **/
/* CHECKPOINT, SESSIONS,TENACITY                                **/
/*****************************************************************/
.BEGIN LOAD ERRLIMIT 5 CHECKPOINT 15 SESSIONS 4 1 TENACITY 2
ERRORTABLE tlnt14err ROBUST ON PACK 20;
.LAYOUT LAY1A;
.FILLER ATEST    *  BYTEINT;
.FIELD ABYTEINT  *  BYTEINT;
.FIELD ASMALLINT *  SMALLINT;
.FIELD AINTEGER  *  INTEGER;
.FIELD ACHAR     *  CHAR (5);
.FIELD ABYTE     *  BYTE(1);
.FIELD AFLOAT    *  FLOAT;
.DML LABEL LABELA IGNORE DUPLICATE ROWS IGNORE MISSING ROWS
IGNORE EXTRA ROWS;
.DML LABEL LABELB IGNORE DUPLICATE ROWS IGNORE MISSING ROWS
IGNORE EXTRA ROWS;
.IMPORT INFILE ./tlnt014.dat
LAYOUT LAY1A FROM 1 FOR 400
APPLY LABELA WHERE ATEST = 1
APPLY LABELB WHERE ATEST = 2;