43 | 24 Jan 2008 @ 05:29 PST | Database | Reply | updating date value | Rock,Have you had an opportunity to check the SYSCALENDAR database? There, you will find a table called calendar that is already populated for many years and it is very useful, in my opinion, to he... |
42 | 21 Jan 2008 @ 11:23 PST | Database | Reply | time from timestamp | Hi gander_ss,Try the following and see if it helps you:SELECT CAST((CAST(current_timestamp(0) AS TIME(0) WITH TIME ZONE)) AS CHAR(8));Cheers. |
41 | 21 Jan 2008 @ 11:04 PST | UDA | Reply | Multiload in ETL | Kartheek,I have had many good experiences using Multiload. It is a very fast load tool, except.... when you have a problem with your layout or field consistency, like datatype mismatch, where the "... |
40 | 18 Jan 2008 @ 10:30 PST | Database | Reply | Teradata Manager - No Profiles | Have you run the utility "Database Setup" from Teradata Manager menu?You must run this utility first, before trying to use Teradata Manager. It will setup Teradata Manager environment, creating a u... |
39 | 18 Jan 2008 @ 10:17 PST | UDA | Reply | tERADATA demo cD | Teradata Junior,Have you tried to order a demo copy from Teradata site? I ordered one from Brazil, and it took about one week to be in my hands!Good luck! |
38 | 16 Jan 2008 @ 11:53 PST | Tools | Reply | How to create mulitple stored procedures in one file via BTEQ | Hi Nancy,Have you tried to use the BTEQ tool in batch mode?Example:You may execute the following command line at the OS prompt: # bteq < test.txt where "test.txt" is a text file created i... |
37 | 16 Jan 2008 @ 11:37 PST | Marketing & CRM | Topic | Adding user functions at TRM environment | Hello,I would like to know if someone have already tried to add some user function at TCRM 5.2 or TRM 6.0 environments, to be made available as part of the solution to the users. In Java programmin... |
36 | 15 Jan 2008 @ 10:17 PST | Database | Reply | Dropping Statistics on a table in teradata | Vineet,If you take a look at the manual "SQL Reference: Data Definition Statements", you will be able to find the command "DROP STATISTICS" in detail, which is the command to be used to remove stat... |
35 | 15 Jan 2008 @ 06:22 PST | Database | Reply | Converting number of seconds to Minutes and Seconds | Hi Andrew,I could try the following to see if it helps:select cast((interval '100' second) as interval minute to second(0));I hope this helps!Cheers |
34 | 09 Nov 2007 @ 11:48 PST | Analytics | Reply | Integer to date conversion - Error | Laxmi,Maybe the following structure helps you:create table test (id INTEGER);INSERT TEST VALUES (2007090909);INSERT TEST VALUES (2007110914);SELECT CAST((CAST (ID AS CHAR(10))) AS TIMESTAMP FORMAT ... |
33 | 09 Nov 2007 @ 11:35 PST | Analytics | Reply | string surch problum | Rahul,Maybe the following helps you to accomplish what you are looking for:create table test (id char(20));insert test values ('ADJEIW');insert test values ('adfrrt');insert test values ('12i#()');... |
32 | 01 Nov 2007 @ 05:05 PDT | Third Party Software | Reply | Can we give ROLENAME in the CREATE USER quey? | flair123,I am sorry, but I have never seen a reserved word "ROLEBACK" before! Is it a new reserved word?Following I have inserted a CREATE USER structure that may help you:CREATE USER "Jones" FROM ... |
31 | 01 Nov 2007 @ 04:51 PDT | Connectivity | Reply | Query regarding ODBC driver | Dinesh,The ODBC Driver 03.03.00.20 for MS-Windows supports Teradata RDBMS V2R4.1.3 and V2R4.2.Hope this helps! |
30 | 30 Oct 2007 @ 05:01 PDT | Database | Reply | Variables and Bteq | Paulo2007,I usually separate the Teradata load and unload utilities into 3 groups:Multiload, Fastexport and Tpump: Although each of these tools have their own set of commands, they have also a comm... |
29 | 30 Oct 2007 @ 10:52 PDT | Tools | Reply | Searching and Running the different Teradata utilities in Unix Environment | N.V.Balasubramaniam,One last comment: for some reason, a peace of what I wrote you was cut. Please, take a look at the attached (text.txt) file, and disregard the same phrase from the previous mess... |
28 | 30 Oct 2007 @ 10:03 PDT | Tools | Reply | Searching and Running the different Teradata utilities in Unix Environment | N.V.Balasubramaniam,There is no shell script to you run with the tool. You will have to create them by yourself!You may open the Fastload manual, for example, and look for an example provided there... |
27 | 30 Oct 2007 @ 07:29 PDT | Database | Reply | Column compression and Table header size | Leo Issac,Following I am inserting my 2 cents to help you:1) The size of table header is variable, and can range from 512 to 130,560 bytes (1 to 255 sectors). The table header must fit at maxim... |
26 | 30 Oct 2007 @ 07:01 PDT | Tools | Reply | Searching and Running the different Teradata utilities in Unix Environment | N.V.Balasubramaniam,I am not sure if I understood you correctly, but I will try to provide you with some "light".... :-)1) To run scripts using Teradata tools you could use the following format at ... |
25 | 29 Oct 2007 @ 04:09 PDT | Training | Reply | Cannot create dbcmngr database | Hillcd,Have you tried to run the "Database Setup" utility, located under "Start>Programs>Teradata Manager 7.1"? If so, what name have you given to the Database, at "Database name"? Can you tr... |
24 | 29 Oct 2007 @ 04:00 PDT | Tools | Reply | Fastload | Harry,The Fastload utility should be located under "..\NCR\Teradata Client\Bin" directory. If you are not being able to find the executable "fastload.exe" under this directory, I am inserting some ... |
23 | 01 Oct 2007 @ 01:33 PDT | Database | Reply | What is dynamic sql | Chinmay,Dynamic SQL is a concept that allows you to compose your SQL code "on the fly". I have used it inside stored procedures, although it allowed to be used with Embedded SQL as well. I used it ... |
22 | 01 Oct 2007 @ 12:46 PDT | UDA | Reply | TIMESTAMP | A couple of question that might help:1) The CURRENT_TIME value is obtained on the Teradata server. Is the clock of that server(s) properly set?2) Are you working with Teradata for Unix or Windows? ... |
21 | 27 Sep 2007 @ 05:09 PDT | Training | Reply | Teradata Certification. | Shantanu,I strongly recommend you to use the Teradata V2R5 manuals in your preparation to the Certification exam. You can download the manuals for free from Teradata site, at www.teradata.com/Resou... |
20 | 27 Sep 2007 @ 08:00 PDT | Database | Reply | Executing FastExport | 1) Install the FastExport for Windows2) Make sure that the installation directory has been included in the PATH environment variable3) To text if the application is correctly installed and running,... |
19 | 24 Sep 2007 @ 07:54 PDT | Analytics | Reply | Session in TD | Vimal,I will try to provide you with some information on this subject.Each client application establish a connection with Teradata through a session. Depending the application, multiple sessions ma... |