How can I send the results of a query to a unix variable. I basically want to run a query then do some logic on the results. Trying to redirect the result into a variable I define in the script.

select count(*) as counter from table - nut to redirect the "count" returned from the query into a variable withing the unix script.

Trying this in a teradata bteq script.

Thanks for your help.

so you want to run a bteq script which gets the number of rows from a table and then you want to use this number in a variable in a unix shell script?
I think we used to redirect the output of the bteq script into a file and then (within the unix script) read the file into a variable.

There is also a bteq status variable named ACTIVITYCOUNT which saves the number of rows read from any SQL statement. But I suppose this is not what you are looking for. ( see: teradata bteq manual ).

You might also want to check Welcome to The Teradata Forum.

You can save the output of any command to a variable:

VAR1=$( echo "Hello" )
VAR2=$( ls -l / )