All forum activity

#DateUserForumTypeThreadPost
151702 Aug 2006 @ 03:30 PDTkuldeepsinghAnalyticsTopicFailure 7453 Interval field overflowI have a teradata procedure -- Cheking that FULFILLMENT_LINE has finished updatingsel ((Current_Timestamp - Process_Timestamp) hour(2) to second(6)) TIMEPROCfrom EDWPROD.ETL_Control_Table WHERE ...
151602 Aug 2006 @ 12:57 PDTilyasUDATopicOLE load from Oracle to tearadataNew to tearadata. Is there any good tutorial for OLE load from oracle to teradta. I will appreciate help. thanks
151502 Aug 2006 @ 12:56 PDTkathykUDAReplyConvert from SAS to SQLI haven't used it but I believe that Teradata Model Manager will allow you to import models that are in PMML (Predictive Model Markup Language.) I believe SAS will allow you to output SAS code as ...
151402 Aug 2006 @ 11:12 PDTNytewyndDatabaseReplyceil function in oracle!That is close, but it adds 1 to numbers that are already integers. If you pass in 2, you should get 2 back. I changed it so it checks to see if NUM is already the equivalent of it's integer value...
151302 Aug 2006 @ 07:57 PDTrgans_99ToolsTopicLoading UTF8 data using MloadHi,We tried to load data in UTF-8 format with tab as delimiter using Mload. But it is moving to ET tables and the errorcode is '6705'.here is the sample UTF8 data(with tab delimiter):63 ÌÊ33 Ä/2...
151202 Aug 2006 @ 05:35 PDTSantosh Kumar MishraToolsTopicMultiple Nullif checks for a field in FastloadHi All,I want to convert a Mload script to Fastload for the purpose of performance improvement. One problem which I am facing is that I am not able to do a "Multiple Nullif checks for a field in Fa...
151102 Aug 2006 @ 12:58 PDTvinod_sugurDatabaseReplyceil function in oracle!There is no ceil function in teradata but the results can be achieved easily by the below query:select CASE WHEN NUM > 0 THEN CAST(NUM AS INTEGER) +1 ...
151001 Aug 2006 @ 11:54 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachAm bit curious to know, if anyone else is struck with the same problem
150901 Aug 2006 @ 11:53 PDTnithyanandamDatabaseReply10065 WSA E HostUnreachpdestate -a shows that the logons are enabled.
150801 Aug 2006 @ 10:52 PDTn4247558DatabaseTopicceil function in oracle!Any function in teradata is equal to the "ceil" function in oracle?*Reference:In Oracle/PLSQL, the ceil function returns the smallest integer value that is greater than or equal to a number.The syn...
150701 Aug 2006 @ 10:47 PDTterausrDatabaseTopicSpool Space IssuesI am getting Spool space error when this query run in PROD. Any optimization tips welcome. I have put the records in Millions and Indexes on comments.INSERT INTO extrt_ent_drcty_data_3_gt(28 Cols)S...
150601 Aug 2006 @ 10:31 PDTrgans_99ToolsReplyTab Delimited Flat file and MloadHi,It works with '09'XC in Unix too.The problem was due to the tool which I had used to generate the test flat file.Thanks,
150501 Aug 2006 @ 12:39 PDTstami27-2406AnalyticsReplyReplace( ) & Ascii Characters:CHR( ) in TeradataHi TD_USERAbout the Ascii characters included in string operations in Teradata:as in Oracle CHR(10), you can use in teradata the hexa equivalent(i.e. '0A'XC)or for CHR(09) '09'XC or for CHR(13) '1C...
150401 Aug 2006 @ 04:32 PDTterasumanDatabaseTopicReplace( ) & Ascii Characters:CHR( ) in TeradataHi All,Is there any function available in Teradata to replace a string with another one? Also how are the Ascii characters included in string operations in Teradata like in the following Oracle-SQL...
150301 Aug 2006 @ 04:26 PDTrgans_99ToolsTopicTab Delimited Flat file and MloadHi all,My requirement is to insert the data from a TAB delimited flat file using Multiload Job script.I used the following in the Mload:.IMPORT INFILE customers.dat FORMAT VARTEXT '09'XC LAYOUT new...
150201 Aug 2006 @ 04:17 PDTterasumanAnalyticsTopicReplace( ) & Ascii Characters:CHR( ) in TeradataHi All,Is there any function available in Teradata to replace a string with another one? Also how are the Ascii characters included in string operations in Teradata like in the following Oracle-SQL...
150101 Aug 2006 @ 02:18 PDTvinod_sugurDatabaseReplyTop FunctionThere is an Top function in V2R6, but if you want to try out in V2R5 you need to go by analytical function.Select *From vinod_1Qualify Row_number() OVER(Order by empno)
150001 Aug 2006 @ 01:27 PDTOz_TaxUDATopicConvert from SAS to SQLWe have numerous models developed in SAS Enterprise miner.We are looking to convert the scoring code from SAS code to SQL, so it can be used in the Teradata environment.Does anyone know of any auto...
149931 Jul 2006 @ 04:04 PDTMattW At ATTDatabaseTopicTop FunctionIs there an equivilant to the Top function in Teradata?MS syntax select top 5 * from TABLEX order by 1
149831 Jul 2006 @ 12:26 PDTonboardDatabaseTopicDatatype mapping rules for Sybase to TeradataI am doing an ETL to extract from Sybase and load to Teradata. There are some datatype difference between these two databases. Is there anybody knows what's the rule for the datatype mapping from S...
149731 Jul 2006 @ 12:00 PDTsunstarprasadTrainingReplyNR-011 CertificationHi I am interested in taking the Teradata NR0-011, NR0-012, 13 cert exams, I would be greatful if anyone could suggest me some books or trainning material for the exams.Plz mail me at sunstarpras...
149631 Jul 2006 @ 09:31 PDTvictor4techDatabaseReplyHow to subtract time from a timetamp fieldThanks very much for your reply. It is working properly
149529 Jul 2006 @ 04:41 PDTTeraDataMachoManToolsTopicStatistics WizardWhile I am trying to connect Statistics Wizard 1.2, the following error received and unable to connect;"Unable to retrieve the database release , logging off the database"Teredata Version :VERSION ...
149428 Jul 2006 @ 02:28 PDTdnoethDatabaseReplyUnion All problemHi John,SQL Reference: Functions and OperatorsChapter 5: Set OperatorsAttributes of a Set Result"The data type, title, and format clauses contained in the first SELECT statement determine thedata t...
149328 Jul 2006 @ 02:07 PDTjporellDatabaseTopicUnion All problemCan anyone explain the following odd results?When I execute the following query:select 'x' ,count(*) from dbc.databasesunion allselect 'x1' ,count(*) from dbc.databasesI get the following results:x...

Pages