Prob Assign Row count to a variable

Original Message

Name: iam2001
Date: July 11, 2007 at 12:57:46 Pacific
Subject: Prob Assign Row count to a variable
OS: Unix
CPU/Ram: N/A
Model/Manufacturer: N/A

Comment:

Is it possible to use a shell script to login to a database (using Teradata), run a query and assign the query result to a local variable defined in the shell?
I know it's possible to run teradata SQL through a shell script if teradata is installed on the machine but what I want to do is to assign a value to a variable while at the SQL prompt.
Thanks!

Report Offensive Message For Removal

Response Number 1

Name: nails
Date: July 11, 2007 at 14:33:37 Pacific
Subject: Prob Assign Row count to a variable

Reply: (edit)

Using command substituition, it's possible to assign the contents of any valid unix command - including shell scripts - to a shell variable. Using the Bourne shell, it's
# that's the back tic
a=`echo 1`
or if you are using korn or bash type shells:
b=$(echo 2)

Report Offensive Follow Up For Removal


assign two commands to a variable. Assign to a Variable assigning a variable to a script Assigning of expression to a variab dir path to a variable from file	To read the value of a variable Assign File modify time to a Var Assign Date to a Var Parse integer variable and count ea Assignment of Variable