Pages
![]() |
Can anyone please help?
14 Aug 2016
| 2 comments
,
|
![]() |
Hi, *** CLI error: MTDP: EM_GSSINITFAIL(235): call to gss_init failed. [terasso]Cannot load TDGSS library. The TDGSS Library currently has initialization in progress already
25 Jul 2016
| 2 comments
,
|
![]() |
I work for a bit company with a lot of Business Objects users. One of our most popular universes points to a Teradata environment. This universe is by far our best BI resource. It has a ton of data and it delivers it to the users lightning fast.
18 Jul 2016
| 4 comments
,
|
![]() |
Any assistance would be welcomed. I cannot seem to put the Interval in a format that Teradata likes. The column data looks like "00 02:00:00.000000". We are extracting it from ORacle and loading to Teradata version 15.10. I am able to load most other data types no problem, but I cannot find the format needed to make this happy.
28 Jun 2016
| 4 comments
,
|
![]() |
Hi all,
28 Jun 2016
| 1 comment
,
|
![]() |
Hi, i have a bteq which uses repeat function to load a file into a table. we have a parameter for the input file. if the parameter is not available, the script is failing with a Return code 0, inspite of using the label to exit if errorcode <>0.
21 Jun 2016
| 2 comments
,
|
![]() |
|
![]() |
Using tdwallet version 15.10.00.02
17 May 2016
| 1 comment
,
|
![]() |
Good afternoon. I'm trying to export the query result below by BTEQ. I am using the following script.
SELECT DATABASENAME AS "Banco de Dados" ,SUM(CURRENTPERM) AS "Ocupado" ,(MAX(CURRENTPERM) * 72) AS "Ocupado_comskew" ,SUM(MAXPERM) AS "Alocado" ,Alocado - Ocupado AS "Disponível"
26 Apr 2016
| 2 comments
,
|
![]() |
Hi All,
26 Feb 2016
| 1 comment
,
|
![]() |
05 Feb 2016
| 3 comments
,
|
![]() |
I have a 430 Lines of Stored procedure in a SQL file.
25 Jan 2016
| 2 comments
,
|
![]() |
I have scoured the downloads section and am unable to find the installer for the Teradata Tools and Utilities 15.10 for OS X. I know it existed at some point, as I have bteq working on a MacBook Pro, I'm trying to migrate a bteq process to an iMac.
13 Jan 2016
| 1 comment
,
|
![]() |
I created a file test_it.bat and test_it.txt, when I call test_it.bat from a command prompt the BTEQ script keeps stopping and asking to enter logon info and I have the logon command specified in the test_it.txt file:
13 Dec 2015
| 2 comments
,
|
![]() |
Hello All,
13 Nov 2015
| 5 comments
,
|
![]() |
Hi,
13 Oct 2015
| 2 comments
,
|
![]() |
Hi...
29 Sep 2015
| 2 comments
,
|
![]() |
Hello All,
I am doing a simple Select Insert through a Bteq job like below. The count is huge around 500 millions.
14 Sep 2015
,
|
![]() |
This warning was returned in BTEQ after executing the following query. Is there something missing with the syntax? Please note that the
24 Aug 2015
| 4 comments
,
|
![]() |
Hi,
21 Jul 2015
| 1 comment
,
|
![]() |
Hi ,
09 Jul 2015
| 16 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 have bteq .RUN command sandwiched by .OS calls which log the start and end date times of the .RUN. The dates are gotten by calls to UNIX 'date' command. The START date is fine, however, my COMPLETED date is always equal to my START date. I don't see how that's possible because the 'date' command is invoked fresh on the COMPLETED line.
01 Apr 2015
,
|
![]() |
Has anybody out there in the Teradata community tried creating a custom build system in Sublime Text (i.e. this guy did it for psql - https://www.youtube.com/watch?v=tPd4m3PLVqU)? If so, would you mind sharing your build-system code as an example? Thanks in advance!
03 Mar 2015
| 2 comments
,
|
![]() |
Need to load from Table 1 to Table 2. Which utility work well here and WHY?
27 Jan 2015
| 3 comments
,
|
![]() |
Hi,
25 Jan 2015
| 5 comments
,
|
![]() |
Hi,
21 Jan 2015
| 2 comments
,
|
![]() |
|
![]() |
Is there any BTEQ command which can be used to generate explain plan whenever I provide sql to it.
26 Dec 2014
| 3 comments
,
|
![]() |
hello, .IMPORT VARTEXT ';' LOBCOLS=1 FILE=GIS_SAMPLE.txt; .QUIET ON .REPEAT * USING( OBJECTID VARCHAR (100),
03 Dec 2014
,
|
![]() |
Hello All..
20 Nov 2014
| 8 comments
,
|
![]() |
Hello,
20 Nov 2014
,
|
![]() |
Here is the query I am running:
03 Sep 2014
| 2 comments
,
|
![]() |
Hi All,
02 Sep 2014
| 4 comments
,
|
![]() |
Hi All,
27 Aug 2014
| 6 comments
,
|
![]() |
Hi Guys,
25 Jul 2014
| 1 comment
,
|
![]() |
Hi,
25 Jun 2014
| 2 comments
,
|
![]() |
Hi ,
18 Jun 2014
| 3 comments
,
|
![]() |
Hello All,
15 May 2014
| 3 comments
,
|
![]() |
Hi all,
.EXPORT FILE=out.txt select col1, col2
14 Apr 2014
| 1 comment
,
|
![]() |
Hi ,
10 Apr 2014
| 2 comments
,
|
![]() |
Hi All,
28 Mar 2014
| 3 comments
,
|
![]() |
Hi All,
24 Mar 2014
| 1 comment
,
|
![]() |
Hello there,
18 Mar 2014
| 3 comments
,
|
![]() |
|
![]() |
Hi table abc
C_Name ID xxxxx 1 yyyy 1 aaaaa 2 bbbbb 2
09 Mar 2014
| 1 comment
,
|
![]() |
Hi,
03 Mar 2014
| 1 comment
,
|
![]() |
I am executing bteqs from command prompt.
24 Feb 2014
| 2 comments
,
|
![]() |
Hi All
17 Feb 2014
,
|
![]() |
Hi , I am in badly need of some direction here :) there is an batch file(.bat) which runs an teredata query on windows, but for some reasons i will have to use Linux server from now on current set up **test.bat***
echo off bteq < D:\commands.txt > D:\output.txt 2>&1
11 Feb 2014
| 2 comments
,
|