+ db2 call get_dbsize_info(?,?,?,-1)
+ echo Value of output parameters -------------------------- Parameter Name : SNAPSHOTTIMESTAMP Parameter Value : 2013-11-03-17.31.13.182521 Parameter Name : DATABASESIZE Parameter Value : 21874778112 Parameter Name : DATABASECAPACITY Parameter Value : 115676934144 Return Status = 0
Value of output parameters -------------------------- Parameter Name : SNAPSHOTTIMESTAMP Parameter Value : 2013-11-03-17.31.13.182521 Parameter Name : DATABASESIZE Parameter Value : 21874778112 Parameter Name : DATABASECAPACITY Parameter Value : 115676934144 Return Status = 0
+ db2 call get_dbsize_info(?,?,?,-1)
+ sed -n 8p
+ echo
Last edited by Don Cragun; 11-03-2013 at 07:51 PM..
Reason: Change QUOTE tags to CODE tags.
Using echo with no quotes on it arguments is hiding any newlines, tabs, and any sequences of two or more spaces that may have been produced by the output of the db2 command. Then, since you converted all of the output from db2 into a single line with the echo, sed -n 8p will obviously not find a number to print on the eighth line of its single line of input.
But, even before we get to that problem, you also show that the output from db2 has spaces surrounding the colons in its output. So, even if the eighth line of output was something like:
Code:
Parameter Value : 21874778112
The output when printing the 2nd field of that colon separated value line would have a leading space (which you did not show us in any message in this thread until now). That leading space will keep the assignment to dbsize from working the way you want it to work.
Making several wild assumptions, the following change shown in red might work:
Had no luck with the above syntax so Here's the db2 command output :-
Code:
db2 "call get_dbsize_info(?,?,?,-1)"
Value of output parameters
--------------------------
Parameter Name : SNAPSHOTTIMESTAMP
Parameter Value : 2013-11-03-19.00.50.590366
Parameter Name : DATABASESIZE
Parameter Value : 21874778112
Parameter Name : DATABASECAPACITY
Parameter Value : 115676934144
Return Status = 0
I have a person script which has a following statement.
BUILD_FOLDER=$2
i=$((${#BUILD_FOLDER}-1))
if
then
BUILD_FOLDER=$BUILD_FOLDER/
#echo $BUILD_FOLDER
else
echo " "
#echo $BUILD_FOLDER
fi
What and how this statement works ?
i=$((${#BUILD_FOLDER}-1)) (5 Replies)
I am trying to read a input file which has two columns separated by space
Input file
server1 server2
server3 server4
server5 server6
When i execute the below while code it reads line by line and a and b variables are able to successfully fetch the values
while read a b
do
echo "$a"
echo... (5 Replies)
Hi,
I am unable to assign value zero to my variable which is defined as unsigned char.
typedef struct ABCD
{
unsigned char abc;
unsigned char def;
unsigned char ghi;
} ABCD;
typedef ABCD *PABCD;
In my Por*C code, i assign the values using memcpy like below
... (3 Replies)
Code
set -x
STATUS="0"
echo $STATUS
for i in `ls -ltr Report*|awk '{ print $9 }'`
do
if
then
flg = "`head -1 "$i" |cut -c 31-33`"
echo `head -1 "$i" |cut -c 31-33`
echo $flg
if
then
echo "having Fun"
STATUS="2"
else
echo "no Fun"
fi
fi (2 Replies)
#! /bin/bash
if ; then
echo "Set number "
else
k=$1
sqlplus ${scheme}/${apsswd}@${server} @query.sql $k
fi
file query.sql looks like this
select * from tab1 where number =${k};
===================================
it doesnt work
my question is how to assign k value in last... (2 Replies)
DATA
---------------
0
Please tell me, if the file contains 0 after --. then assign the value to variable $var=false,
DATA
---------------
1
then $var=true, (2 Replies)
Hi Experts,
I am facing some problem while developing the script.My input config.csv file contains the three columns namely pathname,filename,filetype.Based on the file type i have to use ftp command that is if filetype=csv then do ftp.
The input file is
cat config.csv... (13 Replies)
Friends here is code which is used to add floating point using bc, but I m not getting any output instead some errors.
1 #!/bin/bash
4 if
5 then
6 echo "Our input is from a Device"
7 while read myline
8 do
9
10 total= `echo $total + $myline... (2 Replies)
Hi Everyone,
How to assign the specific value which return from database?
here is the return value from database -->
(return status = 0)
0 <----- this
I only need to get the "0" .. assign to another declare variable.
hope someone will help me..
Please
thank you.. (4 Replies)
Unix gurus,
I have a file as below, which is basically the result set obtained from a sql query on an Oracle database.
ID PROG_NAME USER_PROG_NAME
-------- --------------- ----------------------------------------
33045 INCOIN Import Items
42690 ... (3 Replies)
11-03-2013
