Questions tagged [bteq]
The bteq tag has no usage guidance.
bteq
21
questions
0
votes
0
answers
11
views
Continue on Error in Automic JobStep after script call with non-zero return code
I do have an automic job step which calls a BTEQ script (but just think of any kind of script which return an error code). Something like:
BTEQ "filename"
Now I want to introduce some ...
0
votes
0
answers
21
views
Autosys Command Job is not triggering Teradata BTEQ script
I have autosys job with below JIL configuration
insert_job: APP.C
command : /NAS_MOUNT/run_bteq.ksh FOLDERNAME SCRIPTNAME.btq
machine : serverA.com
owner : John
profile: /NAS_MOUNT/.John_profile
If I ...
0
votes
0
answers
47
views
Failure 2673 The source parcel length does not match data that was defined
Hi I am trying to import data into one of the tables using BTEQ import.i am using the following script to load data to flat file
I am exporting a file from oracle and importing them into Teradata ...
0
votes
1
answer
225
views
CSV export using Teradata BTEQ cuts off column and inserts dashed line
I am recently trying to learn how to use Teradata's BTEQ utility. For starters, I would like to select a few rows and export them to a CSV. This is my code:
.LOGMECH KRB5;
.LOGON server/user;
.EXPORT ...
0
votes
0
answers
52
views
Teradata and SQL Server : how to get hierarchy
In Teradata/SQL Server, how to get by SQL/BTEQ the hierarchical top parent?
Head teacher is minimum id among all the teacher of the student.
if student 10 has 3 teachers 1,8,9; teacher (id) 8 & 9 ...
0
votes
0
answers
77
views
Space between each character in Teradata mLoad target table
I am loading a flat file into Teradata target table.
Example flat file:
Employee_ID, Employee_First_Name, Employee_Salary
1,Jay,50000
2,Sam,60000
3,Tom,70000
The result of the mload looks as such in ...
0
votes
1
answer
163
views
Teradata BTEQ to export results with its corresponding SQL
I'm new to teradata BTEQ concepts. I was trying to run SQLs from file using BTEQ:
.logon/usr,PWD
.set width 300
.export report file=output.log
.run = sqlfile
.export reset
.logoff
.quit
In above BTEQ,...
0
votes
1
answer
131
views
Teradata comparison between 2 variables inside BTEQ and choose an outcome
I need help to compare 2 variables inside Teradata BTEQ script and take a decision based on the outcome. I tried something like below:
CREATE VOLATILE TABLE VT_JRNL_MAX_SNAPSHOT_DT,NO LOG,NO FALLBACK
...
0
votes
0
answers
173
views
Teradata BTEQ - Can't find, access or install it
Does Teradata Vantage and Teradata SQL Assistant come with BTEQ? If yes, how do I access it? If no, how do I install it?
Thanks.
0
votes
1
answer
326
views
Teradata BTEQ: disable logon prompt
When i run a teradata bteq in the CMD shell -
A little logon prompt screen pops up.
When i press enter the bteq runs.
Is there a way to disable this popup screen?
Searching the internet yields that ...
0
votes
0
answers
467
views
Bteq if then condition
I have a Bteq script file which contain multiple queries like below:
Bteq
Quer1;
Quer2_a;
Quer2_b;
Quer3;
Quer4;
.if errorcode <> 0 then .goto end_err
.label end_ok
.quit 0
.label end_err
....
0
votes
0
answers
428
views
Export column value from teradata as separate .txt files
im trying to write a code to export data present in column "task detail", and its export file name should be the same rows " task name " value
eg:
Task Detail task name
task ...
0
votes
0
answers
227
views
how can i download 200+ millions records from teradata using bteq?
Using below statement I am able to download 1 million records. But not getting how can i download 200+ millions records from the teradata table into pipe separated text file.
Below is the code that I ...
0
votes
1
answer
1k
views
Teradata BTEQ Whitespace at end of every column
I am exporting to a text file from BTEQ and I am getting whitespace padding to the maximum length of each of my columns in my output text file. For example I just want customer_name and post_code ...
0
votes
1
answer
251
views
SET SESSION DATEFORM = ANSIDATE doesn't seem to be working in BTEQ
This is the BTEQ call I'm using:
.EXPORT REPORT FILE = OUTPUT_FILE;
SET SESSION DATEFORM = ANSIDATE;
SELECT * FROM TABLE_NAME
;
Dates keep coming up as IntegerDates YY/MM/DD
Teradata 16.xx. Is this ...