65 | 08 Nov 2011 @ 07:39 PST | Database | Topic | Recursive SQL |
Hi
I've the below data format:
c1 c2
1 1
1 &n... |
64 | 05 Mar 2008 @ 09:56 PST | Tools | Reply | fastload script insert phase error. | Insert a carriage return {ENTER} after the last record and try again. |
63 | 22 Feb 2008 @ 01:38 PST | Database | Reply | Can't Login into server database after creating system DSN | Oops, I was trying to say:127.0.0.1 tdpidcop1 tdpid |
62 | 22 Feb 2008 @ 01:37 PST | Database | Reply | Can't Login into server database after creating system DSN | CLI 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... |
61 | 11 Feb 2008 @ 04:29 PST | Database | Reply | need data between selected dates | Below 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_... |
60 | 18 Jan 2008 @ 10:55 PST | Database | Reply | Teradata Manager - No Profiles | Thanks 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... |
59 | 18 Jan 2008 @ 09:43 PST | Tools | Reply | TPT Load Error | You are right! TargetTable Attribute was missing in my Load Operator definition. Thanks a lot. It works now. |
58 | 17 Jan 2008 @ 04:09 PST | Tools | Topic | TPT Load Error | I'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... |
57 | 16 Jan 2008 @ 10:33 PST | Database | Reply | time from timestamp | You 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... |
56 | 15 Jan 2008 @ 09:57 PST | Database | Topic | Teradata Manager - No Profiles | Hi 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... |
55 | 10 Jan 2008 @ 05:40 PST | Database | Topic | BteQ - DBS Crashed | HiI 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... |
54 | 26 Dec 2007 @ 02:22 PST | Database | Reply | Teradata IDENTITY columns | Yes 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 |
53 | 05 Dec 2007 @ 11:18 PST | Analytics | Reply | Basic diffrences between V2R5 and V2R6 | You need to look at the Release summary which can be downloaded from the Teradata Products web site. www.info.teradata.com |
52 | 28 Nov 2007 @ 03:15 PST | UDA | Reply | Date range | select * 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... |
51 | 28 Nov 2007 @ 02:23 PST | Tools | Reply | Teradata Equivalent of oracle Translate function | You 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... |
50 | 28 Nov 2007 @ 02:15 PST | Database | Reply | collect stats prob | I'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... |
49 | 26 Nov 2007 @ 10:19 PST | Tools | Reply | Fastload Script is Erroring out with the Highest error code='8' while Running a shell script | From 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... |
48 | 19 Nov 2007 @ 09:44 PST | Database | Reply | Getting a person's exact age | you may try this:select ((current_date - date '1990-10-31') year(4)) as age |
47 | 19 Nov 2007 @ 09:36 PST | Database | Reply | Inserting current_timestamp value into timestamp(0) column | To insert current timestamp for any column, just use current_timestamp. You don't have to select current_timestamp inside an insert statement. |
46 | 16 Nov 2007 @ 01:10 PST | Tools | Reply | Number of rows written by FastExport | I'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. |
45 | 15 Nov 2007 @ 01:27 PST | Database | Reply | Database and User | The same question has been answered multiple times by different persons. Please spend some time to search for past replies before posting any question. |
44 | 13 Nov 2007 @ 10:26 PST | Database | Reply | What is Multi-Level Partitioning in TD 12 | Multilevel 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... |
43 | 01 Nov 2007 @ 01:47 PDT | Analytics | Reply | Volatile Tables - Current Display | I'm not clear on the first part of the command. Can you re-post it? |
42 | 01 Nov 2007 @ 01:25 PDT | Database | Reply | 10065 WSA E HostUnreach:The Teradata server can't currently be reached over this network | Are you trying to install on a machine that is in the network or stand alone/laptop? |
41 | 24 Oct 2007 @ 09:53 PDT | Database | Reply | Help 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... |