#DateForumTypeThreadPost
37302 Jul 2012 @ 12:42 PDTGeneralReplyHow to find the parent and child relationship between tables in Terdata by using Dictonary tables? I assume your question relates to referential integrity .... you can use following objects to get desired information:     DBC.All_RI_Children -> defined referential con...
37202 Jul 2012 @ 12:33 PDTGeneralReplyHow to display the last 3 characters of lastname? In case CHARACTERS doesn't work, you can also use CHARACTER_LENGTH function to get the length of character field.   HTH!
37129 Jun 2012 @ 04:10 PDTUDAReplyCompiling Stored Proc - VC++ not installed error Which verison of TD you are using?   Regards, Adeel  
37029 Jun 2012 @ 04:06 PDTUDAReplyTeraData vs Oracle Hi,   I think following link should help you:   http://downloads.teradata.com/download/extensibility/teradata-udfs-for-popular-oracle-functions   Regards, ...
36929 Jun 2012 @ 04:02 PDTGeneralReplyTeradata Functions If you are joining as a fresher, am sure the organization will guide you through it.   Cheers.
36829 Jun 2012 @ 03:57 PDTDatabaseReplyWhat are the General roles & responsibilities of a TERADATA DEVELOPER Hi,   In which context are you asking that? As a future developer, or for certifications?   Regards, Adeel  
36702 Apr 2012 @ 02:52 PDTDatabaseReplyConverting Multiple rows of data into one row... Hi,   You can do it either by using recursive view, or by looping in a procedure.   Regards, Adeel
36602 Apr 2012 @ 02:45 PDTGeneralReplytable does not exist Hi,   In such a case, table is expected to be in a database where it is not. Try by fully qualifying the table name in the procedure.   Regards, Adeel  
36502 Apr 2012 @ 02:44 PDTGeneralReplyInstallation and connection profile Hi,   Using Teradata SQL Assistant .... you can connect using Teradata .Net Connector or ODBC DSN source .... login and password should be dbc.   Regards, Adeel
36402 Apr 2012 @ 02:42 PDTGeneralReplySQl for current period and Previous period Hi,   You can use calenders to get the min and max from within a month.   Regards, Adeel  
36305 Dec 2011 @ 02:13 PSTDatabaseReplyEnd Dating Previous Relations Hi,   All you have to do is to rank them on start_dt and self join with rank - 1 and you will get what you desire.     Regards, Adeel  
36205 Dec 2011 @ 02:09 PSTGeneralReplyStored Procedure Configuration -- RegOpenKeyEx Failed. Hi,   I have Teradata 13 installed with Visual C++ 2008 Express and it works fine, can you try that?   Regards, Adeel
36101 Nov 2011 @ 01:29 PDTDatabaseReplyAlternative to oracle procedure Are you facing any specific problem? or are you just seeking someone to do work on your behalf? :)   Regards, Adeel  
36019 Oct 2011 @ 02:56 PDTUDAReplyMultiple Case Statements Yes, by DDL I meant table definition .... though it is abbreviation of Data Definition Language.
35918 Oct 2011 @ 09:21 PDTDatabaseReplyHow to store and display a german umlaut? Hi,   UNICODE should fix the issue. I am using following and i can see it properly when selecting:     CREATE SET VOLATILE TABLE Table1 ,NO FALLBACK , &nbs...
35818 Oct 2011 @ 09:10 PDTUDAReplyMultiple Case Statements Hi,   Please allow me to say one thing .... if you are not sharing DDLs it makes our life horrible IF we chose to assist in your issues. Reason being .... now i'll have to figur...
35718 Oct 2011 @ 09:04 PDTGeneralReplyNot able to access table after Macro Fails Curious .... what makes you believe blocking session will not show up in PMON?
35617 Oct 2011 @ 09:42 PDTUDAReplyStored Procedure Issue It should work fine, i tired with dummy definition of tables and SP you are calling in a loop.   Can you share DDLs for tables and SPs for further analysis?   Regards, ...
35517 Oct 2011 @ 09:34 PDTUDAReplyMultiple Case Statements As requested earlier, please share DDL, data and SQL you get errors in!   The SQL you wrote above is perfectly fine:   Case  when A.APPL_DOB_CFRM_CN  is ...
35417 Oct 2011 @ 03:10 PDTAnalyticsReplySQL help - Median, 75th percentile price Hi,   There is a very nice article from our most active forum member Dnoeth on this topic. Link is as follows:   http://developer.teradata.com/blog/dnoeth/2011/06/missi...
35317 Oct 2011 @ 03:06 PDTUDAReplyMultiple Case Statements Hi,   You can surely use CASE combinations .... better to use paranthesis for clearer SQL.   Another option is to use a DECODE UDF for Teradata, available at: http...
35217 Oct 2011 @ 02:58 PDTDatabaseReplyincrease size of teraData database For the demo version, limit is still 4 GB .... doesnt really makes sense for a demo version to have more than that.   Regards, Adeel
35117 Oct 2011 @ 02:56 PDTDatabaseReplyHow to compare data from tables in Teradata with tables in Oracle Hi,   Is it possible for you to look into INMOD option? Or can you load the TIMESTAMP such as "12-07-2011:23:58:23" as VARCHAR(19) and then process using SQL?   ...
35017 Oct 2011 @ 02:51 PDTGeneralReplyNot able to access table after Macro Fails Hi,   While executing SELECT/INSERT/DELETE/DROP on the table, can you login PMON and check if your request is blocked by another session?   Regards, Adeel
34913 Oct 2011 @ 01:34 PDTAnalyticsReplyRow counts for every table in a given database satishkumar206 .... please post new questions in new threads!

Pages