Output number of rows inserted, updated...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare two and write updated output in third file

Hi Linux Experts. I have a requirement where i need to update the thousands of table definitions to extend the column length and character set therefore i am looking for some sort of linux script which i can use to update the length and chacterset. I have two files In first file i have 7...

2. Shell Programming and Scripting

Number of rows loaded via sqlldr

Hi all, I'm loading data in database through sqlldr. I want to know the total record count And the number of records inserted in table.. what is the logic to achieve that. Thanks

3. Shell Programming and Scripting

Comparing two files to get only records to be inserted and updated

Hello all, Please help me for a script that compares two files and reads only those records that are to be inserted and updated. File1: c_id name place contact_no 1 abc xyz 34567 10 efg uvw 82725 6 hjk wth 01823 2 iuy ...

4. Shell Programming and Scripting

extracting number of rows

if > wc -l data.txt > 100 (meaning there are 100 rows) i want to assgn 100 as n so that if i do >echo n it would give me 100 Thanks

5. Shell Programming and Scripting

awk number rows from 1 to 3 in file

I have a file with the following format, i need to change de field9 each 3 rows to renumber field9 with gpo1, gpo2, gpo3. I need to use awk Original file field1 field2 field3 field4 field5 field6 field7 field8 gpo3 field1 field2 field3 field4 field5 ...

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. UNIX for Dummies Questions & Answers

how to capture no. of rows updated in update sql in unix db2

hi, i am a new user in unix..and we have unix db2. i want to capture the no. of rows updated by a update db2 sql statement and redirect into a log file. I've seen db2 -m...but not sure how the syntax should be. The update sql that I'm going to run is from a file... Can you please share...

8. Shell Programming and Scripting

Diff Command to return the number of lines inserted,deleted and changed.

Hello, I have to compare two files file1 and file2, retrieve the number of lines modified (added, deleted or modified) in file2. Output must be like: File2: Added Deleted Changed Total ------ ------- -------- ----- 2 1 1 4 Somebody...

9. Shell Programming and Scripting

How can i extarct the output from a file which has been updated from last half an hou

hi, I have a log file , which is appending with current data i need the extarct which is updated from last 30 minutes the format of the date is Jun 18, 2008 8:59:18 AM how can i subtract 30 mins from the current date thanks Tarun.

10. Shell Programming and Scripting

return number of rows selected

Hi all, i am doing a perl script to read from a db. I am able to retrieve the rows, but i am unable to return the number of rows selected. i tried $selectedrows = $sth->numrows; i got the error msg: Can't locate object method "numrows" via package "DBI::st" i changed it to $selectedrows =...

LEARN ABOUT REDHAT

update

UPDATE(7)							   SQL Commands 							 UPDATE(7)

NAME

       UPDATE - update rows of a table

SYNOPSIS

       UPDATE [ ONLY ] table SET col = expression [, ...]
	   [ FROM fromlist ]
	   [ WHERE condition ]

   INPUTS
       table  The name (optionally schema-qualified) of an existing table. If ONLY is specified, only that table is updated. If ONLY is not speci-
	      fied, the table and all its descendant tables (if any) are updated. * can be appended to the table name to indicate that	descendant
	      tables  are  to  be scanned, but in the current version, this is the default behavior. (In releases before 7.1, ONLY was the default
	      behavior.) The default can be altered by changing the SQL_INHERITANCE configuration option.

       column The name of a column in table.

       expression
	      A valid expression or value to assign to column.

       fromlist
	      A PostgreSQL non-standard extension to allow columns from other tables to appear in the WHERE condition.

       condition
	      Refer to the SELECT statement for a further description of the WHERE clause.

   OUTPUTS
       UPDATE #
	      Message returned if successful.  The # means the number of rows updated.	If # is 0 no rows are updated.

DESCRIPTION

       UPDATE changes the values of the columns specified for all rows which satisfy condition. Only the columns to be	modified  need	appear	as
       columns in the statement.

       Array  references use the same syntax found in SELECT [select(7)].  That is, either single array elements, a range of array elements or the
       entire array may be replaced with a single query.

       You must have write access to the table in order to modify it, as well as read access to any table whose values are mentioned in the  WHERE
       condition.

       By  default  UPDATE  will  update  tuples in the table specified and all its sub-tables. If you wish to only update the specific table men-
       tioned, you should use the ONLY clause.

USAGE

       Change word Drama with Dramatic on column kind:

       UPDATE films
       SET kind = 'Dramatic'
       WHERE kind = 'Drama';
       SELECT *
       FROM films
       WHERE kind = 'Dramatic' OR kind = 'Drama';

	code  |     title     | did | date_prod  |   kind   | len
       -------+---------------+-----+------------+----------+-------
	BL101 | The Third Man | 101 | 1949-12-23 | Dramatic | 01:44
	P_302 | Becket	      | 103 | 1964-02-03 | Dramatic | 02:28
	M_401 | War and Peace | 104 | 1967-02-12 | Dramatic | 05:57
	T_601 | Yojimbo       | 106 | 1961-06-16 | Dramatic | 01:50
	DA101 | Das Boot      | 110 | 1981-11-11 | Dramatic | 02:29

COMPATIBILITY

   SQL92
       SQL92 defines a different syntax for the positioned UPDATE statement:

       UPDATE table SET column = expression [, ...]
	   WHERE CURRENT OF cursor

       where cursor identifies an open cursor.

SQL - Language Statements					    2002-11-22								 UPDATE(7)

UNIX for Dummies Questions & Answers