#DateForumTypeThreadPost
87127 Jan 2016 @ 07:55 PSTDatabaseReplyneed teradata logicINTERVAL YEAR will fail for February 29. Better to use ADD_MONTHS(col1,12) and so forth.
87027 Jan 2016 @ 07:53 PSTDatabaseReplyBTEQ export FastLoad Import issueIs the column defined as CHAR(17), in which case you need to specify that in the DEFINE as well?   FastLoad format starts with a record length and if the field was VARCHAR then there would b...
86925 Jan 2016 @ 12:46 PSTToolsReplyHow to archive in ARCmain.On the command line you can map the "internal" filename to an "external" name:   arcmain SESSIONS=8 OUTLOG=ARCALL.OUT FILEDEF=(ARCHIVE,C:\user\backup)   ARC itself...
86825 Jan 2016 @ 09:51 PSTGeneralReply.COMPILE throws error 7947 in spite of having only one Replace Procedure Statement in BTEQMake sure you have an outer BEGIN / END around the entire SP body, including any declarations, and that there is no semicolon before the first BEGIN.   REPLACE PROCEDURE name (parameters) op...
86725 Jan 2016 @ 09:36 PSTDatabaseReplyLong Parsing IssueChecktable has no effect on skew. Skew in AccessRights is usually addressed by implementing Roles and database-level GRANTs and then revoking redundant user / table level access rights; in par...
86625 Jan 2016 @ 08:57 PSTCloud ComputingReplytest data/tables in Teradata Express 13.0 for VMware (4 GB)??The tables are not in the Samples DB itself, they are in databases below Samples in the hierarchy.   SELECT DatabaseName, TableName FROM DBC.TablesV WHERE DatabaseName in (SELECT Child FROM...
86525 Jan 2016 @ 08:15 PSTToolsReplyTPT_INFRA: TPT02019: Error: opening file '$SCHEMA_GEN_D_TBL001.txt': "No such file or directory" (error code 2).Use the -j option to provide a unique jobname for each job.
86424 Jan 2016 @ 09:49 PSTGeneralReplyPMCPThe name change occurred back in the TD12 timeframe. And starting with TD14.0, the DDL portion is supplied with the database, as a DIP script. The Viewpoint and Excel reporting tools are ...
86323 Jan 2016 @ 10:25 PSTTeradata StudioReplySetup host server for Studio ExpressSo you already had the Teradata Express VM (which includes Teradata Studio Express) and you have now installed Teradata Studio on your system and want to connect it to the VM? Check...
86223 Jan 2016 @ 10:18 PSTDatabaseReply2616: Numeric overflow occurred during computation.RANK, ROW_NUMBER, etc. all return INTEGER. But SUM can handle larger values. Building on dnoeth's blog posts, a BIGINT DENSE_RANK could be computed as:   SELECT part_col, data_col, ...
86122 Jan 2016 @ 03:47 PSTDatabaseReplyLong Parsing IssueLarge CPU Time for parsing versus elongated elapsed Parsing Time (for relatively modest Parsing CPU) are two different things.   When the elapsed time is long relative to the CPU time, ...
86022 Jan 2016 @ 09:05 PSTCloud ComputingReplyTeradata Express VMWare 15.10.0.7 with ViewpointDid you create a viewpoint user and grant access as documented in the Viewpoint Configuration Guide? Use dbc as the TDPID.
85922 Jan 2016 @ 08:23 PSTDatabaseReply2616: Numeric overflow occurred during computation.The internal result data type for DENSE_RANK is INTEGER, so CAST doesn't help here as it would for COUNT.
85821 Jan 2016 @ 12:17 PSTDatabaseReply2616: Numeric overflow occurred during computation.Also COUNT uses a larger field internally but in Teradata mode the result is implicitly CAST to INTEGER. So you may want to explicitly CAST(COUNT(...) AS DECIMAL(18)) or BIGINT when dealing w...
85721 Jan 2016 @ 12:12 PSTGeneralReplyEnter the parameter value for end -- stop popup Is this in SQL Assistant? If so, what version?   Looks like improper parsing of the comment style. Workaround is to remove the ? after "leap year" or switch to /* ... */ comment st...
85621 Jan 2016 @ 12:00 PSTViewpointReplyUnable to connect -- Firefox can't establish a connection to the server at localhost.Since this question is specific to Teradata Express, it probably belongs in the Cloud Computing forum.   In this VM, the portal server is configured to use port 9080. http://localhost:9080
85521 Jan 2016 @ 09:40 PSTToolsReplyTeradata SQL Assistant - Multiple Answer Window Tiles MergeTools > General > Use a separate Answer window for  
85421 Jan 2016 @ 09:22 PSTTrainingReplyTeradata 14 basics certification informationYou are allowed to take either TE0-142 or TE0-143 next after completing TE0-141. But you must complete both to obtain the Teradata 14 Certified Technical Specialist designation before you can conti...
85320 Jan 2016 @ 02:56 PSTDatabaseReplyHow to increase the length of message_text generated from the RESIGNAL/SIGNAL command in the Stored ProceduresYou can't increase the MESSAGE_TEXT length.   Perhaps you could pass back a larger string in a dynamic result set or OUT parameter, or insert it into a log table.
85217 Jan 2016 @ 09:15 PSTDatabaseReplyHow to create a Database on Teradata for the first timeFind Teradata Express for VMWare Player database images and instructions on Developer Exchange (developer.teradata.com): http://downloads.teradata.com/download/database/
85117 Jan 2016 @ 09:05 PSTTeradata ApplicationsReplyVarchar expanding to its maximum length in fexp - ALSO USING THIS FIELD IN ORDER BYThanks for the correction! I should have remembered that SUBSTRING / SUBSTR result has the same size as the original field. You are correct, of course. CAST is required and you can't...
85015 Jan 2016 @ 01:31 PSTTeradata ApplicationsReplyVarchar expanding to its maximum length in fexp - ALSO USING THIS FIELD IN ORDER BYYou could do this: select cast(description as varchar(1000)) from ( select trim(trailing from substring(description from 1 for (select max(character_length(description)) from Table_A))) ...
84915 Jan 2016 @ 01:14 PSTGeneralReplyRemoving decimals from datetime in TeradataFORMAT is applied only when you convert to/from [VAR]CHAR: SELECT CAST(CAST(prod_tm AS FORMAT 'mm/dd/yyyyBhh:mi:ss') AS CHAR(19)) AS Col1
84814 Jan 2016 @ 02:25 PSTPrivate Forum
84714 Jan 2016 @ 12:31 PSTTeradata ApplicationsReplyVarchar expanding to its maximum length in fexp - ALSO USING THIS FIELD IN ORDER BYIt's the ORDER BY that causes an expansion to the max length in spool. Yes, if you know the actual max length you can CAST the field shorter within the derived table so the ORDER BY&...

Pages