#DateForumTypeThreadPost
2227 Jun 2014 @ 08:18 PDTToolsReplyFastload I/O error 42 on flat fileFor the benefit of someone else having difficulty, this script finally worked:   LOGON server/uid,password; DATABASE TEST_LAND ;   DROP TABLE Client_Holiday; DROP TAB...
2127 Jun 2014 @ 08:13 PDTToolsReplyFastload I/O error 42 on flat fileI just noticed a syntax error on the line: IsForcedIntoModel (VARCHAR(2), I am still having a problem, but I will trace a bit longer and get back here if I am stuck again...
2027 Jun 2014 @ 08:00 PDTToolsReplyFastload I/O error 42 on flat file Hi Dieter,   Thank you for your feedback. I have set it as you recommended and I am getting close. There is a new error that I don't know how to deal with.... Expected NULL...
1926 Jun 2014 @ 09:14 PDTToolsReplyFastload I/O error 42 on flat fileI have also changed the flat file data to: 1,Christmas,1,7,0,0,1,1   312C4368726973746D61732C312C372C 302C302C312C310D0A  
1826 Jun 2014 @ 08:55 PDTToolsTopicFastload I/O error 42 on flat fileHello,   I read all the other comments on similar problems, but I still cannot resolve my issue. I am trying to load a single line of a csv file into a simple table. Below is the fast load s...
1701 Apr 2014 @ 12:40 PDTDatabaseReplyCALLing a dynamically created SP name.Thank you for your suggestions. I will need to figure out a different approach. The suggestion from YouriD did not work unfortunately. The following was suggested as another way in BTEQ: BTEQ...
1628 Mar 2014 @ 08:01 PDTDatabaseTopicCALLing a dynamically created SP name.Hi , I have a situation where I need to execute a series of "manufactured" SP names in a loop. This is the scenario: From my LANDING database I need to ETL a series of tables to the WA...
1525 Mar 2014 @ 09:45 PDTDatabaseReplyerror when CALLing Teradata SP from C#Hi Raja, Thank you for the feedback. I got it to work in Teradata Studio, but it will not work in SQL Assistant using the same ODBC settings ...??? Another question please: How do I get the que...
1424 Mar 2014 @ 01:51 PDTDatabaseTopicerror when CALLing Teradata SP from C#Hi, I have this code which I am using as a test mostly borrowed from existing examples. However, in my case I keep getting the error: System.Data.Odbc.OdbcException: ERROR [HY000] [Teradata][O...
1304 Mar 2014 @ 09:23 PSTGeneralReplyGet the Stored Procedure name currently executingHello, Thank you for your feedback. That is "plan B". There could be 100's of SPs, so the idea is to use a generic command that would retrieve the name of the SP when it is executed...
1203 Mar 2014 @ 04:34 PSTGeneralReplyGet the Stored Procedure name currently executingHi, Thank you for your response. However, my question is how can I obtain the SP name within a SQL stored procedure with a sql statement of some sort, so I can log the start/end, error etc... of t...
1103 Mar 2014 @ 12:07 PSTGeneralTopicGet the Stored Procedure name currently executingHello,   I need to identify the current stored procedure to update a Log table. In MSSQL I would be using the following command: SET @vProcName = OBJECT_NAME(@@PROCID) ; Is there an equiv...
1021 Jan 2014 @ 02:22 PSTToolsReplyTPT load script fails with incompatible messageSudhansu, Thank you very much for your help and advice. It is greatly appreciated !!!... I will follow up on your suggestion.    
916 Jan 2014 @ 11:52 PSTToolsReplyTPT load script fails with incompatible messageHi, Thank you again for your time in looking into this for me. It is greatly appreciated !... Below is the result of the tlogview command as requested:   C:\Program Files\Teradata\Cl...
815 Jan 2014 @ 10:23 PSTToolsReplyTPT load script fails with incompatible messageHello,   I am now considering using MLOAD to import data directly from MSSQL to Teradata. Can MLOAD be used to run a Select statement from MSSQL to import directly to a Teradata tabl...
714 Jan 2014 @ 11:12 PSTToolsReplyTPT load script fails with incompatible messageHi,   Thank you for your feedback. I have also tried to exclude the "Name" column as it seems like it is a reserved word for Teradata ?... but it still gives me the following error...
614 Jan 2014 @ 08:48 PSTToolsReplyTPT load script fails with incompatible messageHi, Thank you for your assistance with this... Using the Teradata Parallel Transporter wizard (instead of the OLELoad) , I have tried both MSSQL ODBC and DataDirect ODBC 32 bits. 64 bits gives me...
510 Jan 2014 @ 02:30 PSTToolsReplyTPT load script fails with incompatible messageHi Sudhansu, I desperately need your help with this. I am new to TPT so I am not sure what to do here. Your assistance is greatly appreciated. Below are the result lines from running the TPT scri...
409 Jan 2014 @ 02:12 PSTToolsReplyTeradata Parallel Transporter (TPT) wizard error TPT19003, TPT19008, TPT19119,TPT19003Hello all, Has anyone got an answer to this please ?... I am having the same problem, but importing from MSSQL. The Fastload wizard script works perfectly, but the TPT load script gives the follo...
309 Dec 2013 @ 11:16 PSTToolsTopicTTU for LinuxHi,   I have downloaded the Teradata Express VM which runs on Linux. I am trying to get the TTU package for it but I cannot locate it. On the download page all I can see is the following: T...
227 Nov 2013 @ 08:55 PSTToolsTopicTPT load script fails with incompatible messageHi, Your advice with the following will be greatly appreciated. I am using the TTU 14.10 set of tools with a Teradata DB 14.0.2.11 With the OLELoad tool, The Fastload utility works perfectly but...
124 Sep 2013 @ 02:44 PDTTeradata StudioTopicConnect to the VM Teradata sample. TDExpress14.0.3_Sles10: ?Hi,   How do I connect to the sample Teradata DB in the VM of Teradata Express ?... From BTEQ at the command line it connects and I can run simple SQL as in the example. I am not sure what ...