0 - 10 of 10 tags for #BTEQ

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. 
 
Here is my script :

/opt/teradata/client/15.10/bin/bteq <<EOI

.LOGON hostname/username,password;

.EXPORT REPORT  FILE = sample_table.csv

.SET RECORDMODE OFF

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.

Hi ,
I am not strong on BTEQ and I need help on what can be achieved with ‘.Error’.

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.

Hi,
I have a simple stored procedure which returns CLOB value. I am calling the procedure from BTEQ and then exporting that value in a file.
Now the problem is that BTEQ is truncating the value from the end. I have used also used SET WIDTH but no luck. Following is my BTEQ code:

####################################
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:

HI ,
Could someone hep in creating BTEQ Scripts in LINUX Operating system(NOT in UNIX). can we execute BTEQ script in LINUX or is their any issue while running in LINUX environment.
 
Help me creating .RUN file, if servername/username,password --> are credentials.
select * from dbc.tables-->is select statement

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.
The SQL statement runs fine in TERADATA SQL assistant, but
whe I run this sql statement through a BTEQ on mainframe

 

Hi, Can you please tell me if TTU is available for MAC ? My requirement is to run BTEQ from terminal.app. 
Thanks in advance for your help.

Hi!
I have created a SQL-statement that is in a string.
Ex:
'insert into MetadataTable.TestTable ' !!
'sel ''' !! trim(substr(Col.databasename,1,3)) !! ''' as Environment, ''' !!

trim(T1322.Id) !! ''' as Id, ''' !!

trim(T1324.RId) !! ''' as RId, ''' !!