#DateForumTypeThreadPost
9731 Aug 2007 @ 11:59 PDTDatabaseTopicUnbounded PRECEDING? how to use it in this case.i have a table that has orderid entry_ts worked_by12345 2007-01-26 12:05:16 agent_1 12345 2007-01-27 12:08:20 agent_2 12345 2007-01-27 14:05:16 agent_3 12345 ...
9631 Aug 2007 @ 11:45 PDTDatabaseReplystring to timestamp(0) convesionThank you for the information.
9530 Aug 2007 @ 02:16 PDTDatabaseReplystring to timestamp(0) convesionI got it for the first string conversion FORMAT 'mmmBddByyyyBhh:miT'Aug 29 2007 10:45PM (FORMAT 'mmmBddByyyyBhh:miT')when i did something similar for the second one08/30/07 10:45:00 PM (FORMAT 'mm/...
9430 Aug 2007 @ 01:57 PDTDatabaseTopicstring to timestamp(0) convesionHelloI have a varchar field that has dates in the following formatAug 29 2007 10:45PM08/30/07 10:45:00 PMis there a UDF that converts these to timestamp(0) in the following format 'yyyy-mm-dd hh:mm...
9314 Aug 2007 @ 06:56 PDTDatabaseTopicUDF performance.I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htmby Dennis Calkinsthis function was installed on a database : dbudfdevand this is how we write our sqlsel dbudfdev...
9214 Aug 2007 @ 06:56 PDTConnectivityTopicUDF performance.I installed the is_integer() UDF from http://www.teradataforum.com/is_integer_01.htmby Dennis Calkinsthis function was installed on a database : dbudfdevand this is how we write our sqlsel dbudfdev...
9127 Jul 2007 @ 12:05 PDTDatabaseReplybat file that captures status of a bteqThanks Marcusi will try it!
9025 Jul 2007 @ 08:29 PDTDatabaseTopicbat file that captures status of a bteqall,can some one provide a small example of how to capture the status of a bteq in a windows batch file.***batchfile****@echo onecho started batch filestatus ( bteq < samplebteq.txt) // i am calli...
8920 Jul 2007 @ 12:20 PDTDatabaseReplyTime difference in secondsThanks Barry,we (my Colleagu) also figured out a way by using the extract funciton to extract hours , minutes and seconds and doing the similar calculation.SELECT GMT_END_TIME, GMT_START_TIME, (GM...
8820 Jul 2007 @ 12:13 PDTDatabaseReplyVery UrgentSELECT * FROM dbc.dbcinfo;
8719 Jul 2007 @ 06:45 PDTDatabaseTopicTime difference in secondshello all,i am trying to get the difference between two timestamp fields in secondswhen i use the querySELECT GMT_END_TIME, GMT_START_TIME, (GMT_END_TIME - GMT_START_TIME) SECOND(4) AS SECONDS4F...
8611 Jul 2007 @ 04:18 PDTDatabaseReplyNeed a better way (query request)Dieter That was really cool (and ofcourse it returned the expected answer set)Thanks.Leo, I appreciate your input too.I did not want to use the distinct because of efficiency.
8510 Jul 2007 @ 01:33 PDTToolsReplyRDBMS error 8018 while running fastload.Fred,sorry for coming back to this after a long time.where do we set these "settings"should we set it to full duplex or half duplex?appreciate your help.
8410 Jul 2007 @ 01:14 PDTDatabaseReplyTable definitionsThank you for the information.
8310 Jul 2007 @ 01:11 PDTDatabaseTopicNeed a better way (query request)All,i have a table that has the following informationproduct_id product_desc eff_ts100 product_description_2 2007-07-10 08:49:59100 product_description_2 2007-07-10 08:40:23...
8229 Jun 2007 @ 08:50 PDTDatabaseTopicTable definitionsI was trying to get table definitions for all the tables in a given database and this is the SQL that I used.//////// sql///////////select requesttext from dbc.tableswhere databasename = 'dev_datab...
8127 Jun 2007 @ 01:06 PDTDatabaseReplySpace saved using Compression is exceptionally different from calculated result..here is a pdf for v2R5 multi-value compressionhttp://www.mycustomer.com/download/4228/teradata-111.pdfIt might help answer some questions.I am not sure if there is a new doc for the newer version o...
8006 Jun 2007 @ 12:10 PDTDatabaseReplyLimit rowsselect *from table_T1sample 10
7912 Apr 2007 @ 08:36 PDTDatabaseTopicstring with single quotesHiI have a field that is a string and i need to insert a string along with the single quotes surrounding it can this be done?the data should be 'Feroz'***********************same way can we view st...
7811 Apr 2007 @ 04:39 PDTDatabaseReplyShortest Route to Run Statistics?why dont you use sampling while collecting statistics on some of the columns.you should be careful in choosing the columns though. This way the stats are collected much faster.
7711 Apr 2007 @ 04:37 PDTDatabaseTopicNegative spool spaceWhile I was checking the status of a job (BTEQ) that I was running on Teradata manager, some times I find a negative number in the spool space usage value?How can we have a negative spool space usa...
7620 Mar 2007 @ 10:07 PDTThird Party SoftwareReplyLoading data to base tables directly using InformaticaHihttp://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=10&MessageID=6872check this link for details
7514 Mar 2007 @ 11:52 PDTToolsReplyLoading directly to base tables.Barry Thanks for the information.one quick question. I remember in the past (v2R3), there were some incidents where the MLOAD process failed while loading the data and there was no way to release t...
7413 Mar 2007 @ 03:28 PDTToolsTopicLoading directly to base tables.Hi,Are there any know issues in using the utilities (fload, mload) to load data directly to base tables in Teradata? (instead of loading it to stage and then using BTEQ to load to base tables).We a...
7313 Mar 2007 @ 02:12 PDTThird Party SoftwareTopicLoading data to base tables directly using InformaticaHi,We are using Informatica to load data to Teradata. We use Loaderobject and load data using Fastload and Multiload. In all ourloads we extract the data from MSSQL databases and load the datato a ...

Pages