All forum activity

#DateUserForumTypeThreadPost
5951930 Aug 2016 @ 09:28 PDTaaibinderGeneralReplyLast 6 Month in Query - Failing on August 30Thank you!
5951830 Aug 2016 @ 09:21 PDTdnoethGeneralReplyLast 6 Month in Query - Failing on August 30This is not Teradata logic, it's stupid Standard SQL (In fact you can't use INTERVAL-syntax for both YEAR and MONTH). That's why there's ADD_MONTHS :-) WHERE DB.LOG_DATE > A...
5951730 Aug 2016 @ 09:06 PDTaaibinderGeneralTopicLast 6 Month in Query - Failing on August 30...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;   This has been working for weeks, until today. I wasn't sure what broke my script until I tried dropping the date requiremen...
5951630 Aug 2016 @ 08:47 PDTfeinholzToolsReplyAutomatic table creation based on the header in raw file during data loading data into Teradata using any load utilityTPT does not automatically create tables. The commands to create a table must be supplied by the user through the DDL operator.  
5951530 Aug 2016 @ 08:29 PDTEUshaToolsTopicAutomatic table creation based on the header in raw file during data loading data into Teradata using any load utilityHi, I have a set of CSV , XML, XLS data files available in a document library and the header (columns) will be different in each data file. I am trying to automatically load these data files into ...
5951430 Aug 2016 @ 08:24 PDTdnoethDatabaseReplyWhy does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop?Is your physical desktop running Suse Linux Enterprise? Most PCs got a Windows operating system and there's no (more) Teradata for Windows. Additionally it's more convenient to simply sta...
5951330 Aug 2016 @ 06:17 PDTLUCASViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?OK Todd,  so we experience an issue with ETL sessions remaining in response for hours (and days), each of them with big spool ... Thanks for clarification, Pierre  
5951230 Aug 2016 @ 05:57 PDTdastrauchConnectivityTopicquery newline vs carriage return issue using Perl unixODBC and RHELI have installed teradata 64bit drivers,  unixODBC 2.3.4 and perl DBD::ODBC 1.52 on  RHEL 6 linux. Everything is working with short single line queries from both isql and perl.  How...
5951130 Aug 2016 @ 05:50 PDTToddAWalterViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?The result spool is not sent to BYNet. The BYNet is sent a reference to it where it was created by the last step of the plan. The result spool stays in the user's spool space until it is releas...
5951030 Aug 2016 @ 05:21 PDTLUCASViewpointReplyIs there a way to control RESPONDING STATE of large extracts using TASM Exceptions?Hi all, i'm just looking for a clarification about the Spool displayed in Viewpoint portlet Query Monitor when a session is in a "response" state: Is that spool a Bynet owned spool,...
5950930 Aug 2016 @ 05:10 PDThv186006DatabaseReplyFormatting in TeradataGot it! Thats why my 999999999 resulted in leading zero's, because you then say it is mandatory to put a number on that position. Well, you made me and a client happy today, thanks and have a ...
5950830 Aug 2016 @ 04:57 PDTjuanalfonsoDatabaseTopicRemote desktop to TD Express 15.10 Virtual Machine is not workingHello, I'm using the TD Express 15.10 Virtual Machine but I've discovered that UltraVNC is not woking for doing a remote desktop from Windows. Could anyone tell me how to fix it? Th...
5950730 Aug 2016 @ 04:50 PDTjuanalfonsoDatabaseReplyTeradata: No more room in journal table for novaquality.journalsOk, Thanks!
5950630 Aug 2016 @ 04:47 PDTCarlosALDatabaseReplyFormatting in TeradataHi. G=Group Separator -(9)=Minus sign (if applicable) for 9 positions 9=Last number before decimal separator mandatory. D=Decimal Separator 9(2)= two decimal positions. Cheers. Carlos.
5950530 Aug 2016 @ 04:39 PDThv186006DatabaseReplyFormatting in TeradataTHANK YOU CARLOS!!!!! I understand the format mostly, only the part (9)9 not totally. Do you have an explanation for this? I saw that the format 'G-999999999D(9)2' fills up the positions ...
5950430 Aug 2016 @ 04:22 PDTThiru07ToolsReplyError Table MloadHi Ivyuan , Adding all the details below.   $ mload < prepd.mload.ctl      ======================================================================== &nbs...
5950330 Aug 2016 @ 04:16 PDTCarlosALDatabaseReplyFormatting in TeradataHi Have you tried FORMAT 'G-(9)9D9(2)' ? HTH. Cheers. Carlos.
5950230 Aug 2016 @ 02:19 PDThv186006DatabaseTopicFormatting in TeradataHi guys, New on Teradata. For a client I am trying to format some numbers. The wish is to paste the string 'EUR' to a value as follows. EUR 0.32 EUR 0.00 EUR 189.56 EUR 1,234.87  ...
5950130 Aug 2016 @ 01:58 PDTpbvillafloresToolsReplyFastExport Remove Binary/Indicator Values in Outmod Is there an example of OUTMOD somewhere that I can reference?
5950030 Aug 2016 @ 01:47 PDTsubhayuDatabaseTopicWhy does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop?Hi I have a basic question - Why does Teradata Express come only as a VM component? Why not as a standalone software to be installed on physical desktop? Is it because the internal AMP-VPROC...
5949929 Aug 2016 @ 11:29 PDTThiru07ToolsReplyError Table MloadHi Ivyuan, Cingular_BID.txt data file contains pipe delimited records as below. U|3168372484|3043606542|3043606542|75|Terminating|0|20160802000529|-05:00|20160802050529|Peak|13044126356|1...
5949829 Aug 2016 @ 08:42 PDTIvyuanToolsReplyError Table MloadHi, 1. Can you let us know the error code recorded in the error table? If it is in the Application Error Table, the column name is DBCErrorCode; If it is in the Acquisition Error Table, the colu...
5949729 Aug 2016 @ 08:36 PDTCvinodhToolsTopicTDCH error limit for Export from HDFS with method batch.insertI am trying to load data from HDFS/Hive into Teradata using the method batch.insert.  Is there a way to set errorlimit property for the load so that the job will not fail when X-1 or lesser r...
5949629 Aug 2016 @ 04:27 PDTfgrimmerTeradata StudioReplyViews the rows being transferred overFarah,  The Transfer Progress View shows the start time, elapsed time as the transfer occurs, along with the progress bar. The Transfer History View will have Job Output that will show the err...
5949529 Aug 2016 @ 03:47 PDTIvyuanToolsReplyMULTILOAD BUFFER ERROR!!! urgentHi, 1. Can you let us know the MultiLoad version and the Teradata Data Connector version? The Data Connector version could be obtained by issuing a ".version;" command using MultiLoad. ...

Pages