All forum activity

#DateUserForumTypeThreadPost
136714 Jul 2006 @ 03:02 PDTFredToolsReplyBTEQ RUN FILE Warning messagePerhaps the wording could be better, but it's just an informational message that tells you BTEQ has exhausted the .RUN file and is going to resume reading commands from stdin. You can ignore the "W...
136614 Jul 2006 @ 03:02 PDTshaik.feroz@aaa-calif.comToolsTopicRDBMS error 8018 while running fastload.All, I get this error while running the fastload.the table is locked and i had to drop and recreate the table, and I still get this error.**** 10:34:38 Number of recs/msg: 103**** 10:34:38 Starting...
136514 Jul 2006 @ 03:01 PDTdnoethToolsReplyMload on global temporary tablesYou can't load a Global Temp Table using MLoad.A temporary session is always session local and MLoad logs on 2 SQL session for control and several MLoad sessions. But why do you even think about lo...
136414 Jul 2006 @ 02:55 PDTFredDatabaseReplyDelete first record in a tableThere is no "first" record in a normal table. Using SAMPLE 1 returns a single row, but there's no guarantee it will be the same row every time. If you want to delete a single row you must qualify i...
136314 Jul 2006 @ 02:32 PDTterausrToolsTopicMload on global temporary tablesHow can we do an mload on gloabal temporary tables? Will the data last only through the mload session or the parent session?
136214 Jul 2006 @ 02:13 PDTdixonDatabaseReplyoperation on current_TimstampThanks vinod, it helped me a lot.
136114 Jul 2006 @ 10:57 PDTRGlassDatabaseReplySyntax to Alter tableThanks for the response Mayhan,I guess I was misinterpreting the DDL manual.Tbob
136014 Jul 2006 @ 10:21 PDTsethiyaguDatabaseTopicRetriving distinct values from column cellHi Guru's,In my table - in a particular column the records are stored in this way, for ex: Dept_ID--------10,20,10,30,20,30,40,10,40I need to get the distinct value for this column, the output I ne...
135914 Jul 2006 @ 09:30 PDTAnomalyConnectivityTopic.NET Provider TdConnectionStringBuilder helpI am having problems getting the TdConnectionStringBuilder in the .NET Data Provider to work.Here is my code that does not work:TdConnectionStringBuilder stringBuilder = new TdConnectionStringBuild...
135814 Jul 2006 @ 07:39 PDTBarry-1604DatabaseReplySP Out Parameter valueIn your ODBC settings, there a an option called "Return Output Parameters As ResultSet". Make sure that option is checked. Then, you can call the stored procedure in SQL Assistant and the output ...
135714 Jul 2006 @ 07:36 PDTBarry-1604DatabaseReplyhow to create function with parametersThere is an Orange Book available on Teradata's web site that explains this process in detail. It is called "Teradata Database User Defined Function User’s Guide V2R6". It is written by Mike Wa...
135614 Jul 2006 @ 06:37 PDTragavTrainingReplyTeradata Certification Books for SaleHi TintinDo you have any coffingdw certification books for Administrator or DesignArchitect or Developer or physical implementation.If yes please contact me with the amount.i am intrested in buying...
135514 Jul 2006 @ 05:42 PDTsethiyaguDatabaseTopicDelete first record in a tableHi Teradata Guru's,Is there any way to delete the first record in a table, by using delete statement & we should not use any column name.To be more specific:====================select * from table ...
135414 Jul 2006 @ 03:22 PDTmahyanDatabaseReplySyntax to Alter tableHi Tbob,I don't think we can directly alter a column from smallint to integer.If tried , it gives this error -3558: Can not alter the specified attributes.The Explaination of this error says -Most ...
135314 Jul 2006 @ 02:51 PDTmahyanThird Party SoftwareReplyIssue using Informatica to load Teradata tables.Hi Feroz,To load 100K records, I would suggest to use fastload / mload utilities from teradata, instead of using an ODBC connection.In workflow manager, you would need to define a "Loader" connecti...
135214 Jul 2006 @ 02:32 PDTvinod_sugurDatabaseReplyoperation on current_TimstampHi,select ((CAST('2006-07-12 00:00:00' AS TIMESTAMP(0) FORMAT 'YYYY-MM-DDBHH:MI:SSBZ')) - (CURRENT_TIMESTAMP(0))) DAY(2) TO SECOND;We can't directly subtract two timestamp if we need difference we ...
135114 Jul 2006 @ 01:46 PDTNitsDatabaseTopicSP Out Parameter valueHi, I have created a SP with one OUT parameter. Please tell me how to call this SP in order to test and see the value of the OUT parameter in output screen.Please suggest inputs or code snipsets.R...
135014 Jul 2006 @ 01:44 PDTNitsDatabaseReplyhow to create function with parametersBarry,What I have found is that the function code has to be written in language C and then called in Teradata by declaring the same implementation in Teradata. Even then, I am clueless how to do th...
134913 Jul 2006 @ 02:02 PDTdixonDatabaseTopicoperation on current_TimstampHow to substract an hardcoded value from current_Timestamp. i am giving the following queries but it is throwing an error saying "5407 Invalid operation on ANSI Datetime or interval value"i tried w...
134813 Jul 2006 @ 12:50 PDTZackHoweThird Party SoftwareReplyIssue using Informatica to load Teradata tables.It has been a while since I did informatic, but you set up a Teradata loader as a "writer" in the session tool.you then set your target to file instead of database, and choose your teradata writer....
134713 Jul 2006 @ 12:23 PDTRGlassDatabaseTopicSyntax to Alter tableWhat's the syntax to alter table:col(smallint) needs to be changed to integer..Tbob
134613 Jul 2006 @ 10:54 PDTSantiago LuzToolsTopicBTEQ RUN FILE Warning messageI'm trying to use "RUN FILE" command in a BTEQ to call a LOGON script, but I always get a Warning message (*** Warning: EOF on INPUT stream.).The BTEQ code is simple (teste_conexao_bteq.bteq):.RUN ...
134513 Jul 2006 @ 09:49 PDTBarry-1604DatabaseReplyhow to create function with parametersThere are good examples of UDF's on Teradata's web site. I would take a look at those.
134413 Jul 2006 @ 09:48 PDTBarry-1604ToolsReplyAccess module error while running MLOADWhen I look at "book.txt", it looks like it doesn't have an end-of-line (carriage-return/line-feed) at the end of the first record. I don't know if this would cause the problem or not, but maybe t...
134313 Jul 2006 @ 09:43 PDTBarry-1604DatabaseReplydifference between Hash join and Merge joinThe difference between the hash join and the product join is what is done with the small table. In the product join, the small table is scanned for each row in the large table. In the hash join, t...

Pages