How to display only the db2 query result via shell script and not the query?

Question

There is probably a very simple solution here, but I am probably not using the right search terms. I have a sql query running in a shell script. I get the results I am looking for, however, I am also getting the sql query as part of of the result. How can I suppress this and just show the result?

My script:

#!/usr/bin/sh

db2 connect to MYDB >/dev/null 2>&1;
db2 -x -v "select A, B, C from MYTABLE";
db2 connect reset >/dev/null 2>&1;

And my output looks like this:

select A, B, C from MYTABLE
AAA   BBB   CCC
AAA   BBB   CCC

I would like to get rid of the first row and just show the result. What am I missing?

Thanks in advance for your help!

do you just want to get rid of the first row ?

Kent
– Kent

2012-12-07 22:35:39 +00:00
Commented Dec 7, 2012 at 22:35 — Kent
– Kent, Commented Dec 7, 2012 at 22:35

Ian Bjorhovde · Accepted Answer · 2012-12-09 15:20:55Z

3

The -v option for the DB2 command line processor causes the current statement being executed to be printed in the output.

Remove the -v from your command and you'll get only the results of the query.

answered Dec 9, 2012 at 15:20

Ian Bjorhovde

11.1k1 gold badge30 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

fembot Over a year ago

Thank you! This goes in the category of one of my dumbest questions, but had to ask;)

Kent · Accepted Answer · 2012-12-07 22:38:45Z

3

if you just want to skip the 1st row from your output you could:

yourscript.sh | tail -n +2

test with seq:

kent$  seq 5|tail -n +2  
2
3
4
5

answered Dec 7, 2012 at 22:38

Kent

197k36 gold badges248 silver badges317 bronze badges

Comments

Enosh Bansode · Accepted Answer · 2015-03-03 11:39:13Z

0

Try this

db2 -o query

for more info. http://www.ibm.com/developerworks/data/library/techarticle/adamache/0109adamache.html

answered Mar 3, 2015 at 11:39

Enosh Bansode

1,7793 gold badges18 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to display only the db2 query result via shell script and not the query?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related