26 | 20 Nov 2015 @ 03:00 PST | Database | Reply | Partitions on Character fields in 14.10 | Hi, 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... |
25 | 20 Nov 2015 @ 01:42 PST | Tools | Reply | Convert date format m/d/yyyy to mm/dd/yyyy in TPT | Hi, 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... |
24 | 20 Nov 2015 @ 01:39 PST | UDA | Reply | FORMAT m/d/yy column as DD/MM/YYYY | Hi ,
This should work.
Select '1/2/14' as date1,
TO_CHAR(TO_DATE (
case
when strtok(date1, '/', 2) between 1 and 9 then ... |
23 | 20 Nov 2015 @ 01:34 PST | Database | Reply | Conversion from mm/dd/yyyy to yyyy-mm-dd | Hi,
This should work.
Select '1/2/1900' as date1,
TO_CHAR(TO_DATE (
case
when strtok(date1, '/', 2) between 1 and 9 ... |
22 | 08 Nov 2015 @ 07:20 PST | Database | Reply | Teradata SQL Assistant Import | Hi,
Below link would help you.
https://forums.teradata.com/forum/database/teradata-sql-assistant-import
Thanks,
Dinesh
|
21 | 08 Nov 2015 @ 07:03 PST | Database | Topic | All row scan count of queries | Hi 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.
... |
20 | 20 Oct 2015 @ 11:44 PDT | Database | Reply | Monitoring Intelligent Memory | Hi,
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... |
19 | 20 Oct 2015 @ 10:16 PDT | Database | Reply | Comparing Two Environment | Hi,
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... |
18 | 25 Jun 2015 @ 08:37 PDT | Database | Reply | Scheduing a stored procedure | Akhil,
You can put the stored procedure in a BTEQ script and schedule the BTEQ script to run through CRONTAB/Windows Scheduled Task.
Thanks,
Dinesh
|
17 | 18 Jun 2015 @ 02:21 PDT | Database | Reply | Looping in Stored Procedure | Mahesh,
Try this,
SET COUNT=COUNT+1;
SET SQLTXT='SQLTXT'||COUNT;
CALL DBC.SYSEXECSQL(:SQLTXT)
Thanks,
Dinesh
|
16 | 15 Jun 2015 @ 07:41 PDT | Database | Reply | Tperf calculation for my system | Kaushik,
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... |
15 | 10 Jun 2015 @ 11:55 PDT | Database | Reply | Partition Access Count | Hi,
Can someone answer this question?
Thanks,
Dinesh
|
14 | 14 May 2015 @ 10:04 PDT | Database | Reply | Stats 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 ... |
13 | 21 Apr 2015 @ 09:52 PDT | Database | Topic | AWT 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... |
12 | 15 Apr 2015 @ 01:59 PDT | Viewpoint | Reply | Utility types | Gryback,
Thanks for the links. But I could not able to differentiate "mload" and "standalone mload". Could you explain further more on this?
Thanks,
Dinesh
|
11 | 01 Apr 2015 @ 09:53 PDT | Viewpoint | Topic | Viewpoint alert for PJI | Hi,
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
|
10 | 27 Feb 2015 @ 08:59 PST | Viewpoint | Topic | Utility types | Hi Folks,
Shed me some ideas on below utility types
• 0 = MultiLoad + FastLoad
•1 = MultiLoad
•2 = FastLoad
&bu... |
9 | 27 Feb 2015 @ 08:48 PST | Database | Reply | Encryption in Teradata | Thanks Raja and Tuen.
|
8 | 23 Jan 2015 @ 11:43 PST | Database | Reply | Encryption in Teradata | Thanks 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... |
7 | 21 Jan 2015 @ 02:02 PST | Database | Topic | Encryption in Teradata | Hi All,
How encryption happens in Teradata? What are the different levels of encryption defined in Teradata? And of course decryption too.
Thanks,
Dinesh
|
6 | 02 Jan 2014 @ 11:25 PST | Viewpoint | Reply | DBCCONS partition sessions | Thanks for the info stever. Is there any doc available in TAYS? If so, someone please let me know.
|
5 | 01 Jan 2014 @ 08:02 PST | Viewpoint | Topic | DBCCONS partition sessions | Hi 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
|
4 | 21 Oct 2013 @ 07:17 PDT | Database | Reply | Moving data between 2 servers in Teradata | Thanks jk186010, it worked.
Can I do the same through SQL Assistant or BTEQ?
Thanks,
Dinesh
|
3 | 27 Aug 2013 @ 07:16 PDT | General | Reply | What 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
|
2 | 03 Jun 2013 @ 11:49 PDT | Database | Reply | Revoke User | Hi 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... |