#DateForumTypeThreadPost
3429 Jun 2010 @ 08:12 PDTMarketing & CRMReplyI need a MACRO that will allow the User to define the tableOff the cuff, I would suggest looking at the Elastic Marts Builder plug-in for Viewpoint. However, as Adeel mentioned if you provide some more details we can better help you.
3329 Jun 2010 @ 07:56 PDTDatabaseReplyShow tableIn DBC.Tables look for RequestText and RequestTextOverflow. Trouble with the RequestText field is that it contains the last DDL statement that affected the table. So if you use ALTER TABLE to add a...
3229 Jun 2010 @ 07:46 PDTGeneralReplyBTEQBTEQ does not support variable assignment like you would find in Oracle PL/SQL scripts. - You can do pre-processing of your BTEQ Script and replace tokens in your SQL. - You can use an volatil...
3129 Jun 2010 @ 07:43 PDTGeneralReplyPrimary Index Reducing SpaceThe 685GB of space in the database is divided evenly among the number of AMPS on your system. As soon as a single AMP on the system reaches its limit the database is considered full. As Dieter ment...
3029 Jun 2010 @ 07:29 PDTGeneralReplyT@YS new design?I agree with the observations made here. The new site design is better but could be much better.
2907 Apr 2010 @ 06:07 PDTDatabaseReplyIs there any automated tool to compress the data in Teradata..There is some code floating around on the internet that provides a foundation from which you can develop an automated maintenance routine for multi-value compression. As Random_Thought has indicate...
2824 Mar 2010 @ 09:51 PDTToolsTopicSUN Solaris SPARC & Teradata 12 UtilitiesI have been asked by the server admins to provide a space requirement to install the following Teradata 12 utilities on a SUN Solaris SPARC server: (1) CLI and related security libraries (2) BT...
2710 Jul 2009 @ 10:47 PDTDatabaseReplyVolatile Tables And StatisticsYou can collect stats on global temporary tables. If your SQL and volatile table usage would benefit from statistics being present, you may want to consider switching to global temporary tables ins...
2610 Jul 2009 @ 10:38 PDTDatabaseReplyInsufficient memory to parse this request,during optimizer phase....You may be able to evaluate the MaxParseTreeSegs setting in the DBSControls, but I would consider reducing the number of items in your IN list or placing them into a table (permanent, global temp, ...
2510 Jul 2009 @ 10:35 PDTDatabaseReplyIN Clause limit in Teradata 12 (V2R12)...While there may not be a theoretical limit to the number of items contained within an IN clause you may see performance degradations if the list starts to exceed a few hundred items. There has been...
2410 Jul 2009 @ 10:32 PDTDatabaseReplyTERADATA TO INFORMIXYou could either FastExport the data to a flat file and load it to Informix or investigate one of the countless ETL / data integration tools on the market to move the data between the two systems.
2304 Jul 2009 @ 08:33 PDTUDAReplySQL Assistant to connect to DB2You will need to obtain the DB2 client that provides an ODBC driver for the version of DB2 to which you are trying connect. SQL Assistant should connect to any ODBC compliant database. While certai...
2204 Jul 2009 @ 08:21 PDTDatabaseReplySelect clause inside fields listI don't believe until TD13 can you embed a SELECT statement within a column, which is similar to what Oracle permits currently. Try a CROSS JOIN instead. Since it will only return a single row the ...
2130 Jun 2009 @ 10:10 PDTUDAReplymanaging deleted rows with viewsA FTS may be unavoidable given the cardinality of the index values. An index value with a high cardinality may be more efficient to resolve via a FTS instead of traversing the index. Regardless, ma...
2030 Jun 2009 @ 09:53 PDTDatabaseReplyMeasuring Query reponse time.Dieter is spot on. If your focus is elapsed time, DBQL is not the place to find or calculate that metric. SAS, Cognos, Business Objects, etc. should provide you with log tables that detail the time...
1929 Jun 2009 @ 01:00 PDTUDAReplyFast export in unixThat is the result of the variable length offset's being placed there by FastLoad. You can strip them out as a post process or concatenate the fields and delimiter together and cast it to a fixed l...
1829 Jun 2009 @ 12:41 PDTDatabaseReplyHow to speed up inserting data into volatile table ?I'm going to side with jimm on this and suggest your lack of a primary index in your table definition combined with the values in the first column of the table distributing poorly is the culprit. T...
1729 Jun 2009 @ 12:35 PDTDatabaseReply3939 errorAre you defining and setting :VAR1 inside of the macro or stored procedure containing this SQL statement?
1629 Jun 2009 @ 12:33 PDTDatabaseReplyvarchar length performance implicationsIf the field 'srch_hotel_text' in TableB contains expanded values (lengths exceeding 200 characters) from TableA the fact that it is included in the Partition By of the RANK() function is the likel...
1529 Jun 2009 @ 12:17 PDTDatabaseReplyMeasuring Query reponse time.In my experience, the duration between StartTime and FirstRespTime (aka ElapsedTime) is more valuable in terms of the actual query performance than the last response time. The ElapsedTime is the ti...
1411 Jun 2009 @ 04:21 PDTDatabaseReplyjoining to different databses into teradataThere is an Oracle product called Oracle Transparent Gateway for Teradata that allows you to access Teradata through Oracle. The gateway is a single direction only and the query originates from Ora...
1311 Jun 2009 @ 12:09 PDTDatabaseReplyQuery about BackupIf you add the NONEMPTY DATABASE option to your archive in conjunction with the ALL option it should exclude your spool reserve database. See the Archive/Recovery Utility manual for more details.
1211 Jun 2009 @ 12:06 PDTDatabaseReplyHow to revoke logon from all but a userYou should be able to script something using the DBC.Users view to build the REVOKE LOGON FROM /ALL;It should be noted that you may increase the size of your DBC.LogOnRules.
1111 Jun 2009 @ 11:55 PDTDatabaseReplyRounding down 2.50 to 2Check the SQL Reference manual in the Teradata Manuals. Chapter 3 explains Rounding and the impact of the RoundHafwayMagUp DBSControl parameter. This may be impacting the behavior you are seeing.Yo...
1011 Jun 2009 @ 11:42 PDTDatabaseReplyAdd days to a date column12/31/9999 is the upper limit of the DATE domain on Teradata. You can not add any days to it. This is why your query is failing.

Pages