2311 May 2013 @ 08:54 PDTDatabaseReplyPPIThanks for your response mandeep, I got it.   Thanks & Regards, mack
2210 May 2013 @ 12:01 PDTDatabaseReplyPPIHi, Pawan Thanks for your response, Actually i defined UNIQUE PRIMARY INDEX (Customer_Number, Order_Date) As per our rule, UPI can't be allow in PPI, Eventhough i defined UPI has Order_Date ...
2109 May 2013 @ 12:26 PDTDatabaseTopicPPI Hello Experts, Please help me   I have problem with UPI, i defined UPI has customer_number,order_date. My questions: 1)Why PPI allows UPI for partition? 2)Here, Why orde...
2017 Apr 2013 @ 07:09 PDTDatabaseTopic Arcmain Hello Experts, Does Arcmain support the stream level backups? Regards, mack
1904 Apr 2013 @ 02:32 PDTDatabaseTopicTable HeaderHi Experts, I have a table with columns (col1,col2,col3,col4......onto col100); Obvoiusly, the table header stores in all amp.   My question, Does this table header store all these columns...
1827 Mar 2013 @ 05:51 PDTDatabaseTopicIncremental BackupHello Experts, Give, A sample Incremental Backup script for permanent Journal. Thanks & Regards, mack
1714 Mar 2013 @ 09:35 PDTAnalyticsReplyPlease give syntax of scalar subquery to join three tablesThank you very much ks42982,   Regards, -mack    
1613 Mar 2013 @ 04:41 PDTAnalyticsTopicPlease give syntax of scalar subquery to join three tablesPlease give syntax of scalar subquery to join three tables regards,-mack
1513 Mar 2013 @ 03:06 PDTDatabaseReplyIs it good to creating SET table with UPI or NUPI and why..?Please give me one example on three tables to join, using Scalar subqueries. Regards, mack
1424 Feb 2013 @ 09:24 PSTViewpointTopicPenalty Box I'm Novice to Viewpoint, When we need Penalty box in work load? Regards,- mahesh
1324 Feb 2013 @ 02:23 PSTDatabaseReply Table VersionThanks Fred. Regards, -mahesh
1223 Feb 2013 @ 11:03 PSTDatabaseTopic Table VersionWhen I'm selecting my database in T-administrator , Display all table. Few of them versions above 1, Few of Tables updated, Even though it shows 1 only.   Regards, mahesh
1103 Nov 2012 @ 11:20 PDTViewpointReplyROLE MAPPING ATTRIBUTESHello Stever, Could you suggest me in which criteria Td viewpoint use  Y(logical) & G(global) deadlocks? mack
1001 Nov 2012 @ 03:49 PDTViewpointReplyROLE MAPPING ATTRIBUTESHi stever, Will you please explain data collection service(DCS)? I have small doubt regarding DCS, does DCS maintain both backup files and manage server files?
931 Oct 2012 @ 06:43 PDTViewpointReplyROLE MAPPING ATTRIBUTESThank you very much steves, In authentication method , How can i identify externally authenticated user (ldap) and internal database user? mack
831 Oct 2012 @ 12:12 PDTViewpointReplyROLE MAPPING ATTRIBUTESHi stever, yes,Example When i'm enter username and password with default domain email, td view server will check that email using Auto-provisioning ,Email was not found in teradata viewpoint. ...
730 Oct 2012 @ 08:18 PDTViewpointTopicROLE MAPPING ATTRIBUTESHello everyone i'm new to viewpoint, Can any one explain mapping attributes abbrivation.  cn, ou ,dc ,dc           mack
623 Oct 2012 @ 07:55 PDTGeneralTopicTERADATA NEW REVERB WEB LINKHi, My well whishers I can find one web portal link ,It will hlepful both Devloper's and DBA's and new to the TERADATA. http://infodev.teradata.com/reverb/index.html  
519 Oct 2012 @ 09:19 PDTDatabaseReplyDate ConversionThank you very much..harpreet singh Bhai........
418 Oct 2012 @ 09:48 PDTDatabaseReplyDate ConversionHi, Harpreet singh I'm new teradata , when i was executing below query i saw date SELECT '12-Aug-12' AS COL1 , CAST(CASE WHEN CHAR_LENGTH(SUBSTRING(COL1 FROM 1 FOR POSITION('-'...
305 Oct 2012 @ 08:28 PDTDatabaseReplySQL to find Row CountHi dieter, could you please explain diff blw                        rowcount|rowc...
227 Sep 2012 @ 11:25 PDTDatabaseReplyStrange(?) error creating FK constraintsThe WITH CHECK OPTION option is used to specify that Referential Integrity (RI) is only checked at the end of a batch. The NO option indicates that RI is not enforced.
127 Sep 2012 @ 10:28 PDTDatabaseReplyStrange(?) error creating FK constraintsHey bro' check with the following query, u may get DBC.All_RI_Parents DBC.All_RI_Children