テーブルを作成し、構文に挿入します(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