I would like to Count the number of rows in the log table.if the count is greater than zero then I need to run certain Part of the code if not another part of the code apart from that again If I found the count = 0 then I need to write the text " ROWS With greater values not found" in the spool file because I am using this spool file output in a mail. SO what I did is I have added the output of the query to the variable rows. the query is working if I found any number after the variable row. getting any error is the query is returning zero bcoz i hope at that time in the spool file the text will be ROWS With greater values not found which the function
might throwing error
Hi
We had 3 server -hp112and hp146 here hp112 is production server and hp146 is staging server used for load.
when i am trying to run follwing command
rcp abc hp112:/dnbusr1/gbid/gbid02 it's trowing an error :-
remshd: Login incorrect.
But same command is working wise versa -
rcp abc... (1 Reply)
how can i make one script fail if some condition is not satisfied.i m writing if ..else logic in script.i need some standard command to do that ,, (1 Reply)
Hello,
while i was saving a web file directing on to usb location there was some network problem which result in error WRITE DELAYED on windows xp.
so pen drive is not getting completely formated(show as Windows was unable to complete format).From then onwords it is not allowing to copy... (0 Replies)
Hi Guys,
I am trying a simple for loop which is throwing an error.
Below is my code:
#/bin/sh
set -A array "are" "you" "there";
for ( i = 0 ; i < ${#array} ; i++ )
do
echo ${array}
done
I am getting this error
tci001wasd02 $ sh -vx array_for.sh
#/bin/sh
set -A array "are"... (6 Replies)
All ,
I am trying to install POCO lib on Solaris server.
When I do make -s,I am getting the following error.
make: Fatal error in reader: Makefile, line 10: Unexpected end of line seen
Few of the content:
#
# Makefile
#
# The global Makefile for POCO
#
#sinclude config.make
... (0 Replies)
Dear all,
I would like to count the no;of word "INFORMATION" in a file called alt.lst and output to a unix variable INFORMATION.so to do this I wrote the below code
INFORMATION=echo 'INFORMATION' | tr -cs 'A-Za-z' '\n' < /app/tisq005/01/home/tisq005b/scripts/alt.lst | grep -c "INFORMATION"... (2 Replies)
Hi All
I have two shell scripts where the second is getting invoked from the first. E.g.
test1.sh and test2.sh Within test1, the code is something like this:
#!/bin/bash
. test2.sh
usage() {
echo "..."
echo "....."
}
SRC=$1
DEST=$2
case "$3" in
tran) doTran ;;
*)... (7 Replies)
Hello Gurus,
I am writing one script at linux.
The logic is
There is a find command which will find some specific files daily and store at a variable
Then echo that variable .
Now when I am trying to read the variable by using for loop it is throwing error as below:cat: CKDT.dat: No such... (5 Replies)
Hi,
I have downloaded gzipped source tarball of python3.7. I have tried to compile like below,
./configure --prefix=/directory
Compiling seems to be ok..But when running make all..Getting too many missing initializer warnings
/python3.6/Python-3.6.0/Modules/_cursesmodule.c: At top level:... (1 Reply)
Hi,
Prustat is throwing error only in zones. But it is working fine in global.
dtrace: invalid probe specifier
/*
** The following is a trimmed version of two seperate DTrace scripts:
**
** socketsnoop.d - snoop TCP network socket traffic by process.
** This is intended to identify the... (3 Replies)
Discussion started by: Sumanthsv
3 Replies
LEARN ABOUT PHP
fbsql_affected_rows
FBSQL_AFFECTED_ROWS(3) 1 FBSQL_AFFECTED_ROWS(3)fbsql_affected_rows - Get number of affected rows in previous FrontBase operationSYNOPSIS
int fbsql_affected_rows ([resource $link_identifier])
DESCRIPTION fbsql_affected_rows(3) returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with $link_identifier.
Note
If you are using transactions, you need to call fbsql_affected_rows(3) after your INSERT, UPDATE, or DELETE query, not after the
commit.
If the last query was a DELETE query with no WHERE clause, all of the records will have been deleted from the table but this function will
return zero.
Note
When using UPDATE, FrontBase will not update columns where the new value is the same as the old value. This creates the possibility
that fbsql_affected_rows(3) may not actually equal the number of rows matched, only the number of rows that were literally affected
by the query.
PARAMETERS
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
RETURN VALUES
If the last query failed, this function will return -1.
SEE ALSO fbsql_num_rows(3).
PHP Documentation Group FBSQL_AFFECTED_ROWS(3)