#DateForumTypeThreadPost
34813 Oct 2011 @ 01:31 PDTUDAReplyStored Procedure Issue Hi,   Can you try re-structuring it to following format:     FOR CurrentRow AS SourceCursor CURSOR FOR       SELECT COL1,COL2 FR...
34713 Oct 2011 @ 01:25 PDTGeneralReplyORACLE TO TERADATA MIGRATION Hi,   For new question please use new thread!   You can simply use following to do that:     CREATE PROCEDURE TotalCount() BEGIN   ...
34613 Oct 2011 @ 01:20 PDTDatabaseReplyhow to make Compression Equal?! I do agree with Jim's statement, can you please confirm it will serve your purpose?   Regards, MAC
34513 Oct 2011 @ 01:18 PDTDatabaseReplyteradata procedure Hi,   Do you have any specific question or you plan to learn them from start?   Regards, Adeel
34413 Oct 2011 @ 01:17 PDTGeneralReplyProblem with Timestamp in SQL assistant Have you tried .NET connection?   And can you provide example including DDL, sample data and SELECT statement you are using?   Regards, Adeel
34312 Oct 2011 @ 04:27 PDTDatabaseReplyRandom record selection in the subquery   Hi,   You can have one SELECT as below:   SELECT 1,  A.Cust_type_CD, B.Cust_Location FROM TableX A JOIN TableY B ON RAND...
34212 Oct 2011 @ 04:13 PDTDatabaseReplyMerge Vs Delete/Insert Do share results of your benchmarking for our learning.   Regards, MAC
34111 Oct 2011 @ 11:08 PDTAnalyticsReplyString Search and Replace. And we are for sure working on improving the function set!
34011 Oct 2011 @ 11:05 PDTDatabaseReplyWhat is Spool Space? Why do you get spool space errors? How do trouble-shoot them? Hi,   Spool space is an intermediate dataset storage space. Usually spool space errors occur due to stale stats resulting in product joins. To troubleshoot them, fix the query which...
33911 Oct 2011 @ 11:02 PDTDatabaseReplyUser Defined Function/Procedure Hi,   Seems fine, can you share the code files which may have any issue?   Regards, MAC
33811 Oct 2011 @ 10:57 PDTDatabaseReplyQuery to Delete all the records in a table in Teradata Hi,   In case the table is huge, you can also use DROP TABLE and CREATE TABLE commands.   HTH!   Regards, MAC
33711 Oct 2011 @ 10:55 PDTDatabaseReplyExecute Multiple Drop Table Statements in single Procedure Hi,   You can issue multiple DROP TABLE commands in a stored-procedure using dynamic SQL as below:   CALL DBC.SysExecSQL ('DROP TABLE TABLE1;'); CALL DBC.Sy...
33611 Oct 2011 @ 10:53 PDTDatabaseReplyhow to make Compression Equal?! Hi,   The CPU consumption can surely be due to uncompressing and recompressing the values.   Regarding moving data from one database to another .... if the only concern...
33511 Oct 2011 @ 10:45 PDTUDAReplyCompiling Stored Proc - VC++ not installed error Hi,   Thanks for sharing the piece of information .... from TD version 12 and above .... simple installation (no renaming or changing of registry manually) of VC++ 2005 Express edit...
33411 Oct 2011 @ 10:42 PDTDatabaseReplyRandom record selection in the subquery Hi,   You obviously need to change your approach of writting INSERT/SELECT query. Easier approach should be to write one SELECT statement first, before generating it in SP dynamical...
33311 Oct 2011 @ 10:38 PDTDatabaseReplyMerge Vs Delete/Insert Hi,   It can vary from case to case depending on index selection and stats on the table .... have you benchmarked MERGE and DELETE/INSERT approaches?   Generally MERGE ...
33211 Oct 2011 @ 10:34 PDTGeneralReplyTeradata database software and its availability. Hi,   You can download a fully working demo from following link:   http://downloads.teradata.com/download/database   It does include all the tools and util...
33103 Aug 2011 @ 01:41 PDTDatabaseReplyData Cleansing using SQLAre the values of Col1 in sequence .... as in .... in order .... 1,2,3,4.... ?
33003 Aug 2011 @ 01:09 PDTDatabaseReplyStored Procedures - Use dynamic cursor for any tableHi, From what I have understood .... you can use Volatile-table .... insert in this table the list of columns of the P_TABLE_NAME from DBC.COLUMNS .... and iterate through the volatile-table to ...
32903 Aug 2011 @ 01:04 PDTDatabaseReplyError when calling an UDFHi, Firstly, what exact format are you returning the output in? Secondly, do you really require a UDF for finding 1st day of a month? Regards, MAC
32803 Aug 2011 @ 01:00 PDTDatabaseReplyhow to store the very big integer in TeradataHi, For storing such a value, consider thinking if you really need it as numeric value .... meaning if you are going to use it in some calculations or not. In case you are not going to use it in...
32703 Aug 2011 @ 12:52 PDTDatabaseReplyInner Join using SubQuery bring me the table nameCan you please be more descriptive?
32603 Aug 2011 @ 12:48 PDTDatabaseTopicDifference of rows in SELECT COUNT(*) and SELECT *Hi, I am facing a weird problem of which can not really figure out what could be the reason of that. Consider following SELECT statement: SELECT Col1, Col2, Col3 FROM View1 QUALIFY ROW_NU...
32513 Jun 2011 @ 05:33 PDTDatabaseReplyhow to move UDFs from one teradata DB to another?Hi, You need to get the code .... which if you dont have .... can get using: SHOW FUNCTION . As an output you will get 2 files .... one a C code and two the command to compile it which can...
32413 Jun 2011 @ 02:52 PDTDatabaseReplyCoverting INTEGER value to Date format @CarlosAL .... indeed a cool solution!! :)

Pages