Sequential comparison (one row with file and so on)
Dear linux experts,
I'd like to ask for your support, I've read some posts in this forum about files comparison but haven't found what I'm looking for. I need to create a sequential script to compare row-by-row one file with 34 similar files but without success so far. This is what I get:
I need to compare the first row of base file with each row of file 1. Then, compare the second row of the base file with each row of file 1, and so on in the same way. When both values are the same, I need these values to be displayed in the screen (my bash shell). For instance in the above example, it should appear in the screen "889935.66 9554656.32 -88.5" after the first scan, after the second scan it should appear "5584452.22 4455874.12 -714.2".
Hi,
I want to write a shell script which increments a particular column in a row from a text file and then adds another row below the current row with the incremented value .
For Eg .
if the input file has a row :
abc xyz lmn 89 lm nk o p
I would like the script to create something like... (9 Replies)
We have to convert a sequential file to a 80 char line sequential file (HP UX platform).The sequential file contains special characters. which after conversion of the file to line sequential are getting coverted into "new line" or "tab" and file is getting distorted. Is there any way to read these... (2 Replies)
hi, I'm totally new to this forum and to awk.
I have what I thought was a simple problem, but I can't get anything to work. Here is an example input file:
3.85 4018.4
3.9 4068.4
3.95 4082.9
4 4099.7
# Property:.......etc.
0 4733.3
0.05 4659.7
0.1 4585.6
0.15 4466.2
Two... (2 Replies)
Hi,
I need help on doing the below thing in shell script.
I have a file with millions of rows called "abc.txt". i have another file with millions of rows called "xyz.txt".
I would like to do the below operation.
Open the abc.txt, read the first line, do some operations on the column... (2 Replies)
hi guys, today i'm stuck in a new problem.
the title explain more or less but a particular had been omitted. So i'm going to describe below the situation with an example.
I have different html files and each of them have a consecutive lines group inside that i want to extract.
example:
... (8 Replies)
Writing a Tool to simulate non-sequential disk I/O (simulate db file sequential read) in C POSIX
I have over the years come across the same issue a couple of times, and it normally is that the read speed on SAN is absolutely atrocious when doing non-sequential I/O to the disks. Problem being of... (7 Replies)
Hi Friends,
I have a single column data like below.
1
2
3
4
5
I need the output like below.
0
1
2
3
4
where each row (including first row) subtracting from first row and the result should print below like the way shown in output file.
Thanks
Sid (11 Replies)
I do have a large text file (tab delimited) of the following format
RT_1 34 67
RT_1 9 10
RT_1 98 56
RT_2 09 89
RT_2 23 45
RT_2 90 76
RT_3 98 21
RT_4 23 90
RT_4 67 90
RT_4 79 23
RT_5 8 9
I want to parse every first row (complete row), whenever a new value in column 1 (here... (2 Replies)
this is the requirement
list.txt
table1
table2
table3
testfile.txt
name#place#data#select * from table1
name2#place2#data2#select * from table 10 innerjoin table3
name2#place2#data2#select * from table 10
output
name place table1
name2 place table3
i tried using awk (7 Replies)
Discussion started by: vamsekumar
7 Replies
LEARN ABOUT PHP
sqlsrv_fetch
SQLSRV_FETCH(3)SQLSRV_FETCH(3)sqlsrv_fetch - Makes the next row in a result set available for readingSYNOPSIS
mixed sqlsrv_fetch (resource $stmt, [int $row], [int $offset])
DESCRIPTION
Makes the next row in a result set available for reading. Use sqlsrv_get_field(3) to read the fields of the row.
PARAMETERS
o $stmt
- A statement resource created by executing sqlsrv_query(3) or sqlsrv_execute(3).
o $row
- The row to be accessed. This parameter can only be used if the specified statement was prepared with a scrollable cursor. In
that case, this parameter can take on one of the following values:
oSQLSRV_SCROLL_NEXT
oSQLSRV_SCROLL_PRIOR
oSQLSRV_SCROLL_FIRST
oSQLSRV_SCROLL_LAST
oSQLSRV_SCROLL_ABSOLUTE
oSQLSRV_SCROLL_RELATIVE
o $offset
- Specifies the row to be accessed if the row parameter is set to SQLSRV_SCROLL_ABSOLUTE or SQLSRV_SCROLL_RELATIVE. Note that the
first row in a result set has index 0.
RETURN VALUES
Returns TRUE if the next row of a result set was successfully retrieved, FALSE if an error occurs, and NULL if there are no more rows in
the result set.
EXAMPLES
Example #1
sqlsrv_fetch(3) example
The following example demonstrates how to retrieve a row with sqlsrv_fetch(3) and get the row fields with sqlsrv_get_field(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true));
}
$sql = "SELECT Name, Comment
FROM Table_1
WHERE ReviewID=1";
$stmt = sqlsrv_query( $conn, $sql);
if( $stmt === false ) {
die( print_r( sqlsrv_errors(), true));
}
// Make the first (and in this case, only) row of the result set available for reading.
if( sqlsrv_fetch( $stmt ) === false) {
die( print_r( sqlsrv_errors(), true));
}
// Get the row fields. Field indeces start at 0 and must be retrieved in order.
// Retrieving row fields by name is not supported by sqlsrv_get_field.
$name = sqlsrv_get_field( $stmt, 0);
echo "$name: ";
$comment = sqlsrv_get_field( $stmt, 1);
echo $comment;
?>
SEE ALSO sqlsrv_get_field(3), sqlsrv_fetch_array(3), sqlsrv_fetch_object(3).
PHP Documentation Group SQLSRV_FETCH(3)