“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):||24 September 2007|
|PDF File Size:||19.87 Mb|
|ePub File Size:||14.7 Mb|
|Price:||Free* [*Free Regsitration Required]|
By the by, you should avoid uppercase for you own variables, as uppercase is reserved for system use. This has to be continued till the last row in my table. This avoids the pesky external file, and also coincidentally removes the fugly useless use of cat.
View Public Profile for RudiC. Then this is not parsed by bteq?
Can you advise me now as to how should I proceed. Add as many as you want separated by a semi colon.
Teradata – BTEQ
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. Questions betq debugging help ” why isn’t this code working?
Unable to pass shell script variable to awk command in same shell script. Sign up or log in Sign up using Google. Can any one please explian me the below bteq code. Xander Luciano 2, 2 21 How to write config shell script scritp pass variables in master shell script?
I think This approach may work What I don’t want: Post as a guest Name. Questions without a clear problem statement are not useful to other readers.
Correct shell script to Call One shell script from another shell script. How to execute one shell script after execution of another shell script? Rudic, what chage you are suggesting in order to make it work? BUT if table does not exists, it still goes to drop it, which I do not want it to do.
Bteeq No, everything “echo’d” out will just be run by the terminal.
Unless you can give specific errors and information about how your files are setup and doing, it’s hard to help you. Shell script works fine as a standalone script but not as part gteq a bigger script. Shell Programming and Scripting. I have edited my question.
SSIS with Teradata BTEQ script sample
You might want to refine this by having a more restrictive search for example:. I have a shell script. In reality, my query is very big around line of code so I don’t want to execute the query inside the shell script.
As is, it is neither a unix script, nor some codenor something bteq could use. It would output and run something like:. While doing an export,I am unable to eliminate column name.