Return SQL Count to Variable

[sweevo]

Hello,

Is it possible to call a SQL statement from a script (Bourne Shell) and assign its output to a variable - if possible without having to create and delete temp output files?

The SQL is a Count query, that will return one value. I want to use this value for comparisons within the script.

Any help would be appreciated.

Thanks.

 

[olded]

What's your database?

 

[vgersh99]

faq822-2218

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[sweevo]

The database is ingres.

I've had a look at the FAQ but am having difficulty applying it to what I need.

Thanks

 

[vgersh99]

here's another hint:

#/bin/ksh
shellCount=$(yourIngresQueryGoesHere)

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+