#DateForumTypeThreadPost
1520 Apr 2016 @ 07:18 PDTDatabaseReplyImpact CPU on Statistics StatementsIt is not on Teradata 14.10 and higher versions. Thanks for the update.
1419 Apr 2016 @ 07:57 PDTDatabaseTopicImpact CPU on Statistics StatementsWhat are better approaches to reduce Impact CPU (High) on collect stats (full stats) statements ? One of the options is to convert full stats to sampled stats provided that sampled stats are not im...
1323 Feb 2015 @ 11:55 PSTToolsReplyTPT Operator Template error "Output Schema does not match data from SELECT statement"Thanks for the update.  --Sudhir
1218 Feb 2015 @ 01:12 PSTToolsReplyTPT Operator Template error "Output Schema does not match data from SELECT statement"Thanks for the response. I forwarded you the log by enabling trace. 
1117 Feb 2015 @ 10:27 PSTToolsTopicTPT Operator Template error "Output Schema does not match data from SELECT statement"Hello !! I am getting "TPT12108: Output Schema does not match data from SELECT statement" error when I am using a TPT script (operator templates) to copy a Table from TDSERVER-A to TDSER...
1018 Jan 2014 @ 04:54 PSTToolsReplyTPT Template operators with LDAP authenticationAny info on which upcoming release this feature would be available ? 
909 Jan 2014 @ 07:45 PSTToolsReplyTPT Template operators with LDAP authenticationThanks for the update
808 Jan 2014 @ 01:59 PSTToolsReplyTPT Template operators with LDAP authenticationNo, password did not have special characters.
706 Jan 2014 @ 03:25 PSTToolsReplyTPT Template operators with LDAP authenticationI appreciate your time for looking at this issue. I have run tests and actually still notice same error. (I have run tests with and without using SourceLogonMechData and TargetLogonM...
627 Dec 2013 @ 10:03 PSTToolsReplyTPT Template operators with LDAP authenticationThanks for the response. I think I noticed following error when when I tried running script by specifying Source/Target TdpId, Username, Password,LogonMech as shown in below script.&...
527 Dec 2013 @ 09:06 PSTToolsReplyTPT Template operators with LDAP authenticationPlease see TPT script showing one of the options I mentioned in my earlier message i.e by overiding User, Password, TDPID, LogonMech variables using ATTR option in APPLY statement. **********...
427 Dec 2013 @ 07:52 PSTToolsReplyTPT Template operators with LDAP authenticationAs mentioned, I did modify the script by specifying LogonMech variable in two ways (1. Thru Job Vars file, 2. Overriding the variable in ATTR section of each operator code block). Again, ...
326 Dec 2013 @ 09:40 PSTToolsTopicTPT Template operators with LDAP authenticationI have coded a simple TPT script using operator templates ($EXPORT, $INSERT and $LOAD) to copy data of Table A from TDSERVER-A to TDSERVER-B. TDSERVER-A and TDSERVER-B use LDAP based authentic...
225 Jul 2013 @ 03:08 PDTToolsTopicwhen replacing view with comments from SQL assistant, comments get truncated on databaseHi ! In some cases,  I am not noticing comments in the view definition stored in data dictionary (DBC.TABLES.REQUESTTEXT column) or thru SHOW VIEW command after I ...
117 May 2011 @ 12:31 PDTDatabaseTopicPrimary Index on VARCHAR columnIs it a good practice to define a Primary Index on VARCHAR column ? Although I dont see any strange (data type conversions) in explain plans between Join operations on VARCHAR (Primary Index) to CH...