11-03-2013
Is it possible that when get_dbsize_info is called twice in quick succession that the 2nd call doesn't output the same data?
You could try putting sleep 5 between the lines to give db2 a chance to "cleanup" from the previous call.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: sunpraveen
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: ryanW
4 Replies
3. Shell Programming and Scripting
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)
Discussion started by: navjinder
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Amey Joshi
13 Replies
5. Shell Programming and Scripting
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)
Discussion started by: sandy1028
2 Replies
6. Shell Programming and Scripting
#! /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)
Discussion started by: kvok
2 Replies
7. Shell Programming and Scripting
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)
Discussion started by: Funkeydude
2 Replies
8. Programming
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)
Discussion started by: gthangav
3 Replies
9. Shell Programming and Scripting
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)
Discussion started by: chidori
5 Replies
10. Shell Programming and Scripting
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
USLEEP(3) Library Functions Manual USLEEP(3)
NAME
usleep - suspend execution for interval
SYNOPSIS
usleep(useconds)
unsigned useconds;
DESCRIPTION
The current process is suspended from execution for the number of microseconds specified by the argument. The actual suspension time may
be an arbitrary amount longer because of other activity in the system or because of the time spent in processing the call.
The routine is implemented by setting an interval timer and pausing until it occurs. The previous state of this timer is saved and
restored. If the sleep time exceeds the time to the expiration of the previous timer, the process sleeps only until the signal would have
occurred, and the signal is sent a short time later.
This routine is implemented using setitimer(2); it requires eight system calls each time it is invoked. A similar but less compatible
function can be obtained with a single select(2); it would not restart after signals, but would not interfere with other uses of setitimer.
SEE ALSO
setitimer(2), getitimer(2), sigpause(2), ualarm(3), sleep(3), alarm(3)
NOTES (PDP-11)
On the PDP-11, setitimer(2) rounds the number of microseconds up to seconds resolution, therefore usleep doesn't give you any more resolu-
tion than sleep(3). Select(2) offers clock resolution (usually 60Hz in the U.S.A. and 50Hz elsewhere) and so should be used instead.
4.3 Berkeley Distribution August 26, 1988 USLEEP(3)