All forum activity

#DateUserForumTypeThreadPost
5909411 Aug 2016 @ 02:32 PDTAtardecerR0j0DatabaseReplyCapturing Versions when there is a Change in a Column Value else keep the Earliest if ConsecutiveVery important: Read the documentation to understand Row_Number and min functions http://www.info.teradata.com/htmlpubs/DB_TTU_15_10/index.html#page/SQL_Reference/B035_1145_151K/ROW_NUMBER.html A...
5909311 Aug 2016 @ 02:09 PDTspetmpUDAReplyCast and format hi, I want to diplay 011 as 'zero one one ' in teradata. can you help me out !! eg: 011- i need to display as 'zero one one' 012- i need to display as 'zero one two' like...
5909211 Aug 2016 @ 01:47 PDTsam141988DatabaseTopicCapturing MAX marks for Each Student when the MArks are in Columns  Consider the Below Scenario  - ID|MATHS|PHYSICS|CHEMISTRY 1|50|60|70 2|70|60|40 3|50|80|70 4|50|100|70 5|90|60|70   I want to get the Result where it will display the maxi...
5909111 Aug 2016 @ 01:42 PDTsam141988DatabaseReplyCapturing Versions when there is a Change in a Column Value else keep the Earliest if ConsecutiveHi @AtardecerR0j0  Thank You So Much for the Solution this is Exactly what i was looking for !  I am New to Teradata can you please explain me once how it is working in Steps?   ...
5909011 Aug 2016 @ 01:41 PDTsharonnTeradata StudioTopicWhy is the first dynamic result set in a procedure is empty?Hi,   I have a procedure that has 1 dynamic result set defined in it. When i call the procedure from TD studio i get 2 result sets: 1) Empty - no rows and no columns 2) My result set Whe...
5908911 Aug 2016 @ 01:21 PDTstami27ToolsReplyTPT load failure - Please suggestAnyway, I thank you. I have seen, there are some Linux tools with newer version on the Teradata SW Server.. I'll install it first and try again. GSC recommends in the incident setting env...
5908811 Aug 2016 @ 12:31 PDTAtardecerR0j0DatabaseReplyLock a table row by rowhashYes it is possible, here you have an example: BT; LOCKING ROW FOR WRITE SELECT NULL FROM TABLE1 WHERE COL1 = 'XXXX'; .... ET; If one session has 1 rowhash blocked and another one do ...
5908711 Aug 2016 @ 12:03 PDTAtardecerR0j0DatabaseReplyCapturing Versions when there is a Change in a Column Value else keep the Earliest if Consecutive drop table table1; create multiset volatile table table1 ( id integer, start_date timestamp, valor decimal (5,2) )primary index( id ) on commit preserve rows; insert into table1 values(...
5908610 Aug 2016 @ 10:32 PDTsureshb79ConnectivityTopicTeradata Presto Driver Connectivity INT Datatype LimitationHello, We are using Teradata ODBC driver for Presto to connect to Hive data. We observed that, SELECT query with INTEGER Column just hungs.  If we cast the column with Varchar/BIGINT we are ...
5908510 Aug 2016 @ 09:00 PDTzakywAsterReplyAlternative to Strtok in Teradata AsterHy Dieter i want to ask you something about error in aster  i've a problem with the query extract load from teradata to aster , but any something wrong with this query ,  -- que...
5908410 Aug 2016 @ 08:48 PDTzakywAnalyticsReplyQUERY IN ASTER Hy guys i want to ask you something about error in aster  i've a problem with the query extract load from teradata to aster , but any something wrong with this query ,  -- query fo...
5908310 Aug 2016 @ 06:10 PDTPrivate Forum
5908210 Aug 2016 @ 03:56 PDTsrikanth471DatabaseTopicTimeZone conversionHi All,   I have a scenario here as below   TAB1 has 100Bn rows with timestamp(RPTG_TS) in 'America Pacific' and need to convert this timestamp column to GMT timestamp. For n...
5908110 Aug 2016 @ 03:25 PDTBRIANHToolsReplyARCMAINOK.. finally resorted to a recycle of Teradata and Windows... reran my Arcmain scripts as is and voila.... success.... go figure that....I'll certainly keep close watch on my arc jobs and see i...
5908010 Aug 2016 @ 02:08 PDTfranceszhuDatabaseTopicHow to add a new spatial reference system to SYSSPATIAL.SPATIAL_REF_SYSI want to add a new SRS record to the table SYSSPATIAL.SPATIAL_REF_SYS. However, the manual doesn't have more description on it. There are 4 columns in the table: SRID: Spatial re...
5907910 Aug 2016 @ 01:24 PDTBRIANHToolsTopicARCMAINI have attempted several times to run some ARCMAIN tests under Windows 10 via a batch job and have failed. The .BAT file is this :    ARCMAIN CHECKPOINT=50 OUTLOG=ARCALL.OUT <...
5907810 Aug 2016 @ 12:58 PDTgp19380ConnectivityTopicODBC Driver Suite - Windows 2008 missing for v14.10 https://downloads.teradata.com/download/connectivity/odbc-driver/windows           I am trying to download version 14.10.17 driver but I noticed ...
5907710 Aug 2016 @ 12:52 PDTblue_eyed_byteDatabaseReplyOptions to compare contents of two tablesThanks Inguva!
5907610 Aug 2016 @ 11:46 PDTfeinholzToolsReplyTPT load failure - Please suggestSince an incident has been opened for this, I will let the GSC handle it for now. If they need to come to engineering, then I will get involved to help them. (That message it provided by the DBS ...
5907510 Aug 2016 @ 08:20 PDTPrivate Forum
5907410 Aug 2016 @ 07:18 PDTDinesh1975ToolsTopicbteq help neededI am new  to TD. Can someone please tell me what this line does. bteq << !  >> /export/home/din/dba/dbc_hist.log_ 'date '+%m%d%y_%H%M' '   2>&...
5907310 Aug 2016 @ 05:51 PDTabhishank18UDAReplyBT/ETHi, While submitting request as BT;stmt 1;stmt 2;stmt 3;ET; in Teradata SQL ASSISTANT and Unix has different behaiour, in SQL ASSISTANT after failure of one statement transaction rollsback but...
5907210 Aug 2016 @ 03:16 PDTsam141988DatabaseTopicCapturing Versions when there is a Change in a Column Value else keep the Earliest if ConsecutiveHi Experts Can you All please suggest how this can be achived in TD- Consider the Sample Source Data - ID|START_DATE|VALUE 110333005|2000-05-03 00:00:00.000000|0.00 110333005|2014-01-08 12:38:4...
5907110 Aug 2016 @ 02:33 PDTInguvaDatabaseReplyOptions to compare contents of two tablesIn our project we use minus, so i feel its good way.
5907010 Aug 2016 @ 02:25 PDTvijitvHadoopTopicTDCH to Hive inserts NULL valuesI have been trying to import Teradata Tables into Hive using the TDCH utility. The utility seems to be working fine since the connection is successful. However after the job completes and when I ch...

Pages