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
ifx_affected_rows
IFX_AFFECTED_ROWS(3) 1 IFX_AFFECTED_ROWS(3)
ifx_affected_rows - Get number of rows affected by a query
SYNOPSIS
int ifx_affected_rows (resource $result_id)
DESCRIPTION
Returns the number of rows affected by a query associated with $result_id.
For inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]).
Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not even
begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).
Useful after ifx_prepare(3) to limit queries to reasonable result sets.
PARAMETERS
o $result_id
- A valid result id returned by ifx_query(3) or ifx_prepare(3).
RETURN VALUES
Returns the number of rows as an integer.
EXAMPLES
Example #1
Informix affected rows
<?php
$rid = ifx_prepare("select * from emp
where name like " . $name, $connid);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
?>
SEE ALSO
ifx_num_rows(3).
PHP Documentation Group IFX_AFFECTED_ROWS(3)