“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.
|Published (Last):||15 February 2016|
|PDF File Size:||16.29 Mb|
|ePub File Size:||2.14 Mb|
|Price:||Free* [*Free Regsitration Required]|
This has to be continued till the last row in my table.
Shell Programming and Scripting
Teradata Wiki: BTEQ
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.
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.