“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):||3 November 2006|
|PDF File Size:||9.6 Mb|
|ePub File Size:||8.44 Mb|
|Price:||Free* [*Free Regsitration Required]|
XYZ No, everything “echo’d” out will just be run by the terminal. Then it doesn’t help my cause since everytime this function runs it consider the system date and modifies accordingly.
The shell would take it as end of command token. Find all posts by Don Cragun. Export the output of the table in such a format that it beomces executable script and then call that script. Shell script works fine as a standalone script but not as part of a bigger script.
Call a function in shell script from another shell script. If exists, drop it else do nothing. Post as a guest Name. Sign up using Facebook. I have edited my hteq to state my use-case more clearly. All forum topics Previous Topic Next Topic. You might want to refine this by having betq more restrictive search for example:. As is, it is neither a unix script, nor some codenor something bteq could use. I want to pass ‘Date’ variable from shell script into the BTEQ file so that the query that executes takes that ‘date’ into account.
I updated my answer. What about executing the table content?
Teradata – BTEQ
Why a dot-command is used to execute a script, which is named. I think This approach may work Email Required, but never shown. Unless you can give specific errors and information about how your files are setup and doing, it’s hard to help you.
Post as a guest Name. What is a dot command. This avoids the scgipt external file, and also coincidentally removes the fugly useless use of cat.
sql scripts – Is echo vallid syntax in teradata BTEQ – Stack Overflow
You might want to refine this by having a more restrictive search for example: Questions seeking debugging help ” why isn’t this code working?