#DateForumTypeThreadPost
41623 Jul 2012 @ 03:18 PDTDatabaseReplySpool space I am not sure that I understand your issue. Yes, if you have 5TB asssigned to your user and you have 576 VPROCs then you have 3.4G per VPROC for spoolspace. So skew can be limiting your spoo...
41521 Jul 2012 @ 01:03 PDTExtensibilityReplyBLC Utility Check http://forums.teradata.com/forum/database/listing-block-level-compressed-tables
41421 Jul 2012 @ 12:29 PDTDatabaseReplySpool space Any free cyclinder can be used as Spool space. It is not limited to the databases specified in the SQL.
41321 Jul 2012 @ 12:28 PDTToolsReplyCan we use where clause in TPT Export selector Yes, but why didn't you just try? but also check the manuals http://developer.teradata.com/tools/reference/tpt-user-guide/13-10 http://developer.teradata.com/tools/reference/tera...
41218 Jul 2012 @ 10:18 PDTAnalyticsReplyMultiple Rows Into 1 Question select a.postdate, a.trans_type, a.billing_crcy_cde, a.cc_typ_cde, a.tkt_num, max((case when c.dr_gl_acct_num = '123401' then c.gl_amt else null end)) as CC_WIP, max( (case when c.cr_g...
41118 Jul 2012 @ 10:13 PDTToolsReplyCan we use SELECT in MLOAD. First question is unclear to me. MLOAD is a load utility, so what do you want to achive? Second question, question back: what is the exit code you get when MLOAD finished with rows in the er...
41018 Jul 2012 @ 10:07 PDTDatabaseReplyStats on partition on a no partitioned table I guess it is worth to read http://developer.teradata.com/blog/carrie/2012/02/why-collect-partition-statistics-on-non-partitioned-tables  
40913 Jul 2012 @ 05:38 PDTDatabaseReplyIF condition in bteq To unclear question! In BTEQ it is  IF THEN  but only very view condtions are allowed.  
40811 Jul 2012 @ 10:30 PDTGeneralReplyCast in teradata userdefined function Still not too clear. I guess you need to spend some time on the UDF manualls. and maybe http://developer.teradata.com/extensibility/articles/developing-database-extensions-udfs-etc ...
40711 Jul 2012 @ 01:33 PDTAnalyticsReplyMerging Multiple Rows check recursive queries - there are plenty of examples in this forum
40611 Jul 2012 @ 01:30 PDTDatabaseReplyCreate View that includes a Volatile Table REPLACE VIEW m308332.CostWithChildren AS LOCKING ROW FOR ACCESS is missing...
40511 Jul 2012 @ 01:29 PDTDatabaseReplyCreate View that includes a Volatile Table A view is a view and can not create volatile tables. But why don't you use a derived table?   SELECT p.LineID, p.InvNo, p.EAPO, p.ChildInv, p.CostType, p.Modul...
40410 Jul 2012 @ 10:08 PDTGeneralReplyCast in teradata userdefined function Too unspecific question. SQL UDF? Java or C? What should the fucntion do and why do you want to cast?
40310 Jul 2012 @ 04:28 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clause From the manual - 13.10 SQL Data Manipulation Language     WITH [RECURSIVE] Request Modifier Purpose Enables searching a table using iterative self-join and set ope...
40210 Jul 2012 @ 12:58 PDTDatabaseReplyCummulative Counting records with a condition   In this case you need to modify Dieters SQL a bit to dedup the closed dates. create table sunny_test (id integer, code varchar(10), create_dt date, closed_dt date) primary index...
40109 Jul 2012 @ 11:05 PDTDatabaseReplyCummulative Counting records with a condition Hi sunny, my question was related to the input table. The output result is clear. Its related to dieters remark. In case of unique last_closed_date OLAP functions might be an option. Otherwi...
40009 Jul 2012 @ 08:07 PDTDatabaseReplyCummulative Counting records with a condition Can you have multiple rows per key with the same last_closed_date? Someting like    100              &...
39909 Jul 2012 @ 06:52 PDTDatabaseReplyError Code 6706: The string contains an untranslatable character. There is some inplicit character conversion ongoing. Most likely the character set of your source table differ from your target table. If your source table contains unicode character fie...
39809 Jul 2012 @ 04:00 PDTJobsReplyHow to create a .bat file for a BTEQ query Open an editor   paste  bteq < myfilename.txt > myfilename.log 2>&1 into it  and save it as  batchsql.bat  you can call thi...
39709 Jul 2012 @ 02:45 PDTJobsReplyHow to create a .bat file for a BTEQ query You seem to manage to post to the forum. So what is your question here?   bat file   call the scripts in the bat file like bteq < yoursql.txt > yoursql.log 2&...
39606 Jul 2012 @ 02:40 PDTDatabaseReplyHow to run queries dynamically in the procedure wchic are stored in table. You can build a stored procedure to do that. Within the SP you would need to define a cursor to read the SQL and use DBC.SYSEXECSQL to execute the SQL. You would also need to take care of except...
39505 Jul 2012 @ 08:34 PDTDatabaseReplycalculate the size of a table in teradata select databasename, tablename, sum (currentperm)/1024**3 as current_GB from dbc.allspace where tablename <> 'All' and databasename = 'yourDB' group by 1,2 order ...
39405 Jul 2012 @ 06:40 PDTDatabaseReplyTable Load Timestamp As stated before you should ask IT that they maintain a log table wich contains information when this table was last time refreshed. In this szenario you would query your log table to check ...
39305 Jul 2012 @ 05:39 PDTDatabaseReplyHow to Update a table from output of stored procedure Its not going to work. In your example it would not be needed as you could also UPDATE a   FROM TABLEA a,              tbl...
39205 Jul 2012 @ 05:04 PDTDatabaseReplyConcatanation of the rows from one columns ask your it people or colleagues.

Pages