concise SQL results

[Ross Morton]

I'm writing a shellscript where I'm performing some SQL queries and
assigning the results to variables. The problem is that the query produces
a column heading, some underline characters and '1 record(s) selected' as
well as the result. All of this text is being assigned to my variable.

Is there any way of just getting the result itself without all the
surrounding stuff ?

Thanks

Ross

[Joachim Mueller]

Roos,

use db2 -x

regards,
Joachim Müller

"Ross Morton" <[e-mail]> schrieb im Newsbeitrag
news:c8**********@singer.cent.gla.ac.uk...

I'm writing a shellscript where I'm performing some SQL queries and
assigning the results to variables. The problem is that the query produces a column heading, some underline characters and '1 record(s) selected' as
well as the result. All of this text is being assigned to my variable.

Is there any way of just getting the result itself without all the
surrounding stuff ?

Thanks

Ross

[Paul Vernon]

"Ross Morton" <[e-mail]> wrote in message
news:c8**********@singer.cent.gla.ac.uk...

I'm writing a shellscript where I'm performing some SQL queries and
assigning the results to variables. The problem is that the query produces a column heading, some underline characters and '1 record(s) selected' as
well as the result. All of this text is being assigned to my variable.

Is there any way of just getting the result itself without all the
surrounding stuff ?
db2 -x

i..e in ksh
a=`db2 -x values current timestamp`
echo $a

2004-05-13.11.11.357301
Regards
Paul Vernon
Business Intelligence, IBM Global Services

[Serge Rielau]

Use
db2 -x
see:
http://publib.boulder.ibm.com/infoce...e/c0010412.htm
"-x This option tells the command line processor to return data without
any headers, including column names."

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Ross Morton]

Thanks to all of you - db2 -x works perfectly !

Ross