“Hi experts, Can any one post sample bteq script. My requirement is to unload a table with a tera data sql query in to a file whos efileds are pipe delimited. BTEQ can be used as a Query tool, to load data a row at a time into Teradata and to export data off of Teradata Below is the example of BTEQ IMPORT Script. This topic describes the commands that are used in the BTEQ script when configuring Teradata Alerts.

Author: Doukasa Brataxe
Country: Panama
Language: English (Spanish)
Genre: Spiritual
Published (Last): 8 September 2018
Pages: 23
PDF File Size: 6.85 Mb
ePub File Size: 20.52 Mb
ISBN: 291-6-45303-346-3
Downloads: 63109
Price: Free* [*Free Regsitration Required]
Uploader: Mezik

How to pass a parameter from one Shell-script to another Shell-script. Pleasehelp me overcome them.

linux – Passing variables from shell script to BTEQ File – Stack Overflow

Looks like you are really looking for a here document. ULick 3 This avoids the pesky external file, and also coincidentally removes the fugly useless use of cat. The sed command will change all occurrences sccript the keyword Rundate. Questions without a clear problem statement are not useful to other readers.

Sign up or log in Sign up using Google. I have edited my question.

View Public Profile for RudiC. I am not understanding this code, which is written by someone else. Any variable or wildcard in the here document will be evaluated scrip the shell before bteq runs as long as you don’t quote the here-document delimiter ; that’s why the asterisk has to be backslash-escaped otherwise the shell would expand the glob to a list of all the files in the current directory.

Thus, I want the date to be fixed to check for that data for that day. Stack Overflow works best with JavaScript enabled. It would output and run something like: It would output and run something like:. Find all posts by Don Cragun. But I also know nothing about how your database is setup to evaluate if the rest is valid.


Bteq script to read and execute query from a table. How to create a Minimal, Complete, and Verifiable example. To run a local shell script in a remote machine by passing arguments to the local shell script.

BTEQ script in Shell Script

By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. This has to be continued till the last row in my table. Is this script scirpt Be aware, that the ; at the end would never be passed to the script. View Public Profile for Don Cragun. Email Required, but never shown. In reality, my query is very big around line of code so I don’t want to execute btqe query inside the shell script.

Page 1 of 2. Shell Programming and Scripting. Can any one please explian me the below bteq code. Code is working fine btea table exists.

How to Run a shell script from Perl script in Parent shell? Not a Forum Member? You might want to refine this by having a more restrictive search for example: The same could be done with sedof course — just make sure you don’t use single quotes, as sfript prevent the shell from seeing and modifying the variable.


You can simply update your script to change the keyword Rundate in your. Call a function in shell script from another shell script. You might want to refine this by having a more restrictive search for example:.

BTEQ Script Processing

For that I written below code. I want to pass ‘Date’ variable from shell script into the BTEQ file so that the query that executes takes that ‘date’ into account. Any way I can do this in Bteq script other than using shell scripting.

Sign scripf or log in Sign up using Google. If exists, drop it else do nothing. XYZ No, everything “echo’d” out will just be run by the terminal. I updated my answer. If that is added in the. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Shell Programming and Scripting

Add as many as you want separated by a semi colon. If i remove the column name manually and run ,then second export stmt is printing as below,need to eliminate the column heading from it. Tags scripscriptshellshell scriptshell scriptsteradata.

Then it doesn’t help my cause since everytime this function runs it consider the system date and modifies accordingly.

As is, it is neither a unix script, nor some codenor something bteq could use. I realized that the solution you gave was not really fulfilling the condition. At the top of the script.