Assign return value of DB2 query to variable

Question

I have a file test.sh in which i have a query which gives me the count of total records in the table, as shown below:

Query:

echo db2 -x "select count(*) from testable”

Now I want to assign the whatever value it returns after executing it to the variable as totalRecords using the Unix Shell Script.

proksch_ibm · Accepted Answer · 2016-03-08 13:44:11Z

3

#!/bin/bash

cnt=`db2 -x "select count(*) from syscat.tables" `

echo "Counter is:  ${cnt}"

Counter is: 474

answered Mar 8, 2016 at 13:44

proksch_ibm

2781 silver badge9 bronze badges

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

2 Comments

Thank you. Can i use this counter into some other files? If yes then how?

yes - you'd have to do a similar process of capturing the output with `` OR persist the value to a temp file and read the value into the script.