417 | 01 Mar 2006 @ 09:42 PST | Barry-1604 | Analytics | Reply | how to convert a period of D+30, D+60 etc to exact day and month | You can do quite a bit with the dates without using SysCalendar. For instance, to add or subtract months, you can use the ADD_MONTHS feature:SELECT ADD_MONTHS(date_col, 2) /* this will add two mo... |
416 | 01 Mar 2006 @ 09:28 PST | Barry-1604 | UDA | Reply | find out the number of nodes in a teradata architecture | Assuming that all of your nodes were functioning yesterday and you have resusage data being captured (and you have access to resusage data), the following query would tell you the number of nodes:s... |
415 | 01 Mar 2006 @ 09:11 PST | vinod_sugur | Database | Reply | Secondary Index | if the query which we fire reminas the same always with only where clause equlaity changes so still we need to collect the statistics.Regards,Vinod |
414 | 01 Mar 2006 @ 07:26 PST | Barry-1604 | Database | Reply | Locking modifer for a MSR | The two statements are equivalent only because BTEQ understands the semicolon with additional syntax behind it to be a multi-statement request AND the statement is a DML command (as opposed to a DD... |
413 | 01 Mar 2006 @ 01:01 PST | ANGEL | Database | Topic | Secondary Index | HI,can anyone tell me why do we need Secondary Index when we already have PI. Cite some example where we we use both PI and SIThanks |
412 | 01 Mar 2006 @ 12:40 PST | ANGEL | Database | Reply | Secondary Index | Hi,It is of the utmost importance to collect statistics on all NUSIs. Statistics might impact whether or not the optimizer chooses to use a secondary index, which could result in substantial differ... |
411 | 28 Feb 2006 @ 11:12 PST | vinod_sugur | Database | Topic | Secondary Index | IS it necessary to always collect statistics on NUSI? At my end the table is frequently accessed and due to some reason we can't collect statitics so does this means that the NUSI on the table will... |
410 | 28 Feb 2006 @ 10:29 PST | SD | Database | Reply | Locking modifer for a MSR | Thanks for your reply, Jim. Can you please elaborate on why the two are equivalent?I have a user interface that accepts the query for a view definition and optionally a locking modifier statement f... |
409 | 28 Feb 2006 @ 06:16 PST | Phoenix Tech | Jobs | Topic | Teradata DBA needed in Phoenix, AZ | Teradata DBA needed immediately in Phoenix, AZ. If interested, please contact Jonathan Heldele at jonathan@phoenixstaff.com with current status and a resume. Follow up will be immediate.Candidate... |
408 | 28 Feb 2006 @ 12:36 PST | TDUser-781 | Tools | Reply | Fast Export | I don't know... Are you using cast on every field and on the "global concat field"? could you please post your final script?Bye, TDUser |
407 | 28 Feb 2006 @ 12:20 PST | Jim Chapman | Tools | Reply | Partitioned tables: multiload vs JDBC | Partitioning has no effect on locking granularity, so concurrency is the same. There is no partition level locking.Multiload always locks the entire table. Single row inserts and updates (assumi... |
406 | 28 Feb 2006 @ 12:09 PST | Jim Chapman | Database | Reply | Locking modifer for a MSR | The two requests are equivalent, so the execution plans are identical as shown by the explains. What difference were you expecting? |
405 | 28 Feb 2006 @ 11:01 PST | SD | UDA | Reply | find out the number of nodes in a teradata architecture | Assuming it is a MPRAS installation, run -# cat /ntos/mpplistwill show you the list of nodes for the Teradata DBS and also which node is the PDN. |
404 | 28 Feb 2006 @ 10:48 PST | SD | Tools | Topic | Partitioned tables: multiload vs JDBC | I would like to know if partitioned tables permit concurrent inserts/updates to multiple partitions of the same table when using multiload only or any other client as well.Put differently, my quest... |
403 | 28 Feb 2006 @ 10:39 PST | SD | Database | Topic | Locking modifer for a MSR | I am trying to understand the locking modifier. Referring to the following two explains, I am not clear why the explains are the same though the locking modifier is applied differently in both case... |
402 | 28 Feb 2006 @ 09:28 PST | TS | Tools | Reply | Fast Export | Yes, thnx a lot!But there's a small query again, on running that script, the output / txt file which is being created is as follows: H 1362500|0000000013625002| 100|1995-12-04| ... |
401 | 28 Feb 2006 @ 09:17 PST | TDUser-781 | Tools | Reply | Fast Export | I don't really know if casting every field of the select is necessary when exporting a readable output.When you use a FXP - let me say - in the "standard way" (that is you export a file in fastload... |
400 | 28 Feb 2006 @ 08:41 PST | stami27-2406 | Database | Reply | Trial Teradata-DWH-CD | I've found it!http://www.teradata.com/t/page/44749/index.html |
399 | 28 Feb 2006 @ 08:32 PST | TS | Tools | Reply | multiload | Hi,While a multiload job is running in batch mode, u can view its status in the log file which is being created. Similarly the status of abended jobs can also be seen in the log file created.Hope i... |
398 | 28 Feb 2006 @ 08:22 PST | stami27-2406 | Database | Topic | Trial Teradata-DWH-CD | Hi,does anyone knows if or where can I get a trial Teradata-DWH-CD for Windows/XP? Best Regardsstami27 |
397 | 28 Feb 2006 @ 08:15 PST | lelera | Tools | Topic | multiload | Good Day,How do you monitor the status of your jobs on multiload, and how do you check for the jobs that abended. Is there a scheduler tool you can use to accomplish this? e.g. Unicenter |
396 | 28 Feb 2006 @ 08:00 PST | stami27-2406 | Database | Reply | doesn't have access to create a stored procedure | Hi varun,ask your DBA to give you the create/update/execute rights or if you are the sysdba make that yourself with the Teradata Administrator.Best regardsstami27 |
395 | 28 Feb 2006 @ 07:40 PST | TS | Tools | Reply | Fast Export | Thanks a lot!It worked.Could u pls tell, is it necessary to cast the fields while doing a fast export?Regards,TS. |
394 | 28 Feb 2006 @ 07:20 PST | TDUser-781 | Tools | Reply | Fast Export | Hi,in order to have a readable output you have to cast as char and concat all the fields you are exporting.Like this:SELECT cast((cast(cust_id as char(xx))||cast(acct_nbr as char(xx))||cast(minimum... |
393 | 28 Feb 2006 @ 06:16 PST | TS | Tools | Reply | Fast Export | The following is the code which is being executed, still the output is not in the correct format..LOGTABLE db.datastore_log ;.logon;.BEGIN EXPORT SESSIONS 20 TENACITY 5 SLEEP 1;.EXPORT OUTFILE c:\O... |