#DateForumTypeThreadPost
6127 Oct 2015 @ 06:07 PDTToolsReplyViewpoint: Not able to access VP Portal via Google ChromePlease post this in http://forums.teradata.com/forum/viewpoint forum
6002 Jul 2015 @ 07:30 PDTToolsReplyBTEQ Import/Export of decimals does not workUse following command for exporting the data .set width 500 .set titledashes off .decimaldigits 38; .EXPORT INDICDATA DDNAME=my_table.dat select * from sud.my_table; .EXPORT RESET .logoff ...
5902 Jul 2015 @ 04:57 PDTToolsReplyFast load Errorthis is sample script for fastload. .LOGON NODEID/user,password; DROP TABLE emp_e1; DROP TABLE emp_e2; DROP TABLE emp; .SET RECORD vartext ';' ; CREATE TABLE emp, FALLBACK( ...
5802 Jul 2015 @ 04:49 PDTToolsReplyFast load ErrorRajesh, see the difference.  .logon 127.0.0.1/dbc,dbc; set vartext ","; define col1 (varchar(10)), col2 (varchar(10)), aol1 (varchar(10)) File=./root/fastloaddata1.txt;...
5730 Jun 2015 @ 12:30 PDTToolsReplyIssues during Importing pipe delimited vartext file using MLOADYou are not able to load using ".table" command because there is/are some columns that is/are not "VARCHAR" data type(s). Delimited data that are given as input with VARTEXT for...
5625 Jun 2015 @ 10:34 PDTToolsReplySelect query from Teradata to BD MS AccessI guess u can create a DSN using Access driver and connect through Teradata SQL Assistant.
5509 Oct 2014 @ 02:06 PDTToolsReplyTPT OLE DB and TPT moving to version 15"OLE DB Access Module" is productized as oledb. "OLE DB Provider" is productized as tdoledb. Why is this? May be because Access Module got released ahead of provider... May be.....
5404 Sep 2014 @ 10:59 PDTToolsReplyFastload to non-empty tableIt is the design of the product. :).  
5304 Sep 2014 @ 10:55 PDTDatabaseReplyImporting Data from .XLSYes you can do fastload/Mload importing data from Excel using OleLoad (OLE DB Access Module). check out the link https://forums.teradata.com/forum/analytics/excel-to-teradata  
5202 May 2014 @ 02:28 PDTToolsReplyFastloading csv file with double quotesFastload does not support or can ignore quoting character as part of data. The csv file while saving by different application adds additinal quotes for their application differently. I will sugges...
5118 Apr 2014 @ 02:56 PDTToolsReplyTTU Installation on Linux RedHatYou can only download products that are avaliable for public. If you are a customer and unable to find the software you are seeking, please contact your Teradata account representative who may be a...
5014 Apr 2014 @ 08:21 PDTToolsReplyFastloading csv file with double quotesIf you are using 14.00 or later, you can have fastload using following syntax: SET RECORD VARTEXT DELIMITER ';' QUOTE YES '"';  
4927 Mar 2014 @ 04:55 PDTToolsReplyData not loaded into table even the log doesn't have any error."^A" delimier used. check that "^A" is multi-character or is a multibyte single character. Keep consitant across all place i.e. in script and in data file. Which version of bte...
4819 Mar 2014 @ 04:07 PDTToolsReplyEnd of Record marker with TPTA buffer is created based on the schema, Now, record is scanned till the next delimiter and copied to the buffer. Now, considering your case where last column does not have a delimiter. When the v...
4719 Mar 2014 @ 12:53 PDTToolsReplyBTEQ exporting multiple files based on column value in a tableYou can try with two bteq scripts. Run 1st betq script and get the unique IDs exported to a file. With a shell script, read the exported file and pass value and call 2nd bteq script which export th...
4610 Mar 2014 @ 09:51 PDTToolsReplyHandle records in Mload ET table in TEXT mode - A column or character expression is larger than the max sizeTry this: .logon localtd/tduser,tduser; .export data file="G:\Users\cheeli\Desktop\bteq_op\ et_itemppi_text.txt"; select hostdata from samples.et_itemppi_wodate; .export reset; &nb...
4510 Mar 2014 @ 09:47 PDTToolsReplyFASTLOAD SCRIPT ISSUEUse NULLIF command in Fastload. Check Manual for details.
4403 Mar 2014 @ 11:19 PSTToolsReplyLoad rows of data from teradata tables to mysql tablesUse TPT (where producer is export operator and consumer is odbc operator) or Use OLE DB Access Module (OleLoad) which is WINDOWS only product with a GUI to connect and transfer data. Check out...
4303 Mar 2014 @ 10:50 PSTToolsReplyFast Export parallelismThe number of sessions requested to Database by fexp is assigned to different AMPs. If the resulted data is from a single (or limited AMP) then mostly the sessions assigned to those AMPs will be ac...
4203 Mar 2014 @ 07:55 PSTToolsReplyError in FastLoad ScriptCheck once if you are using recent version of piom (dataconnector).  
4127 Jan 2014 @ 04:18 PSTToolsReplyDBCHWAT Returns 220 and FastExport restarts CLI error 220 means  connection lost (Network or DBS problem). Explanation: The DBC/1012 connection was lost due to either a DBC/1012 or Network problem. Remedy: Change the crash op...
4021 Jan 2014 @ 03:01 PSTToolsReplyTPT load script fails with incompatible messageHi Boris, Thanks for the detailed logs. Please use 14.10.00.03 version of TPT which has the fix for this issue. You seems to be using TPT 14.10.00.02. If you cannot download the latest TPT patc...
3917 Jan 2014 @ 08:17 PSTToolsReplyTeradata Wallet and OLE DB Load Great. I am reposting because my post earlier might lead to confusion. Follow the instruction below: 1) Install Teradata wallet and keep your password in the wallet as follows:  ...
3816 Jan 2014 @ 07:51 PSTToolsReplyTPT load script fails with incompatible message Hi Boris,   With the error message, I think you have to first save the amj file by clicking File-> Save As button in OleLoad GUI menu option. Then please re-create the problem wi...
3716 Jan 2014 @ 05:51 PSTToolsReplyTeradata Wallet and OLE DB Load Yes, You can use Teradata Wallet in OLE DB Load utility.    Follow the instruction below:   1) Install Teradata wallet and keep your password in the wallet as foll...

Pages