#DateForumTypeThreadPost
2504 Aug 2009 @ 03:57 PDTDatabaseReplyIgnoring duplicated rows and keep inserting.Hi Dieter.I'm performing this insert batch in Teradata SQL Assintant.To invoke this, i've programmed a routine in C#(.NET).When the dup row happens, it stops and throwns an error and doesn't contin...
2404 Aug 2009 @ 01:40 PDTDatabaseTopicIgnoring duplicated rows and keep inserting.Hi guys!I wanna know if what I wish is possible:I'm inserting in Teradata these rows at the same time:INSERT INTO TABLE1(FILED1, FILED2) VALUES('Field1' ,0);INSERT INTO TABLE1(FILED1, FILED2) VALUE...
2324 Jul 2009 @ 10:07 PDTDatabaseTopicTeradata Error: [3704] '' ('0A'X) is not a valid Teradata SQL token.Hi guys!I'm facing this problem(I've programmed it in C#/.NET):Performing this part of code:adaptador.InsertCommand = command;command.UpdatedRowSource = UpdateRowSource.None;adaptador.UpdateBatchSi...
2221 Jul 2009 @ 09:44 PDTToolsTopicUpdating from .Net Provider 12.00.00.00 to .Net Provider 13.00.00.01Hi guys!I need you use a newer .Net Data Provider to Teradata(13.00.00.01).I've installed these items:* Teradata .NET Data Provider 13.0.0.1 Installer* README * Teradata .NET Data Provider 13.0.0.1...
2108 Jul 2009 @ 02:04 PDTDatabaseReplyStored ProcedureThank you so much for the answer!Could solve my some doubts I got?- Could you tell me which path Teradata enviroment variables do you have?- Which *.EXE should I run? CL.EXE or PCL.EXE?- Could writ...
2008 Jul 2009 @ 01:18 PDTDatabaseReplyStored ProcedureI've got the same problem when I was creating a stored procedure in Teradata SQL Assistant.What can I do to solve this problem?Thanks,Anderson
1908 Jul 2009 @ 10:40 PDTDatabaseReplyProblems when I'm creating a stored procedureI got access but now I got another error:"5863: Problem encountered during compilation phase of C code."What should I have to resolve this?Thanks,Anderson
1808 Jul 2009 @ 09:31 PDTDatabaseTopicProblems when I'm creating a stored procedureHi guys!When I'm trying to create a stored procedure into, Teradata SQL Assistant, I receive this message error:"SPL1040:E(L6), Invalid definition for stored procedure 'E(3524): The user does not h...
1706 Jul 2009 @ 09:20 PDTDatabaseReplyInsufficient memory when I perform a commandHi guys!Thanks for help me!I got the same problem (Insufficient memory) referencing my 5000 inserts to the DataAdpter's property InsertCommand.This is sheet of the programming:DataSet dataSet = new...
1602 Jul 2009 @ 10:57 PDTDatabaseTopicInsufficient memory when I perform a commandHi guys!I'm facing the following problem:I need to run at about 5000 INSERT commands at the same time.I programmed it in C#/.Net:command.CommandText = strInserts;command.ExecuteNonQuery();Into the ...
1529 Jun 2009 @ 08:26 PDTDatabaseReplySELECT as a field into an INSERTVery interesting this another form.Thank you so much!!!Anderson
1426 Jun 2009 @ 01:20 PDTDatabaseReplySELECT as a field into an INSERTThank you so much Jim!!Kind Regards,Anderson
1326 Jun 2009 @ 10:21 PDTDatabaseTopicSELECT as a field into an INSERTHi guys!I can't run this query:INSERT INTO TABLE1 (ID, FIELD1,FIELD2)VALUES(SELECT MAX(ID) + 1 FROM TABLE2, 'Name', '001');What can I do to fix and run this query?Thanks for help,Anderson
1205 Jun 2009 @ 06:39 PDTDatabaseTopicHow to fix [3932] Only an ET or null statement is legal after a DDL Statement?Hi guys!What can I do to fix this error when I perform this query:SELECTTBLA.AL,TBLA.DSC,TBLA.LIG,TBLR.IND,TBLR.NIV,TBLR.SENT_NIV,TBLA.CDRO,TBLCR.NM_RO,TBLCR.PC1,TBLCR.PC2,TBLA.CDCS,TBLCS.NMFROMTBL...
1128 Apr 2009 @ 11:15 PDTToolsReplyMload Script ErrorIt really runs man!!Thank you so much for help!!
1027 Apr 2009 @ 03:54 PDTToolsTopicMload Script ErrorHi guys!I´m having a problem with my Mload script:------------------------------------------------------.LOGTABLE mydatabase.logtable;.LOGON ;DATABASE mydatabase;CREATE TABLE mydatabase.MYTABLE ...
923 Apr 2009 @ 04:06 PDTUDAReplyBULK INSERT in TeradataHi Dieter!The number of rows are, at about, 200.000.The layout of the input file is the same of this below BULK INSERT command:BULK INSERT TBLCDR FROM '\\computer2\somefile.xxx' WITH (FIELDTERMINAT...
822 Apr 2009 @ 02:22 PDTUDATopicBULK INSERT in TeradataHi guys!Is there a command that performs a similar function as BULK INSERT(SQL statement) in Teradata?Thanks for help,Anderson
713 Apr 2009 @ 10:15 PDTUDATopicCONVERT and DATEDIFF in TeradataHi!I want to know how can I use these commands (from SQL Server) in Teradata because i need to obtain the similar functionality: and .For example:SELECT FIELD FROM TABLE1 WHERE (DATEDIFF(ss,(SELECT...
613 Apr 2009 @ 07:57 PDTDatabaseReplyCONVERT and DATEDIFF in TeradataPlease, somebody knows how to resolve this problem?I didn`t find any solution. :(Thanks for help!
509 Apr 2009 @ 11:04 PDTDatabaseTopicCONVERT and DATEDIFF in TeradataHi!I want to know how can I use these commands (from SQL Server) in Teradata because i need to obtain the similar functionality: and .For example:SELECT FIELD FROM TABLE1 WHERE (DATEDIFF(ss,(SELEC...
406 Apr 2009 @ 08:29 PDTDatabaseReplyHow can I use a reserved keyword as a common field?Thank you so much for help!
303 Apr 2009 @ 04:13 PDTDatabaseTopicHow can I use a reserved keyword as a common field?Hi!I have one table that has a filed called "" and RELEASE is reserved keyword.That is my query:SELECT , FIELD1 FROM TABLE1 ORDER BY It doesn't function so How can I use a reseved keyword as a comm...
203 Apr 2009 @ 04:07 PDTDatabaseReplyProblems with "WITH(NOLOCK"Thank you so much for the answer!
103 Apr 2009 @ 11:19 PDTDatabaseTopicProblems with "WITH(NOLOCK"Hi!I'm trying to perform a query like this:SELECT FIELD FROM SOME_TABLE WITH(NOLOCK) WHERE FILD > 0;But it returns this error:"5628: Column NOLOCK not found in MY_DATABASE."What can I do to per...