![]() |
I am fairly new to Teradata. I have been struggling to get exact format for all the dates in my select query when doing an export using BTEQ. /opt/teradata/client/15.10/bin/bteq <<EOI .LOGON hostname/username,password; .EXPORT REPORT FILE = sample_table.csv .SET RECORDMODE OFF
17 Aug 2016
| 3 comments
,
|
![]() |
Hi,
In my BTEQ statement, I'm selecting two columns of a table and I'm exporting the output to local file. When I check that file only one column is present. I even tried giving the maximum value for .set width option (65531). It was not working. Please help me on this.
Thanks in advance, Sanjay.
23 May 2016
,
|
![]() |
Hi ,
29 Mar 2016
| 1 comment
,
|
![]() |
Hello, Very basically, I have a BTEQ file that is 61,580 bytes. After running in circles for a short while, I have found that any BTEQ up to and including 61,440 bytes runs no problem, whilst anything over that just hangs indefinitely. Of course a simple fix is to reduce the file size ever so slightly, but that is not an option.
08 Feb 2016
| 2 comments
,
|
![]() |
Hi,
05 Jan 2016
| 7 comments
,
|
![]() |
#################################### bteq <<EOF .LOGON servername/username,******** /* sql code on next line(s) */ select databasename from dbc.databases where databasename="P_EIW_S_LIS_01"; .export reset .LOGOFF ; EOF ################################### Above is the BTEQ Script:
06 Dec 2015
| 2 comments
,
|
![]() |
HI ,
04 Dec 2015
| 5 comments
,
|
![]() |
Hi I am trying to run some sql statements with regular expressions through a BTEQ and there seems to be some kind of an issue.
22 Oct 2015
| 1 comment
,
|
![]() |
Hi, Can you please tell me if TTU is available for MAC ? My requirement is to run BTEQ from terminal.app.
07 May 2015
| 8 comments
,
|
![]() |
Hi! trim(T1322.Id) !! ''' as Id, ''' !! trim(T1324.RId) !! ''' as RId, ''' !!
07 Apr 2015
| 2 comments
,
|