return number of rows selected

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Reading and copying a selected rows

Dear All, I have a data file input.res like below. (Only six column shown here for example.) Sequence of first column starting from 1 to 148. Input file 1 Q0 9_August_2014_Entertainment2 0 20.14967806339729 BM25b1.0 1 Q0 13_October_2012_Page323 1 20.134224346765738 BM25b1.0 1 Q0...

2. Shell Programming and Scripting

Combine multiple rows based on selected column keys

Hello I want to collapse a file with multiple rows into consolidated lines of entries based on selected columns as the 'key'. Example: 1 2 3 Abc def ghi 1 2 3 jkl mno p qrts 6 9 0 mno def Abc 7 8 4 Abc mno mno abc 7 8 9 mno mno abc 7 8 9 mno j k So if columns 1, 2 and 3 are...

3. Shell Programming and Scripting

To extract selected rows

Hi, I have two files Input1.txt and Input2.txt and i need to have a output with selected lines starting with the values present in Input2.txt. For example: Input1.txt:...

4. Shell Programming and Scripting

Shell to remove a newline char from selected rows in a file.

Greetings! Can we automate the process of removing a newline char from selected rows in a fixed width file using a shell? Input is like abcd1234 xyzd1234 abcd a1b2c3d4 abcd1234 xyzd1234 xx abcd1234 Expected output - abcd1234xyzd1234 abcda1b2c3d4abcd1234xyzd1234 xxabcd1234 ...

5. UNIX for Dummies Questions & Answers

Remove a newline char from selected rows.

6. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ...

7. Shell Programming and Scripting

Return rows from Oracle package

I need help . I am not getting anything back from my setup. I have defined an oracle package which I am calling from within my sql call, but is returning no rows. If I run my sql from sqlplus works find, does not work whe I try to run from UNIX shell script My korn script test.ksh #!bin/ksh...

8. Shell Programming and Scripting

print selected rows with awk

Hi everybody: Could anybody tell me how I can print from a file a selected rows with awk. In my case I only want print in another file all the rows from NR=8 to NR=2459 and the increment each 8 times. I tried to this: awk '{for (i=8; i=2459; i+=8); NR==i}' file1 > file2 But doesn't...

9. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ...

10. Shell Programming and Scripting

Cutting rows after a selected point

I have a log file from which I want to cut out the ten lines assoictiated to my search requirment (cust_ref #). The cust_ref number will be on te first line and the update information will be on the following ten lines (which dosen't linking data to grep on). Using a script I would like to...

LEARN ABOUT PHP

db2_num_rows

DB2_NUM_ROWS(3) 							 1							   DB2_NUM_ROWS(3)

db2_num_rows - Returns the number of rows affected by an SQL statement

SYNOPSIS

       int db2_num_rows (resource  $stmt)

DESCRIPTION

	Returns the number of rows deleted, inserted, or updated by an SQL statement.

	To  determine  the  number  of	rows  that  will be returned by a SELECT statement, issue SELECT COUNT(*) with the same predicates as your
       intended SELECT statement and retrieve the value.

	If your application logic checks the number of rows returned by a SELECT statement and branches if the number of rows is 0, consider modi-
       fying  your  application  to  attempt  to  return  the  first row with one of db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_array(3), or
       db2_fetch_row(3), and branch if the fetch function returns FALSE.

       Note

	       If you issue a SELECT statement using a scrollable cursor, db2_num_rows(3) returns the number of rows returned by the SELECT state-
	      ment.  However,  the  overhead  associated with scrollable cursors significantly degrades the performance of your application, so if
	      this is the only reason you are considering using scrollable cursors, you should use a forward-only cursor and  either  call  SELECT
	      COUNT(*) or rely on the boolean return value of the fetch functions to achieve the equivalent functionality with much better perfor-
	      mance.

PARAMETERS

	      o $stmt
		- A valid stmt resource containing a result set.

RETURN VALUES

	Returns the number of rows affected by the last SQL statement issued by the specified statement handle.

PHP Documentation Group 													   DB2_NUM_ROWS(3)

Shell Programming and Scripting