#DateForumTypeThreadPost
2620 Nov 2015 @ 03:00 PSTDatabaseReplyPartitions on Character fields in 14.10Hi, I tried with the below CT with CASE_N with LIKE condition in the partition. Im not sure about the performance. I tested inserting few rows, it was success. Not sure about larger data sets. &nb...
2520 Nov 2015 @ 01:42 PSTToolsReplyConvert date format m/d/yyyy to mm/dd/yyyy in TPTHi, This might work.   Select '1/2/2014' as date1, TO_CHAR(TO_DATE ( case        when strtok(date1, '/', 2) between 1 and 9 then strtok(da...
2420 Nov 2015 @ 01:39 PSTUDAReplyFORMAT m/d/yy column as DD/MM/YYYYHi ,   This should work.   Select '1/2/14' as date1, TO_CHAR(TO_DATE ( case        when strtok(date1, '/', 2) between 1 and 9 then ...
2320 Nov 2015 @ 01:34 PSTDatabaseReplyConversion from mm/dd/yyyy to yyyy-mm-ddHi, This should work.   Select '1/2/1900' as date1, TO_CHAR(TO_DATE ( case        when strtok(date1, '/', 2) between 1 and 9 ...
2208 Nov 2015 @ 07:20 PSTDatabaseReplyTeradata SQL Assistant ImportHi, Below link would help you. https://forums.teradata.com/forum/database/teradata-sql-assistant-import   Thanks, Dinesh
2108 Nov 2015 @ 07:03 PSTDatabaseTopicAll row scan count of queriesHi All,   Is there any way to count queries which do all row scan of tables? I tried to get the same through dbc.DBQLExplainTbl but it didnt help. Any help would be appreciated. ...
2020 Oct 2015 @ 11:44 PDTDatabaseReplyMonitoring Intelligent MemoryHi, Resusage tables have most of the resource usage details of the system. For eg: ResUsageSpdsk has ReadCount, WriteCount, ReadResponse, WriteResponse, MigrateReadIO, MigrateWriteIO and more colu...
1920 Oct 2015 @ 10:16 PDTDatabaseReplyComparing Two EnvironmentHi, There is a column named TableKind in dbc.tables which tells you what kind of object(eg: Table, View, Procedure, Macro, etc). You can use this column to compare the all kind of objects in the d...
1825 Jun 2015 @ 08:37 PDTDatabaseReplyScheduing a stored procedureAkhil,   You can put the stored procedure in a BTEQ script and schedule the BTEQ script to run through CRONTAB/Windows Scheduled Task.   Thanks, Dinesh
1718 Jun 2015 @ 02:21 PDTDatabaseReplyLooping in Stored ProcedureMahesh,   Try this, SET COUNT=COUNT+1; SET SQLTXT='SQLTXT'||COUNT; CALL DBC.SYSEXECSQL(:SQLTXT)   Thanks, Dinesh
1615 Jun 2015 @ 07:41 PDTDatabaseReplyTperf calculation for my systemKaushik,   There is a TPERF rating for every Teradata Systems. By using that TPERF rating for your system, you can able to calculate the required TPERF. Even I don't have much idea on th...
1510 Jun 2015 @ 11:55 PDTDatabaseReplyPartition Access CountHi, Can someone answer this question?  Thanks, Dinesh
1414 May 2015 @ 10:04 PDTDatabaseReplyStats Manager Issue during Analyze job :Unable to synchronize SystemId: 2 | id: 4 with Teradata on 'AnalyzeJob:5'!Hi, Even I have got the same error on Collect Job.   Unable to synchronize SystemId: 5 | id: 33 with Teradata on 'CollectJob:35'!     We are on TD 14.10 ...
1321 Apr 2015 @ 09:52 PDTDatabaseTopicAWT Count more than 500? !!Hi All,   It seems WorkTypeInuse00, WorkTypeInuse01 vaules from DBC.ResUsageSawt/PDCRINFO.ResUsageSAWT  are returning wrong values. And the total awt count (WorkType...
1215 Apr 2015 @ 01:59 PDTViewpointReplyUtility typesGryback, Thanks for the links. But I could not able to differentiate "mload" and "standalone mload". Could you explain further more on this? Thanks, Dinesh
1101 Apr 2015 @ 09:53 PDTViewpointTopicViewpoint alert for PJIHi, Is there any way to setup alert for a session with more PJI in Viewpoint? If no, any other way to attain this?   Thanks, Dinesh
1027 Feb 2015 @ 08:59 PSTViewpointTopicUtility typesHi Folks,       Shed me some ideas on below utility types   •     0 = MultiLoad + FastLoad •1 = MultiLoad •2 = FastLoad &bu...
927 Feb 2015 @ 08:48 PSTDatabaseReplyEncryption in TeradataThanks Raja and Tuen.
823 Jan 2015 @ 11:43 PSTDatabaseReplyEncryption in TeradataThanks for the info Raja. So, Teradata doesn't have any inbuilt encryption mechanism to protect the data? Like storing the row values in tables with encrypted form. I have seen few UDFs for en...
721 Jan 2015 @ 02:02 PSTDatabaseTopicEncryption in TeradataHi All, How encryption happens in Teradata? What are the different levels of encryption defined in Teradata? And of course decryption too. Thanks, Dinesh
602 Jan 2014 @ 11:25 PSTViewpointReplyDBCCONS partition sessionsThanks for the info stever. Is there any doc available in TAYS? If so, someone please let me know. 
501 Jan 2014 @ 08:02 PSTViewpointTopicDBCCONS partition sessionsHi All,    After reading this KA : KAP1B930A, I want to know what is DBCCONS partition sessions? Is there any way to see those details?    Thanks, Dinesh
421 Oct 2013 @ 07:17 PDTDatabaseReplyMoving data between 2 servers in TeradataThanks jk186010, it worked.   Can I do the same through SQL Assistant or BTEQ?   Thanks,   Dinesh
327 Aug 2013 @ 07:16 PDTGeneralReplyWhat is the alternative for CALL DBC.SYSEXECSQL?Hi Sroope, What's the solution for problem 1? How to use select in DBC.SYSEXECSQL()? Any other way to attain this? Please help !   Dinesh
203 Jun 2013 @ 11:49 PDTDatabaseReplyRevoke UserHi wambli, DBC.LogonRules view has a column named LogonStatus which contains the flag whether user is granted (G) or revoked (R) logon access. This view uses information from real table DBC.LogonR...

Pages