I have to assign a result of a query to a vairable like this
how can i do this
Query = select count(*) from table
x=`db2 ${Query}| sed -n '4p'`
but this doesn't work, is there any other way to assign the result without redirecting the result to temp file. .
Thanks
Mark. (3 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)
i want to assign a anme for a string, i got the things below, but it doesn't work.
MParc1=``
if
then
$MPrac1=`Prac1` # assign $MPrac1 to Prac1
else
$MPrac1=`` #assigne $MPrac1 to nothing
fi
echo "${MPrac1} >>file
Output: (if num is 0)
Prac1
can you please... (6 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)
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)
#! /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)
Hi Guys,
It may sound silly questions but I am really confused and forgot the sequence to set IP in REDHAT 6.
1st type
system-config-network
then I give IP as 192.168.1.78
Subnet as 255.255.255.0
Then do
/etc/init.d/network restart
Then when I check with ifconfig eth0... (1 Reply)
Hi guys i need to assign to a $var the name of a directory i've created before like this:
mkdir cd /esb/cargomax/fuse/SMX_SV_$(date +%F)
i guess this is very simple, but.....
Thanks!! (3 Replies)
I have written a shell script to calculate dbsize :-
db2 "call get_dbsize_info(?,?,?,-1)" | sed -n '8p' | awk -F : '{print $2}'
dbsize=`db2 "call get_dbsize_info(?,?,?,-1)" | sed -n '8p' | awk -F : '{print $2}'`
echo $dbsize
when I execute it the syntax works but it's not... (11 Replies)
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)
Discussion started by: ilugopal
5 Replies
LEARN ABOUT DEBIAN
mtbl_info
MTBL_INFO(1)MTBL_INFO(1)NAME
mtbl_info - display information about an MTBL file
SYNOPSIS
mtbl_info FILE [FILE]...
DESCRIPTION mtbl_info(1) displays the following information about the MTBL files specified on the command line.
file name -- the name of the MTBL file.
file size -- the total size of the MTBL file, in bytes.
index bytes -- the total number of bytes and proportion of the total file size consumed by the index.
data block bytes -- the total number of bytes and proportion of the total file size consumed by data blocks.
data block size -- the maximum size of an uncompressed data block.
data block count -- the total number of data blocks.
entry count -- the total number of key-value entries.
key bytes -- the total number of bytes that all keys in the file would occupy if stored end-to-end in a byte array with no delimiters.
value bytes -- the total number of bytes that all values in the file would occupy if stored end-to-end in a byte array with no delimiters.
compression algorithm -- the algorithm used to compress data blocks. Possible values are "none", "snappy" and "zlib".
compactness -- a rough metric comparing the total number of bytes in the key-value entries with the total size of the MTBL file. It is
calculated as (file size) / (key bytes + value bytes), and thus takes into account the gains of data block compression and prefix key
compression against the overhead of the index, trailer, and data block offset arrays.
05/29/2012 MTBL_INFO(1)