Hi,
I have below awk statement and I need to convert the second field ( substr($0,8,6))from minutes to hours with 2 decimail place. How can I achieve this?
/usr/bin/awk '{print substr($0,23,4),substr($0,8,6)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$
Thanks for any help! (4 Replies)
hi all
Am new to scripting...
So,i have a file named file1 its contents are as follows:
joy 55 66 77
ruby 77 88 99
saloni 88 44 33
I would require a script which will calculate its percentage,its total and the average with awk script
Many thanks in advance..
Please reply me at... (4 Replies)
Hi members, I am working in WebSphere in Unix environment. we are working with 500 odd servers and most of the times processes got down. Can i have any shell script through whih some popup with alarm get raised whenever some server get down. kindly help.. Thanks Rishi (1 Reply)
Is there any awk command to calculate P Value ?(Probability)
Is it possib;e to calculate P va;ue for this data for ex?
7.891284
8.148193
7.749575
7.958188
7.887702
7.714877
8.141548
7.51845
8.27736
7.929853
7.92456
8.249126
7.989113
8.012573
8.351206 (2 Replies)
I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall:
Example file:
File 1
001 0.046 0.667267
001 0.047 0.672028
001 0.048 0.656025
001 0.049 ... (2 Replies)
Hello,
I created a user in my AIX 5.3 system and i modified /etc/passwd file in and assigned this user the uid=0 like root user.
The problem is that when this user log into the system through putty it asks for root password instead of the user password.
As a result of this, if i reset the... (4 Replies)
Hi Guys,
I got stuck to a a point where I need to find the value for (4 to the power of -2 upto 8 places after decimal ....
4^(-2) ; the result I need is upto 8 places after decimal.
How is that possible?
Thanks a lot!! (2 Replies)
Discussion started by: Indra2011
2 Replies
LEARN ABOUT PHP
db2_result
DB2_RESULT(3) 1 DB2_RESULT(3)db2_result - Returns a single column from a row in the result setSYNOPSIS
mixed db2_result (resource $stmt, mixed $column)
DESCRIPTION
Use db2_result(3) to return the value of a specified column in the current row of a result set. You must call db2_fetch_row(3) before
calling db2_result(3) to set the location of the result set pointer.
PARAMETERS
o $stmt
- A valid stmt resource.
o $column
- Either an integer mapping to the 0-indexed field in the result set, or a string matching the name of the column.
RETURN VALUES
Returns the value of the requested field if the field exists in the result set. Returns NULL if the field does not exist, and issues a
warning.
EXAMPLES
Example #1
A db2_result(3) example
The following example demonstrates how to iterate through a result set with db2_fetch_row(3) and retrieve columns from the result
set with db2_result(3).
<?php
$sql = 'SELECT name, breed FROM animals WHERE weight < ?';
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, array(10));
while (db2_fetch_row($stmt)) {
$name = db2_result($stmt, 0);
$breed = db2_result($stmt, 'BREED');
print "$name $breed";
}
?>
The above example will output:
cat Pook
gold fish Bubbles
budgerigar Gizmo
goat Rickety Ride
SEE ALSO db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_fetch_row(3).
PHP Documentation Group DB2_RESULT(3)