表の作成と構文の挿入 - Geospatial Utilities

Teradata® Geospatial Utilitiesユーザー ガイド

Product
Geospatial Utilities
Release Number
17.20
Published
2022年6月
Language
日本語
Last Update
2022-08-22
dita:mapPath
ja-JP/ygh1641301476787.ditamap
dita:ditavalPath
ja-JP/obe1474387269547.ditaval
dita:id
B035-2519
Product Category
Teradata Tools and Utilities

テーブルを作成し、構文に挿入します(POINTデータ型をST_Geometry列に)。

CREATE TABLE customers(pkey integer, cust_name VARCHAR(10),cust_zipcode VARCHAR(5) , loc ST_Geometry);
INSERT INTO customers(0, 'Fred Smith', '91234', new ST_Geometry('POINT(20.34 80.78)'));
INSERT INTO customers(1, 'Richard Connor', '95421', new ST_Geometry('POINT(20.56 89.44)'));
INSERT INTO customers(2, 'Anita Johnson', '98523', new ST_Geometry('POINT(19.12 88.22)'));
INSERT INTO customers(3, 'Mary Willow', '90642', new ST_Geometry('POINT(21.45 88.12)'));

以下は、ソース テーブルを作成し、TDGeoExport操作のST_Geometry列データをテーブルに入力するためのBTEQの例です。

C:\Program Files\Teradata\Client\17.20\bin>bteq .logon NODEID/dbc,dbc

 Teradata BTEQ 17.20.00.01 (64-bit) for WIN64. PID: 956
 Copyright 1984-2022 Teradata. All rights reserved.
 Enter your logon or BTEQ command:

.logon NODEID/dbc,

 *** Logon successfully completed.
 *** Teradata Database Release is 17.10.03.01
 *** Teradata Database Version is 17.10.03.01
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 3 seconds.

 BTEQ -- Enter your SQL request or BTEQ command:
database geouser;

database geouser;

 *** New default database accepted.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
CREATE TABLE customers (pkey integer, cust_name VARCHAR(10), cust_zipcode V
ARCHAR(5) , loc ST_Geometry);

CREATE TABLE customers (pkey integer, cust_name VARCHAR(10), cust_zipcode V
ARCHAR(5) , loc ST_Geometry);

 *** Table has been created.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO customers(0, 'Fred Smith', '91234', new ST_Geometry('POINT (20.
34 80.78)'));

INSERT INTO customers(0, 'Fred Smith', '91234', new ST_Geometry('POINT (20.
34 80.78)'));

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO customers(1, 'Richard Connor', '95421', new ST_Geometry('POINT (20.56 89.44)'));

INSERT INTO customers(1, 'Richard Connor', '95421', new ST_Geometry('POINT
(20.56 89.44)'));

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO customers (2, 'Anita Johnson', '98523', new ST_Geometry( 'POINT(19.12 88.22)'));

INSERT INTO customers (2, 'Anita Johnson', '98523', new ST_Geometry( 'POINT
(19.12 88.22)'));

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO customers(3, 'Mary Willow', '90642', new ST_Geometry('POINT (21.45 88.12)'));

INSERT INTO customers(3, 'Mary Willow', '90642', new ST_Geometry('POINT (21
.45 88.12)'));

 *** Insert completed. One row added.
 *** Total elapsed time was 1 second.


 BTEQ -- Enter your SQL request or BTEQ command:
sel * from customers;

sel * from customers;

 *** Query completed. 4 rows found. 4 columns returned.
 *** Total elapsed time was 1 second.

       pkey cust_name  cust_zipcode loc
----------- ---------- ------------ ---------------------------------------
          3 Mary Willo 90642        POINT (21.45 88.12)
          0 Fred Smith 91234        POINT (20.34 80.78)
          1 Richard Co 95421        POINT (20.56 89.44)
          2 Anita John 98523        POINT (19.12 88.22)

 BTEQ -- Enter your SQL request or BTEQ command:
.logoff;

.logoff;
 *** You are now logged off from the DBC.
 Teradata BTEQ 17.20.00.01 (64-bit) for WIN64. Enter your logon or BTEQ command:
.quit;

.quit;
 *** Exiting BTEQ...
 *** RC (return code) = 0