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... (1 Reply)
Hi all,
I have list of two kind of files and I want to compare the rows and print the merged data by applying if condition.
First kind of file looks like:
and second kind of file looks like :
I want to print the rows present in second file followed by 3 more columns from first... (6 Replies)
there are 20 variables and I would like to delete the rows if 13th-20th columns are all NA.
Thank you!
FID IID aspirpre statihos fibrahos ocholhos arbhos betabhos alphbhos cacbhos diurehos numbcig.x toast1 toast2 toast3 toast4 ischoth1 ischoth2 ischoth3 ischoth4
101 101 1 1 1 1 1 2 1 2... (2 Replies)
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)
I have a file some thing like this:
GN Name=YWHAB;
RC TISSUE=Keratinocyte;
RC TISSUE=Thymus;
CC -!- FUNCTION: Adapter protein implicated in the regulation of a large
CC spectrum of both general and specialized signaling pathways
GN Name=YWHAE;
RC TISSUE=Liver;
RC ... (13 Replies)
Hi Friends,
Hope all is well.
I have an input file like this
a gene1 10
b gene1 2
c gene2 20
c gene3 10
d gene4 5
e gene5 6
Steps to reach output.
1. Print unique values of column1 as column of the matrix, which will be
a
b
c (5 Replies)
Hi Friends,
My input file
Gene1 10 20 0
Gene2 5 0 15
Gene3 10 10 10
Gene4 5 0 0
If there is a zero for any gene in any column, I don't want that column to be considered which reduces the denominator value during average.
Here is my output
Gene1 10 20 0 10
Gene2 5 0 15 10
Gene3... (5 Replies)
Hello all, I am working on a file like below:
site Date time value1 value2
0023 2014-01-01 00:00 32.0 23.7
0023 2014-01-01 01:00 38.0 29.9
0023 2014-01-01 02:00 85.0 26.6
0023 2014-01-01 03:00 34.0 25.3
0023 2014-01-01 04:00 37.0 23.8
0023 2014-01-01 05:00 80.0 20.3
0023 2014-01-01 06:00... (16 Replies)
I am trying to modify and understand an awk written by @Scrutinizer
The below awk will filter a list of 30,000 lines in the tab-delimited file. What I am having trouble with is adding a condition to SVTYPE=CNV
that will only print that line if CI=,0.95: portion in blue in file is <1.9.
The... (2 Replies)
Discussion started by: cmccabe
2 Replies
LEARN ABOUT REDHAT
grephistory
GREPHISTORY(1) General Commands Manual GREPHISTORY(1)NAME
grephistory - display file names from Usenet history file
SYNOPSIS
grephistory [ -e ] [ -f filename ] [ -h ] [ -i ] [ -l ] [ -n ] [ -q ] [ -s ] [ -t ] [ messageid ]
DESCRIPTION
Grephistory queries the dbz(3) index into the history(5) file for an article having a specified Message-ID or hash key of Message-ID.
If messageid cannot be found in the database, the program prints ``Not found'' and exits with a non-zero status. If messageid is in the
database, the program prints the token of the article and exits successfully.
OPTIONS -e If the ``-e'' flag is used, then grephistory will only print the filename of the token of an existing article.
-f To specify a different value for the history file and database, use the ``-f'' flag.
-h If the ``-h'' flag is used then the hash of the Message-ID will be printed regardless of its existense.
-i If the ``-i'' flag is used, then grephistory will read a list of Message-ID's on standard input, one per line. Leading and trailing
whitespace is ignored, as are any malformed lines. It will print on standard output those Message-ID's which are not found in the
history database. This flag is used in processing ``ihave'' control messages.
-l If the ``-l'' flag is used then the entire line from the history file will be displayed.
-n If no pathname exists, the program will print ``/dev/null'' and exit successfully. This can happen when an article has been can-
celed, or if it has been expired but its history is still retained. This is default behavior, which can be obtained by using the
``-n'' flag.
-q If the ``-q'' flag is used, then no message is displayed. The program will still exit with the appropriate exit status.
-s If the ``-s'' flag is used, then grephistory will read a similar list from its standard input. It will print on standard output a
list of filenames for each article that is still available. This flag is used in processing ``sendme'' control messages.
-t If the ``-t'' flag is used, then only the offset into the history text file is printed.
HISTORY
Written by Rich $alz <rsalz@uunet.uu.net> for InterNetNews. This is revision 1.6.2.1, dated 2000/08/17.
SEE ALSO dbz(3), history(5), inn.conf(5).
GREPHISTORY(1)