![]() |
This package contains the Aster client tools for MacOS.
Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where:
11 May 2017
,
|
![]() |
This package contains the Aster client tools for AIX.
Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where:
11 May 2017
,
|
![]() |
This package contains the Aster client tools for Solaris.
Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where:
11 May 2017
,
|
![]() |
This package contains the Aster client tools for Linux.
Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where:
11 May 2017
,
|
![]() |
This package contains the Aster client tools for Windows.
Release numbering for all of the above will follow this convention: XX.YY.ZZ.nn where:
11 May 2017
,
|
![]() |
Hi,
I need to export few chinese and japanese characters stored in teradata to a file.
I have tried different options to export data through TPT but i am either not able to see the unicode characters in the generated file or i face the conflicting data length error.
19 Aug 2016
| 6 comments
,
|
![]() |
Hi,
02 Aug 2016
| 2 comments
,
|
![]() |
Hello,
29 Jul 2016
| 2 comments
,
|
![]() |
|
![]() |
Hello experts,
I have a problem using import and export with bteq. I have the following simple table in DB1 and DB2:
30 Jun 2015
| 5 comments
,
|
![]() |
I'm running the latest TeradataStudio__mac_x86.15.10.00.01 on OSX 10.10 and when pulling resusage from customer site I get the data back in the results window, but then if I want to export it to disk I click on this and get the black/white ball and studio goes off into a spin for about 5 muntes then eventually comes back with nothing.
08 Jun 2015
| 10 comments
,
|
![]() |
Hi all, hadoop com.teradata.hadoop.tool.TeradataExportTool -url jdbc:teradata://testsystem/database=testdb -username testuser -password testpassword -jobtype hive -fileformat textfile
09 Mar 2015
| 2 comments
,
|
![]() |
Hi All,
04 Mar 2015
,
|
![]() |
Friends, I need to export a table between two servers, but I get the following error in trasnfer history: Starting Load... Starting Export... Copy Table Data Task Opening connection... Writing data... Data extracted successfully with Warning(s) 539133 Rows Exported
22 Nov 2014
| 11 comments
,
|
![]() |
Hello good people
21 Oct 2014
| 1 comment
,
|
![]() |
Hi all,
.EXPORT FILE=out.txt select col1, col2
14 Apr 2014
| 1 comment
,
|
![]() |
I have a CSV file that I'm attempting to load via TPT. I have created the CSV file in Excel. When I try to load the file with the appropriate number of delimiters, I am getting a BUFFERMAXSIZE error. When I add another delimiter to the end of each record, the file loads just fine.
18 Mar 2014
| 9 comments
,
|
![]() |
Hi,
10 Mar 2014
| 2 comments
,
|
![]() |
Hi All,
I have used TRIM ( BOTH FROM string_name) command to remove extra character / space coming in export file but it is not working. could you please help to resolve this issue ?
.set format on; .set width 1000; .set pagelength 100000; .set heading ''; .set footing '';
28 Feb 2014
| 1 comment
,
|
![]() |
Hi,
13 Feb 2014
| 1 comment
,
|
![]() |
I've recently begun working with Teradata Studio Express after about a year of working with SQL Assistant. My primary use of Teradata is for BI applications such as ad-hoc reporting.
16 Jan 2014
| 9 comments
,
|
![]() |
Hi,
I am trying to export the table to a data file, clear the table and use ".import data file" to import the data back in. I always got the following error if the table has a "not null" column.
*** Failure 2673 The source parcel length does not match data that was defi ned.
23 Oct 2013
,
|
![]() |
TD Geo Import/Export tool lets you translate ESRI Shape and KML files to TD format.
03 Sep 2013
,
|
![]() |
|
![]() |
Hello,
03 Jun 2013
| 3 comments
,
|
![]() |
|
![]() |
Hi,
14 Feb 2013
| 7 comments
,
|
![]() |
Hi, I am trying to export SQL output to excel file using .export DIF. I am getting SQL output but coulumn header is getting supressed. REPORT option outputs column header but output in excel is in a single row so not desirable. Anyone has idea on how to output column header using .export DIF?
04 Sep 2012
,
|
![]() |
Hi there, Can TPT be used to export ASCII data as UTF-8... ? Meaning, the data stored in the TD DB table is ASCII, but we want a flat file export that is in UTF-8 Format. Is this possible? As far as I have seen in the TPT User Guide, it appears that the character set of data and export file should be the same.
31 Jul 2012
| 2 comments
,
|
![]() |
Hi. I want to export data from one place and import it to other. Here is the source data declaration:
02 May 2012
| 2 comments
,
|
![]() |
Hi, I'm new to Teradata and need to do the following: I'm on a Unix system, using verision 13.0. We're inserting data into the "Stage" table from a delimited text file (bell is the delimeter \007) 1. export the dataparcel field from the _ET table to a file (delimited text if possible)
20 Feb 2012
| 26 comments
,
|
![]() |
If you’re waiting for an easy way to load data from one or more Teradata table(s) into a Teradata table without writing a Teradata PT script, wait no further. Teradata PT Easy Loader can do it easily. In the 14.0 release, the tool can load data from a Teradata table or from SELECT statement(s).
30 Dec 2011
| 1 comment
,
|
![]() |
Teradata FastLoad has a feature named Tenacity that allows user to specify the number of hours that FastLoad continues trying to log on when the maximum number of load operations is already running on the Teradata Database. By default the Tenacity feature is not turned on. The feature is turned on by the script command:
14 Dec 2011
| 2 comments
,
|
![]() |
Hi all, I would appreciate if some one can give the insight to this problem.
09 Dec 2011
| 4 comments
,
|
![]() |
I was trying to export DDLs for the existing tables. I wrote a bteq script as follows. Although width is set to 20000, it exports partial row. I tried to increase width size to max 60000, still I have no luck. It exported same partial rows. Can somebody point me what is wrong in this bteq? ----------------------------- .logon .export report file=cm_crt_table.sql select requesttext(title '') from DBC.TABLES where databasename='WRK_DB' and tablename like 'CM%'; .export reset .logoff .quit
28 Apr 2011
| 4 comments
,
|
![]() |
Using these settings the results of my SQL ran using Bteq is written to a file with no column headers, the only thing I can't figure out is how to get rid of the 10 spaces that are written to the export file before the results of the SQL.
31 Mar 2011
| 3 comments
,
|
![]() |
I can export some fairly large queries in SQL Assistant JAVA edition, but there appears to be a soft limit somewhere around 20 Meg where it just cuts off and creates an empty file. The results appear to be accurate, the export unwilling.
25 Aug 2010
| 1 comment
,
|
![]() |
Hi, I am using the bteq import export option,I have followed the following steps in order: Step 1 .set width 900 .export rest; Step 2 create table db.tab2 Step 3 .import data file=myoutput.txt,skip=3
17 Jul 2010
| 4 comments
,
|
![]() |
Windows 7 64-bit I am trying to export a view that contains about 3500 rows, but I am having a hard exporting the entire result set outside of what is being displayed. 1. 2.
22 Apr 2010
| 2 comments
,
|
![]() |
Hi,
28 Feb 2010
| 1 comment
,
|
![]() |
This book provides reference information about BTEQ (Basic Teradata Query), a general-purpose, command-based report and load utility tool. BTEQ provides the ability to submit SQL queries to a Teradata Database in interactive and batch user modes, then produce formatted results.
02 Feb 2010
| 1 comment
,
|
![]() |
06 Nov 2009
| 5 comments
,
|