#DateForumTypeThreadPost
4324 Jan 2008 @ 05:29 PSTDatabaseReplyupdating date valueRock,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...
4221 Jan 2008 @ 11:23 PSTDatabaseReplytime from timestampHi 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.
4121 Jan 2008 @ 11:04 PSTUDAReplyMultiload in ETLKartheek,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 "...
4018 Jan 2008 @ 10:30 PSTDatabaseReplyTeradata Manager - No ProfilesHave 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...
3918 Jan 2008 @ 10:17 PSTUDAReplytERADATA demo cDTeradata 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!
3816 Jan 2008 @ 11:53 PSTToolsReplyHow to create mulitple stored procedures in one file via BTEQHi 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...
3716 Jan 2008 @ 11:37 PSTMarketing & CRMTopicAdding user functions at TRM environmentHello,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...
3615 Jan 2008 @ 10:17 PSTDatabaseReplyDropping Statistics on a table in teradataVineet,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...
3515 Jan 2008 @ 06:22 PSTDatabaseReplyConverting number of seconds to Minutes and SecondsHi 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
3409 Nov 2007 @ 11:48 PSTAnalyticsReplyInteger to date conversion - ErrorLaxmi,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 ...
3309 Nov 2007 @ 11:35 PSTAnalyticsReplystring surch problumRahul,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#()');...
3201 Nov 2007 @ 05:05 PDTThird Party SoftwareReplyCan 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 ...
3101 Nov 2007 @ 04:51 PDTConnectivityReplyQuery regarding ODBC driverDinesh,The ODBC Driver 03.03.00.20 for MS-Windows supports Teradata RDBMS V2R4.1.3 and V2R4.2.Hope this helps!
3030 Oct 2007 @ 05:01 PDTDatabaseReplyVariables and BteqPaulo2007,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...
2930 Oct 2007 @ 10:52 PDTToolsReplySearching and Running the different Teradata utilities in Unix EnvironmentN.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...
2830 Oct 2007 @ 10:03 PDTToolsReplySearching and Running the different Teradata utilities in Unix EnvironmentN.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...
2730 Oct 2007 @ 07:29 PDTDatabaseReplyColumn compression and Table header sizeLeo 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...
2630 Oct 2007 @ 07:01 PDTToolsReplySearching and Running the different Teradata utilities in Unix EnvironmentN.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 ...
2529 Oct 2007 @ 04:09 PDTTrainingReplyCannot create dbcmngr databaseHillcd,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...
2429 Oct 2007 @ 04:00 PDTToolsReplyFastloadHarry,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 ...
2301 Oct 2007 @ 01:33 PDTDatabaseReplyWhat is dynamic sqlChinmay,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 ...
2201 Oct 2007 @ 12:46 PDTUDAReplyTIMESTAMPA 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? ...
2127 Sep 2007 @ 05:09 PDTTrainingReplyTeradata 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...
2027 Sep 2007 @ 08:00 PDTDatabaseReplyExecuting FastExport1) 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,...
1924 Sep 2007 @ 07:54 PDTAnalyticsReplySession in TDVimal,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...

Pages