Sponsored Content
Top Forums UNIX for Dummies Questions & Answers how to capture no. of rows updated in update sql in unix db2 Post 302398354 by j_rymbei on Wednesday 24th of February 2010 10:27:21 AM
Old 02-24-2010
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 some details regarding this...

Rgrd..
JR
 

10 More Discussions You Might Find Interesting

1. 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" ... (1 Reply)
Discussion started by: jerardfjay
1 Replies

2. Shell Programming and Scripting

db2 commit for every 50 rows

I am writing a unix shell script for the archive purge job. During purging, the records will be deleted one by one. I didnot mention anything about db2 commit. By default, the records are commited one by one. Now I need to give commit for every 50 records deletion. The deletion part is as... (0 Replies)
Discussion started by: kmanivan82
0 Replies

3. Programming

db2 sql and Java Gui's

Hi Everyone, I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. Any advise / comments would be highly appreciated. Thanks. DBNAME ... (1 Reply)
Discussion started by: arizah
1 Replies

4. Shell Programming and Scripting

Help in executing the following db2 sql querry in unix

Hi All, Please help me out in executing the following db2 querry in unix db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
Discussion started by: dudd9
1 Replies

5. Shell Programming and Scripting

Need to capture error of sybase sql in unix

Hi Gurus, I am very new in Unix, I have 1 script, in which I am truncating the table , then BCP the data in Sybase table, and then loading the data from sybase table to sybase table. every thing is working fine, but the problem is with Error. I made some hanges in my insert statement so... (1 Reply)
Discussion started by: aksar
1 Replies

6. Shell Programming and Scripting

Capture rows for a column in file from delete sql -Oracle

Hi, This may not be the right forum but i am hoping someone knows an answer to this. I have to capture rows for a column that was deleted. How can i do that without having to write a select query? delete from myschema.mytable where currentdatetimestamp > columnDate this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies

7. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

8. Shell Programming and Scripting

UNIX Sqlplus - Capture the sql statement about to run and execution status

Greetings Experts, I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and... (4 Replies)
Discussion started by: chill3chee
4 Replies

9. Shell Programming and Scripting

Using Isql for SQL SERVER to get the table rows counts in UNIX shell script to

need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix) i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable. isql -v DSN USERNAME PASSWD ... (6 Replies)
Discussion started by: pimmit22043
6 Replies

10. Programming

DB2 Query -Convert multi values from column to rows

Hi Team I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows . For example : Column 1 Column2 Jan,Feb Hold,Sell,Buy Expected Result Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies
BOS_GETRESTART(8)					       AFS Command Reference						 BOS_GETRESTART(8)

NAME
bos_getrestart - Displays the automatic restart times for server processes SYNOPSIS
bos getrestart -server <machine name> [-cell <cell name>] [-noauth] [-localauth] [-help] bos getr -s <machine name> [-c <cell name>] [-n] [-l] [-h] DESCRIPTION
The bos getrestart command displays two restart times from the /etc/openafs/BosConfig file on the server machine named by the -server argument: o The general restart time at which the BOS Server process automatically restarts itself and all processes marked with status "Run" in the BosConfig file. The default is Sunday at 4:00 a.m. o The binary restart time at which the BOS Server automatically restarts any process for which the time stamp on the binary file in the /usr/lib/openafs directory is later than the last restart time for the process. The default is 5:00 a.m. Use the bos getdate command to list a binary file's timestamp, and the -long flag to the bos status command to display a process's most recent restart time. Use the bos setrestart command to set the restart times. OPTIONS
-server <machine name> Indicates the server machine for which to display the restart times. Identify the machine by IP address or its host name (either fully- qualified or abbreviated unambiguously). For details, see bos(8). -cell <cell name> Names the cell in which to run the command. Do not combine this argument with the -localauth flag. For more details, see bos(8). -noauth Assigns the unprivileged identity "anonymous" to the issuer. Do not combine this flag with the -localauth flag. For more details, see bos(8). -localauth Constructs a server ticket using a key from the local /etc/openafs/server/KeyFile file. The bos command interpreter presents the ticket to the BOS Server during mutual authentication. Do not combine this flag with the -cell or -noauth options. For more details, see bos(8). -help Prints the online help for this command. All other valid options are ignored. OUTPUT
The output consists of two lines: Server <machine_name> restarts at <time> Server <machine_name> restarts for new binaries at <time> Possible values for <time> include: o "never", indicating that the BOS Server never performs that type of restart. o "now", indicating that the BOS Server performs that type of restart only each time it restarts. o A specified day and time, indicating that the BOS Server performs that type of restart once per week. Example: "sun 4:00 am". o A specified time, indicating that the BOS Server performs that type of restart once per day. Examples: "11:00 pm", "3:00 am". EXAMPLES
The following example displays the restart times for the machine "db2.abc.com": % bos getrestart db2.abc.com Server db2.abc.com restarts at sun 4:00 am Server db2.abc.com restarts for new binaries at 2:15 am In the following example, the issuer abbreviates the machine name "fs1.abc.com" to "fs1", relying on the cell's name server to resolve the name. The output echoes the abbreviated form. % bos getrestart fs1 Server fs1 restarts at sat 5:00 am Server fs1 restarts for new binaries at 11:30 pm PRIVILEGE REQUIRED
None SEE ALSO
BosConfig(5), KeyFile(5), bos(8), bos_getdate(8), bos_setrestart(8), bos_status(8) COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved. This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell. OpenAFS 2012-03-26 BOS_GETRESTART(8)
All times are GMT -4. The time now is 08:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy