“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: Kigagal Mazumi
Country: Brazil
Language: English (Spanish)
Genre: Relationship
Published (Last): 15 February 2016
Pages: 191
PDF File Size: 16.29 Mb
ePub File Size: 2.14 Mb
ISBN: 459-5-90252-816-1
Downloads: 69069
Price: Free* [*Free Regsitration Required]
Uploader: Samuzahn

This has to be continued till the last row in my table.

Shell Programming and Scripting

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Page 1 of 2. Shell Programming and Scripting. All Linux Man Pages. Unless you can give specific errors sctipt information about how your files are setup and doing, it’s hard to help you.

Questions seeking debugging help ” why isn’t this code working? View Public Profile for Scrutinizer. It seems to work fine with this. Stack Overflow works best with JavaScript enabled. How to create a Minimal, Complete, and Verifiable example.


Teradata Wiki: BTEQ

Shell script works fine as a standalone script but not as part of a bigger 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. If that is added in the. Scrlpt you advise me now as to how should I proceed.

The sed command will change all occurrences of the keyword Rundate. That is not the issue.

All times are GMT So I don’t think that script is valid. How to write Config shell script to pass variables in master shell script? If you want the date scripy stay put once you have calculated it so that it doesn’t change underneath if the script runs past midnight.

Sign up or log in Sign up using Google. Xander Luciano 2, 2 21 The shell would take it as end of command token. Find all posts by Don Cragun. Accessing variables of one shell script in another shell script. Any way by which I can solve this problem. Can you help me with that.


I think This approach may work Please prove me wrong. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Then this is not parsed by bteq? What is a dot command. Add as dcript as you want separated by a semi colon. It would output and run something like: I want to pass ‘Date’ variable from shell script into the BTEQ file so that the query that executes takes that ‘date’ into account. Be aware, that the ; at the end would never be passed to the script.

I realized that the solution you gave was not really fulfilling the condition. For that I written below code.