![]() |
--create table CREATE SET TABLE database.table, NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT MERGEBLOCKRATIO ( some columns..., unique_number_10_digits CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL ) PRIMARY INDEX( unique_number_10_digits ); --inserts
10 Jul 2016
| 4 comments
,
|
![]() |
When I run the create statement got this error. I know that table name or column name should be less than 30 characters.
29 May 2016
| 2 comments
,
|
![]() |
I'm trying to create a table, using a SELECT state, but that also has the LOAD_USER and LOAD_DATE with defaults to CURRENT_USER and CURRENT_TIMESTAMP. If I was creating the table, then adding the data, the text for the two fields would be; ADD LOAD_USER2 CHAR(20) CHARACTER SET LATIN CASESPECIFIC DEFAULT USER,
03 Feb 2016
| 1 comment
,
|
![]() |
Hi Experts, CREATE volatile TABLE my_table (eno INTEGER, edata JSON(100)) on commit preserve rows; Error: Teradata SQL Assistant ---------------------------
16 Sep 2015
| 1 comment
,
|
![]() |
Hi all,
10 Sep 2015
| 2 comments
,
|
![]() |
Hi ,
17 Feb 2015
,
|
![]() |
Hi everyone,
18 Sep 2014
| 10 comments
,
|
![]() |
Hi everyone,
19 Aug 2014
| 3 comments
,
|
![]() |
Hi All!
02 Jul 2014
| 3 comments
,
|
![]() |
Get a quick start on Teradata Studio and Teradata Studio Express with these usage videos. The overview and connection videos apply to both Teradata Studio and Teradata Studio Express. The others apply to Teradata Studio only: Create Database, Create Table, Move Space, Smart Loader, Copy Objects, and Transfer Data.
11 Nov 2013
| 6 comments
,
|
![]() |
Anyone could explain what this error means? Thanks!
24 May 2013
| 2 comments
,
|
![]() |
Hi all,
24 Apr 2013
| 1 comment
,
|
![]() |
I am trying to put into a table the output from a previous query (saved as a volatile table). I am creating a new table PROC_STATS to hold the output and then using INSERT INTO followed by a SELECT query to get the data inot PROC_STATS. When I run the code in SQL Assistant, I get a message that 1 row was returned, which is the correct value. However, w
16 Apr 2013
| 1 comment
,
|
![]() |
Hi All
27 Feb 2013
| 9 comments
,
|
![]() |
Hello,
22 Feb 2013
| 3 comments
,
|
![]() |
Hi, I am trying to create a procedure that contains a while loop to continuously run several updates/drop tables/create tables based on some conditions that are calculated at the end. If the conditions (based on the last tables that are created) are not met, the loop continues to run.
05 Jun 2012
,
|
![]() |
|
![]() |
The following information covers a handful of the basics of the Teradata architecture, to help new Teradata users better understand what considerations should go into creating a table.
04 Jan 2011
| 18 comments
,
|
![]() |
Hey, Anyone know how to create a table using a view (Structure & Data)? Also, is there anyway to retrieve the DDL for the tables or views we have access to? Thanks, -Ayyad
03 Feb 2010
| 2 comments
,
|
![]() |
The purpose of the new Teradata 13.0 feature that allows you to create tables with no primary index is improved performance of FastLoad and Teradata Parallel Data Pump Array INSERT data loading operations.
09 Apr 2009
| 13 comments
,
|