![]() |
--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
,
|
![]() |
|
![]() |
Consider two tables ,one has COLUMN_A defined as a VARCHAR(100) and the other has COLUMN_A defined as an INTEGER. When joining these two tables via COLUMN_A what does the optimizer have to do in order to accomplish the join?Convert VARCHAR to INTEGER or convert INTEGER to VARCHAR? thanks.
08 Dec 2014
| 1 comment
,
|
![]() |
Hello, Row number 26,237 had an error.
15 Oct 2014
| 19 comments
,
|
![]() |
Hi experts
05 Sep 2014
| 1 comment
,
|
![]() |
Hello,
12 Jun 2013
| 3 comments
,
|
![]() |
Hi ,
07 May 2013
,
|
![]() |
I need to store the value in the DataParcel column(which is of VARBYTE datatype) in the first error table of FASTLOAD into a permanent teradata table but with a proper format(The ddl of this table will be exactly the same as the target table, except that all datatypes are varchar)
04 May 2013
| 1 comment
,
|
![]() |
Hi, I am trying to import data from a text file using a SQLAssitant. But it is giving me an error as the string contains ",". CREATE VOLATILE TABLE kumar_test (a INTEGER, b VARCHAR(100)) PRIMARY INDEX ( a );
INSERT INTO kumar_test(?,?)
30 Apr 2013
| 3 comments
,
|
![]() |
Is there a way to convert string data into varbinary data type. I want to use the BYTE/BIT manipulation functions on a string column, but they can recieve only BYTEINT,INT, BIGINT and VARBYTE data types as arguments.
11 Apr 2013
| 14 comments
,
|
![]() |
I have strange problem. Consider below Teradata Stored Procedure:
27 Feb 2013
| 1 comment
,
|
![]() |
Hello, My table tbl has a column col which has the below definition:- I am trying to trim spaces on the data in the this col. I used TRIM and what I see in the result is that it trims leading spaces but not the trailing spaces. I have tried various combinations in the query below:- SEL COL,CHARACTER_LENGTH(COL),COL||'-',
06 Apr 2011
| 8 comments
,
|
![]() |
I have created a table with a column that is varchar(5). When I insert a string of 6 characters the string is truncated to 5 characters rather than throwing an exception. Is there a way to force a strict mode so this will result in an error? Jesse
29 Mar 2011
| 2 comments
,
|
![]() |
Hi All! I'm use Teradata ODBC driver ver. 13.10.00.01-1. I need to bind variables but I've got a problems with VARCHAR variables (the INTEGER or DOUBLE variables are OK) The source: SQLBindParameter(v_stmt->stmt, col->dbtype=SQL_VARCHAR;
09 Aug 2010
| 1 comment
,
|
![]() |
When creating tables in Teradata is there an advantage to placing the column(s) that will be used for the Primary Index at the top of the column list?
05 May 2010
| 2 comments
,
|