Had no luck with the above syntax so Here's the db2 command output :-
So, adding line numbers to your output:
So, there is no way to get 21874778112 out of line 8 like you showed in your 1st message in this thread since you show here that it appears on line 9.
Did you just use the wrong line number?
Is the output from your db2 command always in this format, or does it vary depending on something you haven't shown us?
Would looking for the last string on the line after the line ends with "DATABASESIZE" be more reliable?
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)
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)
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 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)
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)
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)
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)
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 SUNOS
sleep
sleep(3UCB) SunOS/BSD Compatibility Library Functions sleep(3UCB)NAME
sleep - suspend execution for interval
SYNOPSIS
/usr/ucb/cc [ flag ... ] file ...
int sleep( seconds);
unsigned seconds;
DESCRIPTION
sleep() suspends the current process from execution for the number of seconds specified by the argument. The actual suspension time may be
up to 1 second less than that requested, because scheduled wakeups occur at fixed 1-second intervals, and may be an arbitrary amount longer
because of other activity in the system.
sleep() is implemented by setting an interval timer and pausing until it expires. The previous state of this timer is saved and restored.
If the sleep time exceeds the time to the expiration of the previous value of the timer, the process sleeps only until the timer would have
expired, and the signal which occurs with the expiration of the timer is sent one second later.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|MT-Level |Async-Signal-Safe |
+-----------------------------+-----------------------------+
SEE ALSO alarm(2), getitimer(2), longjmp(3C), siglongjmp(3C), sleep(3C), usleep(3C), attributes(5)NOTES
Use of these interfaces should be restricted to only applications written on BSD platforms. Use of these interfaces with any of the system
libraries or in multi-thread applications is unsupported.
SIGALRM should not be blocked or ignored during a call to sleep(). Only a prior call to alarm(2) should generate SIGALRM for the calling
process during a call to sleep(). A signal-catching function should not interrupt a call to sleep() to call siglongjmp(3C) or longjmp(3C)
to restore an environment saved prior to the sleep() call.
WARNINGS
sleep() is slightly incompatible with alarm(2). Programs that do not execute for at least one second of clock time between successive
calls to sleep() indefinitely delay the alarm signal. Use sleep(3C). Each sleep(3C) call postpones the alarm signal that would have been
sent during the requested sleep period to occur one second later.
SunOS 5.10 12 Feb 1993 sleep(3UCB)