All forum activity

#DateUserForumTypeThreadPost
5804227 Jun 2016 @ 10:50 PDTtomnolanDatabaseReplyspecial char 0xFF convert to 0X1A with character set LATIN1_0A You mentioned that column specialchar is varchar(10), but what is its character set? Specifically, is the "specialchar" column declared as:   specialchar varchar(10) character...
5804127 Jun 2016 @ 09:16 PDTTDDeveloperToolsTopicHow do people handle no file found error in BTEQ IMPORT on Network Attached systems?When the IMPORT file is missing BTEQ issues an error and continues with the next SQL Statement in the Network attached system. In the mainframe systems this ab ends the script.  ...
5804027 Jun 2016 @ 05:38 PDTChiaraReplyDatabaseTopicWhat is the equivalent of "CONNECT_BY_ISCYCLE" in Teradata Hi    I must make a porting of a query in Oracle that it  contains the CONNECT_BY.     I know that in Teradata it is replaced with the WITH RECOURSIV...
5803927 Jun 2016 @ 04:46 PDTAtardecerR0j0DatabaseReplyAny benefit in NUSI on "customer_type" column?That NUSI doesn't look selective enough. Nevertheless you can create it, collect statistics on the index, and then do an explain referencing the NUSI. If the parser chooses a FTS over using the...
5803826 Jun 2016 @ 11:50 PDTdrmkd17DatabaseReplyHigh Skewfactor inspite of even distributionThanks for that piece of information.  Thanks Dieter!
5803726 Jun 2016 @ 11:28 PDTdnsmklDatabaseTopicAny benefit in NUSI on "customer_type" column?Hi, Is there any point/benefit in creating secondary index on column, which has low number of distinct values compared to size of the table. Hypothetical example: CREATE TABLE CUSTOMER (...
5803626 Jun 2016 @ 11:02 PDTdnoethDatabaseReplyHigh Skewfactor inspite of even distributionSince TD12 all dbc-views without V/VX were legacy because they return CHAR(30) LATIN instead of the new VARCHAR(128) UNICODE, i.e. compatibilty views. TD14.10 finally enabled long object names, so...
5803526 Jun 2016 @ 10:35 PDTdrmkd17DatabaseReplyHigh Skewfactor inspite of even distributionYes Dieter. That solved my problem. How are dbc.tablesize and dbc.tablesizev different?? Will have to find this out. Thanks a lot!
5803426 Jun 2016 @ 09:53 PDTSG255017DatabaseTopicPackdisk Performance QueryHi All Is it possible to run packdisk on multiple tables at a time? If yes could you please share the steps in Ferret.(fyi...I know the steps for single table packdisk) Please also let me know wh...
5803326 Jun 2016 @ 07:49 PDTnealvennaDatabaseReplyunix timestamp with timezone to teradata timestampThanks Dieter
5803226 Jun 2016 @ 04:35 PDTdnoethDatabaseReplyNOT NULL still retrieves NULLAre you sure that '?' is actually a NULL and not a literal question mark? I usually display NULLs as <<NUL>> to avoid confusion...
5803126 Jun 2016 @ 04:31 PDTdnoethDatabaseReplyHigh Skewfactor inspite of even distributionIs the tablename longer than 30 characters? You're using dbc.TableSize instead of dbc.TableSizeV.
5803026 Jun 2016 @ 04:29 PDTdnoethDatabaseReplyglobal parameters or variables in Teradata?You need a Stored Procedure using Dynamic SQL, Teradata simly doesn't allow a variable for TOP or SAMPLE.  
5802926 Jun 2016 @ 04:22 PDTdnoethDatabaseReplyPRESERVING A SPACE IN A LIKE STATEMENTHow do you submit it? Can you show the actual WHERE-conditon?
5802826 Jun 2016 @ 04:21 PDTdnoethDatabaseReplyunix timestamp with timezone to teradata timestampA Unix epoch doesn't hava a timezone, it's based on UTC.  Your timestamp simply includes milliseconds, your caluclation can be simplyfied to: -- assuming your epoch column is a BIG...
5802726 Jun 2016 @ 12:58 PDTM.Saeed KhurramGeneralReplysteps to install td-ttu-15.10.05_for_WindowsHi, Installation of TTU on windows is very straight forward. Just click on TTU_Base.exe and follow the step on screen. No special configuration required. It will install all the basic utilite...
5802626 Jun 2016 @ 12:35 PDTM.Saeed KhurramAsterReplyINSERT undocumented syntaxHi, This is already documented in the Aster_Database_User_Guide. You can either use Values or query. Br, Khurram
5802525 Jun 2016 @ 10:46 PDTtonez01ToolsTopicFastExport : SET SESSION SEARCHUIFDBPATHHi, How do I go about issuing a SET SESSION SEARCHUIFDBPATH for a UIF in a fastexport?    thanks
5802425 Jun 2016 @ 04:28 PDTfgrimmerTeradata StudioReplyTeradata studio installation is failing...ap, You can download Teradata Express as a test Teradata Database. Please refer to the Developer Exchange Download page.
5802325 Jun 2016 @ 10:13 PDTrharitha7GeneralTopicsteps to install td-ttu-15.10.05_for_WindowsHi,   I've installed td-ttu-15.10.05_for_Windows and extracted the zip file. can someone please share me the steps to install td-ttu-15.10.05_for_Windows.which setup file has t...
5802225 Jun 2016 @ 04:42 PDTQaisar KianiDatabaseReplyHow to insert recursive query answerset to another tableAll the columns selected at the end of recursive query are inserted in the table. If you want to insert some specific columns then select only those ones.
5802124 Jun 2016 @ 02:45 PDTnealvennaDatabaseReplyunix timestamp with timezone to teradata timestampHi all Below code worked for me.   sel  TO_TIMESTAMP( CAST( ( 1466017810720 - 1466017810720 MOD 1000 ) / 1000 AS BIGINT)  ) + ( 1466017810720 MOD 1000 * INTERVAL '0...
5802024 Jun 2016 @ 02:08 PDTnealvennaDatabaseTopicunix timestamp with timezone to teradata timestampHi all,  I have unix epcoh timestamp with timezone and it needs to be converted to teradata timestamp(6). I have tried to solve this by seeing old posts in teradata forums, but none...
5801924 Jun 2016 @ 01:52 PDTrnadjafiDatabaseReplyPRESERVING A SPACE IN A LIKE STATEMENTThat's not working for me.  Somehow it trims the space.  
5801824 Jun 2016 @ 01:13 PDTcdorgerDatabaseTopicglobal parameters or variables in Teradata?Does Teradata have global parameters or global variables?  I want to take a sample from a table where the sample size is a multiple of the number of rows in another, existing, table: creat...

Pages