#DateForumTypeThreadPost
6222 Sep 2012 @ 11:57 PDTDatabaseReplyTable Growth using dictionary tablesIf I remember correctly, PDCR is called Performance Data Collection & Reporting services database, which complements the inforamtion captured in ResUsage tables or DBQL to give a more advance r...
6114 Sep 2012 @ 02:29 PDTDatabaseReplyTeradata query doubt importantThis manual should help you to get started... www.teradataforum.com/teradata_pdf/b035-1148-115a.pdf
6014 Sep 2012 @ 02:25 PDTDatabaseReplyTeradata query doubt importantThis seems to be like MYSQL Stored Procedure. Why don't you try Teradata stored procedures!
5914 Sep 2012 @ 02:22 PDTGeneralReplyForum email notifications temporarily disabledYes you should! I used to have similar issue, but since last week when the email notifications were activated, I am now receiving proper email notifications. If you are having problem, then send ...
5814 Sep 2012 @ 04:14 PDTGeneralReplyForum email notifications temporarily disabledYou will receive the forum emails if you have subscribed to that forum. For the posts reply/comments, this is in your accont settings...
5714 Sep 2012 @ 02:47 PDTGeneralReplyTeradata Procedure DoubtIn the stored procedure cast the input parameters as Date e.g. CAST(in_Period_Start as DATE format 'MMMYYYY') This will convert Jan2012 into date format 1/1/2012
5613 Sep 2012 @ 02:21 PDTDatabaseReplyGet the next partition I think you can further simplify the solution suggested by ulrich to get the required results... select * from vt_tst where col2/100 = ( select min(col2) / 100 from vt_tst where co...
5513 Sep 2012 @ 10:39 PDTDatabaseReplyDBQL SQLTextInfo 3577: row size or sort key size overflow Which version of Teradata are you on? I faced a smiliar kind of issue some time ago on I guess V2R6, as the size of column definition that was selected was expected to grow beyond 65K row li...
5413 Sep 2012 @ 10:30 PDTGeneralReplyTeradata Procedure Doubt Pass start and end date in the stored procedure parameters and you can construct the date from the integer values in your table. When both the parameters are in same format then the comparison i...
5313 Sep 2012 @ 10:00 PDTDatabaseReplyAvoid results of subquery as sum of items One possible reason for not getting the results could be that the sales transactions in SALES_TRANS_ITEM_DLY, but their ITEM_ID doesn't exist in ITEM_DIM. Your SQL query looks fine, the ...
5213 Sep 2012 @ 09:52 PDTDatabaseReplyCase When Statement in Teradata Select the column on which the case statement is checked alongwith the other column to see which of the case statement executed and verify the output.
5113 Sep 2012 @ 04:08 PDTDatabaseReplyGet the next partition Sounds easy and simple as the data is parititioned on monthly basis, so the next available months data is the one which needs to be looked for! Why didn't I think like this :)
5013 Sep 2012 @ 03:23 PDTDatabaseReplyFastload File read: 35, Text: EOF encountered before end of record What is the record type you are using? I think you should use SET RECORD VARTEXT Is there any line break after your last record?
4913 Sep 2012 @ 03:11 PDTToolsReplySpecial Characters in Columnnames in FastExport I tried by creating a table with columnname '$_id', and inserted couple of rows in the table. The fastexport script to export the content of the table was executed succesfully withou...
4813 Sep 2012 @ 01:51 PDTGeneralReplyPI Hash Value Generation for Same Value and Different Data Type thats right, but the correct function to find the hash value is HASHROW() :)
4712 Sep 2012 @ 06:08 PDTDatabaseReplyGet the next partition I don't think you can do it in simple SQL because partitioning the data and assigning the partition numbers to the partitioed items is internal to Teradata. However, I would be intereste...
4612 Sep 2012 @ 03:38 PDTToolsReplyBTEQ - Cannot write hexa character in output file Try 0D0A instead of 0D. If I can recall correctly then I think '0D0A'xc is equivalent to '\r\n', and '0D'xc is similar to '\n'. Cheers!
4512 Sep 2012 @ 12:52 PDTDatabaseReplyQuestion about using stored procedures to do inserts and updates You can refer to the Stored procedure documentaion for detail reference. Here is the link www.info.teradata.com/edownload.cfm?itemid=113480020 The stored procedure support both the INSER...
4412 Sep 2012 @ 12:45 PDTDatabaseReplyCreate a table with a date column that has a default I hope this helps... CREATE SET TABLE T1 ( COL1 INTEGER NOT NULL DEFAULT 0, COL2 DATE NOT NULL FORMAT 'YYYY-MM-DD' DEFAULT DATE '2000-01-01') ) UNIQUE P...
4311 Sep 2012 @ 12:57 PDTConnectivityReplyForce user to change password at first logon This should help you! http://forums.teradata.com/forum/database/how-to-force-a-teradata-user-to-modify-hisher-password-on-next-login
4211 Sep 2012 @ 12:51 PDTGeneralReplyConverting Delete qry Not sure why would you get the count mismatch. The joining conditions for the two tables are same and EXISTS kind of serve as the inner join so its not making sense to have count mismatch. D...
4110 Sep 2012 @ 02:09 PDTToolsReplyBTEQ REPORT SELECT 'SELECT COLUMN1,COLUMN2,COUNT(*) FROM MY_TABLE;' (TITLE ''); SELECT COLUMN1 (TITLE '') , COLUMN2 (TITLE '') , COLUMN3 (TITLE '') FR...
4010 Sep 2012 @ 02:02 PDTToolsReplyFast Export 2GB file Limit Yes its right that some servers have file size limits. If you are working on a generic script template then I guess the best solution will be to produce a limited size file with a certain number...
3910 Sep 2012 @ 12:50 PDTDatabaseReplyReplace Function If you dont have the UDFs installed then try the recursive SQL. It should solve your problem.
3824 Aug 2012 @ 01:49 PDTDatabaseReplyLock row for access : In insert-Select LOCKING ROW FOR ACCESS is only valid for SELECT statements, as it allows the dirty reads from the table and allows INSERT/UPDATE/DELETE operations on the table... INSERT statements put the W...

Pages