#DateForumTypeThreadPost
1821 Sep 2007 @ 07:38 PDTDatabaseReplyIncremental Backup in V2R5Matt,The incremental backup process in Teradata is not difficult.There is a Teradata manual called "Archive/Recovery Utility Reference" that I would like to recommend you to read and do some tests ...
1720 Sep 2007 @ 01:19 PDTUDAReplycalculatations on timestampsI did some adjustments in your previous query:insert into marc (Extract_dt, Component, Start_dt, End_dt, Duration) values ('20070827', 'MarcTest', '2007-06-01 15:33:05.230000', '2007-06-01 16:34...
1620 Sep 2007 @ 08:42 PDTToolsReplyFastExport script and output delimitersI typically do the following, in order to eliminate the TABs:select CAST(first_col AS CHAR(N)) || ';' || CAST (second_col AS CHAR(N)) || etc... from my_tablewhere "||" is the concatenation operator.
1520 Sep 2007 @ 07:57 PDTDatabaseReplyHow to enable RSS TablesAs far as I know, those tables contains the following information:SDSK: contains values for system disksPDSK: contains values for logical disks belonging to AMPsI hope this helps.
1419 Sep 2007 @ 04:49 PDTTrainingReplyTeradata Basic Certification HelpHi Akther,You may find all Teradata manuals at www.teradata.com, then go to "Resources/Technical Documentation", then select "Online Publication".Once there, you will be able to download all the Te...
1319 Sep 2007 @ 04:44 PDTDatabaseReplyHow to enable RSS TablesJob_Agent,There are several ways that you may follow to accomplish this:1) If you have the MP-RAS graphical environment enabled, you may . active the dbw (Database Window) tool (# dbw ); . go ...
1218 Sep 2007 @ 08:31 PDTAnalyticsReplymonths_between terradataSylvi,I think you could spend some time studying the interval datatype, that it is great with date calculations, but unfortunately it is not much intuitive.One example that might help:select date -...
1117 Sep 2007 @ 08:32 PDTConnectivityReplyODBC driver removal - need help pleaseViviane,When I removed my Teradata installation manually, I did a search in registry looking for expressions containing the word "teradata" first, and then I did a new search looking for "tdat". I ...
1017 Sep 2007 @ 01:29 PDTDatabaseReplyCREATE TABLE AS COLUMNS DEFINITIONS....c19,I you are planning to create a partial create table definition, I agree with you that the "CREATE TABLE AS" command would not help too much.In this case, one thing that comes to my mind is to q...
917 Sep 2007 @ 08:06 PDTDatabaseReplyCREATE TABLE AS COLUMNS DEFINITIONS....c19,As far as I know, Teradata would have as base to create the new table the source information, as it was defined originally.So, if the column "COMPLAINT_REFERENCE_NUMBER" was originally created ...
813 Sep 2007 @ 07:52 PDTDatabaseReplyArcmain RollforwardJob_Agent,I never used the rollforward command to apply the Teradata log (permanent journal) while using the COPY command. I've never heard anything against using it that way, though, and did not f...
712 Sep 2007 @ 05:00 PDTConnectivityReplyODBC driver removal - need help pleaseViviane,Have you tried to uninstall through Start/Configurations/Control Panel/Add or Remove Programs?Could you provide the error message that you are receiving back?I had a similar error in the pa...
612 Sep 2007 @ 12:58 PDTDatabaseReplyWhich is better RAID 1 or RAID 5 ? Can i have the difference?Rishikesh,You can obtain more detailed information about RAID concept in the following site: http://en.wikipedia.org/wiki/RAIDFabio
511 Sep 2007 @ 07:41 PDTDatabaseReplyTeradata Demo ConfigurationI agree with Jim's comments!Playing with Teradata Demo will provide you with the knowledge to understand the mechanics and to discuss about Teradata VProcs manipulation. Typically, in real life, Te...
410 Sep 2007 @ 04:00 PDTDatabaseReplyTeradata Demo ConfigurationAndres,Changing the Teradata configuration is very tricky, and it is not an easy task in my opinion. My experience with Oracle and Sybase SQL Server showed me that those tools are easier to install...
306 Sep 2007 @ 08:50 PDTDatabaseReplyWhat does Sessions means?Rishikesh,The command ".SESSIONS" is typically used to provide Teradata load tools parallelism.When you are loading data into Teradata, you must provide the used tool with a file to be loaded. Gene...
206 Sep 2007 @ 08:26 PDTDatabaseReplyTeradata Demo ConfigurationHello Andres,I am not sure why you would like to increase the number of vprocs from Teradata Demo. Is it for practicing the Teradata configuration process?The Teradata demo software is made availab...
129 Aug 2007 @ 09:17 PDTDatabaseTopicStored Procedures behavior in a high concurrence environmentHi,I am working with a system containing 14 nodes.A user wants to keep centralized into Teradata some scoring rules.He considered to create a stored procedure with some parameters, because it is ea...

Pages