Create table and insert syntax (POINT type data into ST_Geometry column):
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)'));
The following is a BTEQ example to create the source table and populate the table with ST_Geometry column data for TDGeoExport operation:
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