#DateForumTypeThreadPost
11506 Aug 2014 @ 10:39 PDTDatabaseReplyPermissions to a viewVijay Mani, Typically granting the access at the column level is not done as it becomes difficult to maintain and manage if there are a huge number of databases and table. it will be either at the ...
11406 Aug 2014 @ 10:23 PDTDatabaseReplyFront-end object does not exist errorHow are the users profiles configured. Variance of the results  of the same query executed by different users depends primarily on 2 factors. one is the load on the system and the other is the...
11306 Aug 2014 @ 10:13 PDTDatabaseReplyNeed metrics for database, table, and column usage in queries. TD 13.10/14.10Do you have PDCR enabled for your system. if yes, there will be "historical counterparts" for those in the DBC tables. Usually there will be a cron which flushes out the data from DBC to ...
11204 Aug 2014 @ 09:07 PDTDatabaseReplyTerminal Window Closed AccidentallyYou can define the connection time alerts in the viewpoint under Teradata Systems>>Alerts>>session>>Connection_time
11130 Jul 2014 @ 09:00 PDTDatabaseReplyTimestamp format on teradata retrievali do not think there is a way to validate the incoming data. Here is an example that may explain a date field coming in as 1212014. if we do not spexify a format this can be considered as Jan 21st ...
11029 Jul 2014 @ 02:16 PDTViewpointReplyHow can users abort their own queries without being able to abort anyone else's? SELECT AbortSessions (1, 'username', 0, 'Y', 'Y');  
10929 Jul 2014 @ 07:58 PDTViewpointReplyCreating Different Operating Environmenti second Raja's thoughts on involving the TD folks who were involved in the implementation and configuration. Does another workload ruleset suffice your need. If yes, then based on the us...
10829 Jul 2014 @ 07:51 PDTViewpointReplyPDCR Vs Viewpointlooks like there is primarily a misunderstanding. DBC generally has one day of data of the activities that are performed on the database. All the data of that day will be flushed into the database...
10729 Jul 2014 @ 07:36 PDTDatabaseReplyThoughts on CPUBusy caclulations.(sum(CPUUExec)+sum(CPUUServ)+sum(CPUIoWait)+sum(CPUIdle). This is used to calculate the total available cpu secs on the system.  
10628 Jul 2014 @ 12:31 PDTDatabaseReplyhexadecimal--->decimal Select '28E1',((((((Index('0123456789abcdef',Substr('28E1',         1,1)) -1) * 16 ) + ((Index('0123456789abcdef',Substr('2...
10528 Jul 2014 @ 11:11 PDTDatabaseReplyhelp with SQLWill the COL2, COL3 and COL4 be having multiple values or only a single repetitive value like 75211 mentioned in the example 2. if so the qury given be Glass will work.
10428 Jul 2014 @ 10:45 PDTDatabaseReplyComplex SQL ScenarioAre the ID's constant, i mean are the rules set based on ID column. is Rule 1 fixed for ID=1 etc..
10328 Jul 2014 @ 10:25 PDTDatabaseReplyTotal Quantity of Items Sold per Month@Kartheek, Teradata does not support RR format. Also the max timestamp allowed is timestamp(6). If you need to convert RR notation you need to cast that column in character and then add the century...
10228 Jul 2014 @ 10:13 PDTDatabaseReplyNeed help on a case scenarioin Table1 how will you be able to identify that the 2nd row pertains to ID1 and 4th row to ID 2 or other ID. if you have the ID in 2nd row to be 1, then what you can do is a row number over date pa...
10121 Jul 2014 @ 01:10 PDTDatabaseReplyIs there any debugger option in Teradata Studio.i do not think we have a debugger available in Studio express or in sql assistant. Usually in order to debug a large query we should be taking all the subqueries individually and start debugiing di...
10018 Jul 2014 @ 09:19 PDTDatabaseReplyImpact of using a compressed column in any join or predicate clause in a queryIO would reduce due to MVC on any table. Even in a join and when reading from the table and writing into spool the read part would be less due to MVC.
9916 Jul 2014 @ 09:44 PDTToolsReplyUnity Datamover standalone to update standby databaseIs there a way you can identify the changed data? is there anything like a flag which says that some the recent records are updated. You can use that flag in the parameter "sql_where_clause&qu...
9815 Jul 2014 @ 07:35 PDTToolsReplyFastload Problem: Invalid Fastload StatementCan you check for what is the error code in the ET table(asign_err1) that was created.
9714 Jul 2014 @ 07:25 PDTDatabaseReply10065 WSA E HostUnreach: The Teradata Server can't currently be reached over this networkCan you please check with your network team if there is an ACL that needs to be opened between the server and your client machine on the port 1025. One easy way to check is to first do a telnet <...
9614 Jul 2014 @ 07:21 PDTDatabaseReplyExecuting several Macros in a Macrowhy not use a wrapper shell script and run a cron(scehdule) for this shell which will contain all the macros?
9511 Jul 2014 @ 01:26 PDTDatabaseReplyConditional CASE statement inside an INSERT TO statement create table db_name.test(col1 int, col2 char(1)) insert into db_name.test values(2,'a'); insert into db_name.test values(3,'a'); insert into db_name.test values(4,'b'...
9410 Jul 2014 @ 11:20 PDTDatabaseReplyUsage of Composite Primary IndexIn your where clause you need to specify both the columns in order to make use of the PI by the optimizer else it will go for a FTS(full table scan). The reason being the row hash would be calculat...
9310 Jul 2014 @ 08:29 PDTToolsReplyFASTLOAD ERROR 20131201Û 92ý61ý31Û6 from the value after the 4th delimiter is it entered as a new row in the data?
9209 Jul 2014 @ 07:14 PDTGeneralReplyReasons for Product Join..Based on the stats available, the optimizer will decide on the best possible plan for the execution of a query. If two tables are being joined and one of them is a pretty small table, usually the f...
9109 Jul 2014 @ 07:00 PDTGeneralReplyHow to start teradata service in suse linux vmware image (teradata express 13.0)There is no default directory. the directory would be specified in the .export outfile command inside the script. if you do not specify a directory and just specify the file name, then the director...

Pages