“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):||26 August 2016|
|PDF File Size:||19.20 Mb|
|ePub File Size:||6.88 Mb|
|Price:||Free* [*Free Regsitration Required]|
Please prove me wrong.
Questions without a clear problem statement are not useful to other readers. Sign up using Facebook.
linux – Passing variables from shell script to BTEQ File – Stack Overflow
Any way by which I can solve this problem. Find all posts by RudiC. Then this is not parsed by bteq? That is not the issue.
It seems to work fine with this. I have edited my question. How to use ssh execute other shell script on other host shell script include nohup? As is, it is neither a unix script, nor some codenor something bteq could use.
Post as a guest Name. What is a dot command. But I also know nothing about how your database is setup to evaluate if the rest is valid. To run a local shell script in sxript remote machine by passing arguments to the local shell script. It would output and run something like: What about executing the table content? Questions seeking debugging help ” why isn’t this code working?
The same could be done with sedof course — just make sure you don’t use single quotes, as those prevent the shell from seeing and modifying the variable.
Shell Programming and Scripting
Scrit I don’t think that script is scritp.
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. My requirement is I need to write bte bteq script which reads row by row from this table until the last row, and execute the row content. Sign up using Email and Password. The value of RUNDATE should be assigned at the starting of the shell script, basically, it should be read only once and should remain same throughout the batch process i.
Shell Programming and Scripting. Hi Team, I have a scripf where I need to check for table. The shell would take it as end of command token. Any way I can do this in Bteq script other than using shell scripting.
How to write Config shell script to pass variables in master shell script?
Bteq script to read and execute query from a table. ULick 3 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. Find all posts by Don Cragun.
Rudic, what chage you are suggesting in order to make it work?