61 | 27 Oct 2015 @ 06:07 PDT | Tools | Reply | Viewpoint: Not able to access VP Portal via Google Chrome | Please post this in http://forums.teradata.com/forum/viewpoint forum
|
60 | 02 Jul 2015 @ 07:30 PDT | Tools | Reply | BTEQ Import/Export of decimals does not work | Use 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
... |
59 | 02 Jul 2015 @ 04:57 PDT | Tools | Reply | Fast load Error | this 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(
... |
58 | 02 Jul 2015 @ 04:49 PDT | Tools | Reply | Fast load Error | Rajesh,
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;... |
57 | 30 Jun 2015 @ 12:30 PDT | Tools | Reply | Issues during Importing pipe delimited vartext file using MLOAD | You 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... |
56 | 25 Jun 2015 @ 10:34 PDT | Tools | Reply | Select query from Teradata to BD MS Access | I guess u can create a DSN using Access driver and connect through Teradata SQL Assistant.
|
55 | 09 Oct 2014 @ 02:06 PDT | Tools | Reply | TPT 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..... |
54 | 04 Sep 2014 @ 10:59 PDT | Tools | Reply | Fastload to non-empty table | It is the design of the product. :).
|
53 | 04 Sep 2014 @ 10:55 PDT | Database | Reply | Importing Data from .XLS | Yes 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
|
52 | 02 May 2014 @ 02:28 PDT | Tools | Reply | Fastloading csv file with double quotes | Fastload 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... |
51 | 18 Apr 2014 @ 02:56 PDT | Tools | Reply | TTU Installation on Linux RedHat | You 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... |
50 | 14 Apr 2014 @ 08:21 PDT | Tools | Reply | Fastloading csv file with double quotes | If you are using 14.00 or later, you can have fastload using following syntax:
SET RECORD VARTEXT DELIMITER ';' QUOTE YES '"';
|
49 | 27 Mar 2014 @ 04:55 PDT | Tools | Reply | Data 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... |
48 | 19 Mar 2014 @ 04:07 PDT | Tools | Reply | End of Record marker with TPT | A 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... |
47 | 19 Mar 2014 @ 12:53 PDT | Tools | Reply | BTEQ exporting multiple files based on column value in a table | You 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... |
46 | 10 Mar 2014 @ 09:51 PDT | Tools | Reply | Handle records in Mload ET table in TEXT mode - A column or character expression is larger than the max size | Try 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... |
45 | 10 Mar 2014 @ 09:47 PDT | Tools | Reply | FASTLOAD SCRIPT ISSUE | Use NULLIF command in Fastload. Check Manual for details.
|
44 | 03 Mar 2014 @ 11:19 PST | Tools | Reply | Load rows of data from teradata tables to mysql tables | Use 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... |
43 | 03 Mar 2014 @ 10:50 PST | Tools | Reply | Fast Export parallelism | The 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... |
42 | 03 Mar 2014 @ 07:55 PST | Tools | Reply | Error in FastLoad Script | Check once if you are using recent version of piom (dataconnector).
|
41 | 27 Jan 2014 @ 04:18 PST | Tools | Reply | DBCHWAT 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... |
40 | 21 Jan 2014 @ 03:01 PST | Tools | Reply | TPT load script fails with incompatible message | Hi 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... |
39 | 17 Jan 2014 @ 08:17 PST | Tools | Reply | Teradata 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:
 ... |
38 | 16 Jan 2014 @ 07:51 PST | Tools | Reply | TPT 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... |
37 | 16 Jan 2014 @ 05:51 PST | Tools | Reply | Teradata 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... |