“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: Sagor Vilrajas
Country: Ethiopia
Language: English (Spanish)
Genre: Software
Published (Last): 26 August 2016
Pages: 462
PDF File Size: 19.20 Mb
ePub File Size: 6.88 Mb
ISBN: 391-8-67113-767-5
Downloads: 21902
Price: Free* [*Free Regsitration Required]
Uploader: Fenrigami

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

I want to pass ‘Date’ variable from shell script into the BTEQ file so that the query that executes takes that ‘date’ into account. Can you help me with that. I will read the first row from the table, I need to execute the content in col1 and col2 of row 1 and store it in to another table. Post Your Answer Discard 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.

Scrit I don’t think that script is scritp.

Stack Overflow works btwq with JavaScript enabled. For that I written below code. By the by, you should avoid uppercase for you own variables, as uppercase is reserved for system use. How to pass a parameter from one Shell-script to another Shell-script.

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.


Xander Luciano 2, 2 21 Sign up using Facebook. The time now is Looks like you are really looking for a here document. View Public Profile for RudiC. 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.

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.

I have a shell script. Sign up or log in Sign up using Google. Can you advise me now as to how should I proceed. Stack Overflow works best with JavaScript enabled. Any variable or wildcard in the here document will be evaluated by the shell before bteq runs as long as you don’t quote the here-document delimiter ; that’s scdipt 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.

Rudic, what chage you are suggesting in order to make it work?