05-31-2012
Adding suffix in row
I have an input file like
RELTEST_SITE2||RELTEST_SITE2|RELTEST_SITE2|Huawei-BTS|Cell Sites|Huawei|||South/KERALA/COCHIN/KAZIKODE|Active|Not Maint|12|fiber|GCRNUJRNUJB001HBT022|357||RELTEST_BSC2|||||
and i want to add suffix to GCRNUJRNUJB001HBT022 as "12345"
Kindly suggest a query.
Also suggest a query which works for 5 10 rows
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can I use xargs to send a list of commands to a process, to be acted upon individually? Here's what I have: a file that contains numbers, one per line. The desired outcome it to send each number to a DB2 query. I thought xargs would work, but it doesn't. I tried it like this:
cat file | xargs |... (4 Replies)
Discussion started by: jpprial
4 Replies
2. Shell Programming and Scripting
hi ,
can anyone help me by saying why we use xargs.. is it acing like a place holder..?
thanks,
Krips. (3 Replies)
Discussion started by: kripssmart
3 Replies
3. UNIX for Advanced & Expert Users
I discovered that GNU's xargs has a -P option to allow its processes to run in parallel. Great! Is this a GNU thing, or is it supported by other platforms as well? (4 Replies)
Discussion started by: otheus
4 Replies
4. Shell Programming and Scripting
hi
i just want to know that how do we use xargs command to find files which are greater than specified memory
in a given directory (6 Replies)
Discussion started by: sumit the cool
6 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement to RCP the files from remote server to local server.
Also the RCP has to run in parallel. However using 'xargs' retrives 2 file names during each loop. How do we restrict to only one file name using xargs and loop till remaining files.
I use the below code for... (2 Replies)
Discussion started by: senthil3d
2 Replies
6. Shell Programming and Scripting
Hello there,
Let me show you a simple example of what I am trying to achieve:
1) I have an input text file with some lines:
1 a
2 b
3 c
2) And I want to run a command with these lines as arguments (+ arbitrary extra arguments). For example:
$ command "1 a" "2 b" "3 c" "bye"
I... (7 Replies)
Discussion started by: tokland
7 Replies
7. Shell Programming and Scripting
hi
Could any one please tell me the option using which we can run multiple commands using xargs
I have list of files, I want to run dos2unix and chmod at one shot on them
I tried google n searched man pages but couldnt really find the solution , please help
right now im doing this
ls... (4 Replies)
Discussion started by: sunilmenhdiratt
4 Replies
8. Shell Programming and Scripting
Hi,
I want to find some files and then search for some lines in it with a particular pattern and then write those lines into a file. To do this I am using something like this from command prompt directly.
cd /mdat/BVG
find -name "stmt.*cl" -newer temp.txt | xargs -i awk '/BVG-/{print}' {} >... (7 Replies)
Discussion started by: Sandhya Harsh
7 Replies
9. UNIX for Dummies Questions & Answers
Hi,
can anyone tell me in detail ?
what the following do in detail ?
I am trying to get a largest number in a list
Thanks
Tao
LARGEST=$(echo $* | xargs -n1 | sort -nr | tail -1) (3 Replies)
Discussion started by: ccp
3 Replies
10. Shell Programming and Scripting
Hi I have multiple files for which I want to use awk for the following:
Read each line in each file- if any of the columns match "PVALUE=" followed by the number, then print the line in case the number following "PVALUE=" is greater than 0.05.
I did the following:
ls *.txt | xargs -I @ -P15... (14 Replies)
Discussion started by: ts89490
14 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 operation
SYNOPSIS
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)