#DateForumTypeThreadPost
6508 Nov 2011 @ 07:39 PSTDatabaseTopicRecursive SQL Hi   I've the below data format:   c1       c2 1          1 1   &n...
6405 Mar 2008 @ 09:56 PSTToolsReplyfastload script insert phase error.Insert a carriage return {ENTER} after the last record and try again.
6322 Feb 2008 @ 01:38 PSTDatabaseReplyCan't Login into server database after creating system DSNOops, I was trying to say:127.0.0.1 tdpidcop1 tdpid
6222 Feb 2008 @ 01:37 PSTDatabaseReplyCan't Login into server database after creating system DSNCLI based programs would normally look at the tdpid in the hosts file. Add a tdpid entry in the hosts file under the below directory:C:\WINDOWS\SYSTEM32\DRIVERS\ETC127.0.0.1 cop1 tdpidA td...
6111 Feb 2008 @ 04:29 PSTDatabaseReplyneed data between selected datesBelow is a way to use the between..and. You would need a single date expression to check between..and range:WHERE AL1.Pres_Ofr_Stat_Strt_Dt Between d'2007-10-30' and d'2007-11-30' AND AL1.Pres_Ofr_...
6018 Jan 2008 @ 10:55 PSTDatabaseReplyTeradata Manager - No ProfilesThanks FabioAfter my first login to the Teradata Manager, I changed the authorization to 2 different users other than the defualt user created by Teradata Manager. That was the reason, I was not ab...
5918 Jan 2008 @ 09:43 PSTToolsReplyTPT Load ErrorYou are right! TargetTable Attribute was missing in my Load Operator definition. Thanks a lot. It works now.
5817 Jan 2008 @ 04:09 PSTToolsTopicTPT Load ErrorI'm trying to execute a TPT script and I get a Status = Not Found error while executing the DataConnector.Below is my Public log file:Teradata Parallel Transporter Version 08.02.00.00Execution Plan...
5716 Jan 2008 @ 10:33 PSTDatabaseReplytime from timestampYou can try something like this:SELECT cast(cast(CAST(CURRENT_TIMESTAMP AS char(19)) as TIMESTAMP(0)) as time(0)); *** Query completed. One row found. One column returned. *** Total elapsed time wa...
5615 Jan 2008 @ 09:57 PSTDatabaseTopicTeradata Manager - No ProfilesHi I installed Teradata Manager, accepting all the defaults during installation. I was able to login to the Teradata Manager right after the installation without any issues. But, When I try to acce...
5510 Jan 2008 @ 05:40 PSTDatabaseTopicBteQ - DBS CrashedHiI get the following error when I'm trying to login to our dev box through BTEQ:*** Warning: DBS CRASHED OR SESSIONS RESET. RECOVERY IN PROGRESS> I've the following entries in my hosts file:10...
5426 Dec 2007 @ 02:22 PSTDatabaseReplyTeradata IDENTITY columnsYes that would work. You could also use the restriction, where you don't select the Identity column in your insert list:INSERT INTO test12 (eno, ename) SELECT eno, ename FROM test11
5305 Dec 2007 @ 11:18 PSTAnalyticsReplyBasic diffrences between V2R5 and V2R6You need to look at the Release summary which can be downloaded from the Teradata Products web site. www.info.teradata.com
5228 Nov 2007 @ 03:15 PSTUDAReplyDate rangeselect * from sys_calendar.calendar where calendar_date between current_date-7 and current_date order by calendar_dateThe above query does return rows for me. Check the column that you are using in...
5128 Nov 2007 @ 02:23 PSTToolsReplyTeradata Equivalent of oracle Translate functionYou may use UDF's to accomplish this. There are some pre-defined UDF's for oracle functions available in the Teradata site. You may want to look at that to get some directions:http://www.teradata.c...
5028 Nov 2007 @ 02:15 PSTDatabaseReplycollect stats probI'm not sure if the statistics to an empty table would mean anything to the optimizer. Always try to collect stats after the data load. And, as others have suggested in your other post, recollect s...
4926 Nov 2007 @ 10:19 PSTToolsReplyFastload Script is Erroring out with the Highest error code='8' while Running a shell scriptFrom which directory are you calling the fastload? See, if the directory where the files are, can be accessed from the directory from where you are invoking the fastload. Though the files have a un...
4819 Nov 2007 @ 09:44 PSTDatabaseReplyGetting a person's exact ageyou may try this:select ((current_date - date '1990-10-31') year(4)) as age
4719 Nov 2007 @ 09:36 PSTDatabaseReplyInserting current_timestamp value into timestamp(0) columnTo insert current timestamp for any column, just use current_timestamp. You don't have to select current_timestamp inside an insert statement.
4616 Nov 2007 @ 01:10 PSTToolsReplyNumber of rows written by FastExportI'm not sure if you could get that information to any variable but you sure could direct the output to a log file and use grep and other unix commands to get that value.
4515 Nov 2007 @ 01:27 PSTDatabaseReplyDatabase and UserThe same question has been answered multiple times by different persons. Please spend some time to search for past replies before posting any question.
4413 Nov 2007 @ 10:26 PSTDatabaseReplyWhat is Multi-Level Partitioning in TD 12Multilevel partitioning allows each partition to be sub partitioned. There are some limitations on defining the levels and I guess, each level must define at least 2 partitions. As Dieter said, the...
4301 Nov 2007 @ 01:47 PDTAnalyticsReplyVolatile Tables - Current DisplayI'm not clear on the first part of the command. Can you re-post it?
4201 Nov 2007 @ 01:25 PDTDatabaseReply10065 WSA E HostUnreach:The Teradata server can't currently be reached over this networkAre you trying to install on a machine that is in the network or stand alone/laptop?
4124 Oct 2007 @ 09:53 PDTDatabaseReplyHelp with ERRORCODE.You can handle the errors in Unix by entering the below command:> echo $?This would return 0 if successful and some other number > 0 if unsuccessful.The above piece of code looks like you are...

Pages