#DateForumTypeThreadPost
401 Sep 2016 @ 11:22 PDTDatabaseReplyHow to identify tables that have been Block-level compressed using SQLIn TD15.10, below SQL will reveal if there is BLC on the table. show stats values on <databasename.tablename>;   BLCPctCompressed > 0 in the answerset will indicate BLC is on.
307 Apr 2016 @ 08:13 PDTConnectivityReplyLDAP authentication - lockout and expiry LDAP logon failues are recorded only in /var/log/messages of the node which handled the logon request. They are not logged in DBC.LogOnOff. We have a pending enhancement request for this feature...
216 Mar 2016 @ 10:16 PDTGeneralReplySCHEDULING Teradata SQL QUERIESYou could try using the Windows Task Scheduler. You will need to build BTEQ scripts and create ".bat" file to schedule  the script. Recomend using Teradata Wallet to store passwords ...
116 Jul 2012 @ 07:25 PDTDatabaseReplyCreating a Timestamp(6) with Timezone column with Default value Thankyou Jimm! your post helped me. I was trying to define default date for a coulumn without letting the dbc know the character constant was a date :).