All forum activity

#DateUserForumTypeThreadPost
5824206 Jul 2016 @ 11:17 PDTStevenSchmidDatabaseTopicCan't free up small amounts of spaceHi I'm trying to free up space in some parent databases that have no objects.  In some cases, a small amount of space is left behind (e.g. 136 bytes, other DBs leave behind less than...
5824106 Jul 2016 @ 10:53 PDTdhiraj_dt121ToolsTopicteradata TPT , all rows in error tableHi Folks, I have created TPT script, however when I run it all the rows are errored out. Below is my code and the table structure. DEFINE JOB MOVE_DATA_WITHOUT_LANDING_TO_DISK ...
5824006 Jul 2016 @ 09:00 PDTdhiraj_dt121ToolsReplyTPT export to delimited files ErrorThanks this works. Now i am faced with another issue when using the unicode character sets for some Columns. All the records are in error tables. EXPORT_OPERATOR: entering End Export Phase ...
5823906 Jul 2016 @ 07:41 PDTbhanusri83TrainingReplyTeradata 14 basics certification informationAll, I am planning to take Terdata basic ceritification in a couple of weeks from now and am in need of the below information. 1. When trying to schedule my exam in Prometric site, it's askin...
5823806 Jul 2016 @ 03:59 PDTFredDatabaseReplyHashing AlgorithmCould be either AMP or PE. In particular, FastLoad sends data blocks to AMPs round-robin and the AMPs hash the rows and send to the correct target AMP. But for a single-row fetch or insert, the PE ...
5823706 Jul 2016 @ 03:30 PDTNikhil_TeradataDatabaseReplyDefined type name errorI think I got the error resolved. It went away after I restarted the TD SQLA. I still don't know why it happened though.  
5823606 Jul 2016 @ 03:25 PDTtimlisa20ConnectivityReplyODBC error (64bit)Thanks Fred for the recommendation. I ran the uninstall script...rebooted....intalled in the correct order. Now when I look in the "ODBC Data Source Administrator" for "Teradata"...
5823506 Jul 2016 @ 02:29 PDTnealvennaDatabaseReplyregexp_similar '^.$' issuesJust one more update. We have TD14 and TD 15 on different servers and I did following query select case when regexp_similar('¥','^.$', 'i')=1     &...
5823406 Jul 2016 @ 02:27 PDTVinay151DatabaseReplyDecimal ValueThanks Carlos.... Also, is this the default format of Decimal data type to store the value Thanks, Vinay
5823306 Jul 2016 @ 02:01 PDTssinhaAnalyticsTopicReplacing missing value with next vaulesI have a data like Attmpt_dt 1/1/2016 ? ? ? ? 1/10/2016 ? ? ? 1/31/2016     I want it to covert      Attmpt_dt 1/1/2016 1/10/2016 1/10/2016 1/10/2016 ...
5823206 Jul 2016 @ 12:53 PDTfeinholzToolsReplyTPT output from ODBC includes Indicator Bytes?If you are reading data from Oracle with the ODBC operator, there are no indicator bytes coming from Oracle. They are added to the data when the rows are moved from the ODBC operator to the loadin...
5823106 Jul 2016 @ 12:48 PDTfeinholzToolsReplyTPT export to delimited files ErrorBy default, TPT is supporting a DECIMAL precision of 18 (8 bytes). Since your source column is defined as DECIMAL with a precision of 22 (needing 16 bytes), you need to add the MaxDecimalDigits=31...
5823006 Jul 2016 @ 12:45 PDTfeinholzToolsReplyTPT EXPORT OPERATOR job structureOur documentation describes the Export operator, the mandatory attributes and the optional ones. Our User Guide has examples of Export operator job scripts as well. We also ship sample scripts wi...
5822906 Jul 2016 @ 12:13 PDTericmDatabaseReplyRestoring a TableI figured it out.  Simple syntax error.  I was missing a ; at the end of the line.
5822806 Jul 2016 @ 11:52 PDTNikhil_TeradataDatabaseTopicDefined type name errorHi,   I get this type of error for below statement: SELECT COUNT (DISTINCT Userid) FROM PDB.View WHERE src_id IN (123) AND Src_Cd = 'AB' AND PGM = 'LN'; ...
5822706 Jul 2016 @ 11:11 PDTericmDatabaseTopicRestoring a TableI am attempting to restore a single table to our server.  The table already exists, but I have truncated the data in the table. First I start ARCMAIN: arcmain FILEDEF=(ARCHIVE, tdbackup) ...
5822606 Jul 2016 @ 10:04 PDTSNguyenWFTeradata StudioReplyStudio Express severe keyboard lagI was looking in the teradata.log file found in the workspace directory.  An entry I'm curious about and which happens frequently is: "2016-06-28 10:51:54,089 Teradata Datatools [mai...
5822506 Jul 2016 @ 09:30 PDTabhishank18DatabaseTopicHashing AlgorithmI am just wandering, in which part of logical architecture of teradata does hashing happens. I read somewhere when data loading happens first data is transferred in AMPs and then hashing happens an...
5822406 Jul 2016 @ 09:27 PDTsharonnConnectivityTopicPing Failed - can not connect to Teradata on Linux - awsHi, I’m using Teradata Express on linux machine - aws. When starting the machine, Teradata is not starting properly. I have to stop it and start it several times until Teradata works fine....
5822306 Jul 2016 @ 09:14 PDTKG1116DatabaseTopicStored procedureHello, I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here? here is a small mock up example, however this will be implemented o...
5822206 Jul 2016 @ 09:12 PDTCarlosALDatabaseReplyDecimal ValueHi. The datatype is NOT storing the value as ".00" (numbers are numbers). The FORMAT is what displays the data in one or other way. You can define a FORMAT at column level (when cr...
5822106 Jul 2016 @ 09:08 PDTKG1116DatabaseTopicStored procedureHello,   I have been struggling with this concept and any help would be highly appreciated. Do we need a stored procedure here?   Table 1 ...
5822006 Jul 2016 @ 08:57 PDTryuwaraimasaDatabaseTopicMigration CompatibilityI'm new here so I will keep it short, just a quick question on compatibility. My company currently uses Tibero but we are looking into using a much larger DBMS as our company grows. My question...
5821906 Jul 2016 @ 08:41 PDTdnoethDatabaseReplyA problem with 'where'Well, this is exactly what you wrote: No data from the year 2004 and no data from any august :-) You want either a.num_month<>8 OR a.num_year<>2004 or NOT(a.num_month = 8 AND a.num_yea...
5821806 Jul 2016 @ 08:36 PDTRhino_373DatabaseTopicPossible loop usage in SQL?I have to tables that have two columns. Both have a date and an amount of money. The first table generally has every day of the month. The second table often skips days such as weekends and possibl...

Pages