04-13-2009
Franklin, can you explain a little about why / how this works?
I'm a little lost.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking.
Something like this, through... (3 Replies)
Discussion started by: shilpa_acc
3 Replies
2. Shell Programming and Scripting
Hi all
I am new to scripting and i have an application from which i will export into a csv file as follows
Column1, Column2, Column3
Sno1, Folder\Test.txt, Fail
Sno2, Folder\Test1.txt, Pass
Sno3, Folder\Test2.txt, Fail
Now i need to change the column2 in all the rows from "Folder\"
... (1 Reply)
Discussion started by: rajeshrp
1 Replies
3. Web Development
Hi all,
I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows...
simple command like:
UPDATE set blah=foo where bar=XXX;
I will be running this on tables being written to and tables that have already been created.
... (3 Replies)
Discussion started by: muay_tb
3 Replies
4. Shell Programming and Scripting
I need to update a text file within a loop so that the value is added creating a new column at the end. I cannot use paste because I dont know the number of files. If I use >> the value is added after the last row. Please help.
For example:
Input file:
Column 1 Column2
- ... (2 Replies)
Discussion started by: Surabhi_so_mh
2 Replies
5. Shell Programming and Scripting
I have to update my file from server file.
Server file A on location
serverfile="/orf/ddl/plokall/fileA"
myfile=""/orf/ddl/plokall/myupdatedfile"
fileA:
KALKIKLOKPO001 10.1
HFJFKSLOKPO002 11.4
POLKAK5143 184.3
POLKJI5144 107.5
OKILDL5145 107.10
CVT0909 10.11
KJL0405... (3 Replies)
Discussion started by: asavaliya
3 Replies
6. Shell Programming and Scripting
I Have a file a.txt in the below format
1 23 50
1 25 6666666666666
1 23 34
If the third column value is greater than two digit then make it 0
New Data File
---------------
a.txt
1 23 50
1 25 0
1 23 34
Need your help regarding this (5 Replies)
Discussion started by: deep_kol
5 Replies
7. Programming
Hi,
I am using INFORMIX 8 and trying to update column value by apending '09' to existing record .
update sample_data_table set Name = Name||22 where id = 90 and state = NY
This worked fine in oracle Database,But throwing error in informix .
I need output as Ravi22 for Ravi record in... (0 Replies)
Discussion started by: Perlbaby
0 Replies
8. Shell Programming and Scripting
Hello,
I want to check the value of all MySQL columns.(column name is "status") via bash script.
If value is "0" at I want to make only single column value to "1"
I have many "0" values on mysql database(on "status" column)
"0" means it is a draft post. I want to publish a post. I... (2 Replies)
Discussion started by: tara123
2 Replies
9. Shell Programming and Scripting
Guys,
Running on Linux Ubuntu.
I need to find a method to automatically update all the rows for 2 columns and only if the rows not null.
e.g : based on the example data below, I want to update all rows under column 2 and 3 (COL2, COL3) with an increment of 1 and only if the value is not... (7 Replies)
Discussion started by: faizalms
7 Replies
10. Programming
Here is my select that I have to identify the child records that are Open (e.c7 < 6000) when the parent (t2068) c.c7 > 3
SELECT c.c1000000161,
c.c7,
c.c1000000019,
e.c1000000829
FROM
t2068 c INNER JOIN t1533 e ON e.c1000000829 = c.c301572100
where
c.c7 > 3... (2 Replies)
Discussion started by: newborndba
2 Replies
diction(1) General Commands Manual diction(1)
NAME
diction, explain, suggest - Prints wordy sentences and looks them up in an interactive thesaurus.
SYNOPSIS
diction [-fpattern_file] [-k] [-ma] [-me] [-ml] [-ms] [-n] [file...]
explain
suggest
The diction command finds all sentences in an English language document that contain phrases from a database of bad or wordy diction. The
explain command is an interactive thesaurus for the English language phrases found by the diction command and only for those phrases.
The diction command reads from standard in if no file operand is provided.
The suggest command is a synonym for explain.
OPTIONS
Names a user-created pattern file to be used in addition to the default file. Passes the -k option to the deroff command. The -k option
keeps blocks of text specified nroff by requests or macros; for example, the request. Passes the -ma option to deroff. The -ma option
interprets nroff man macros only. Overrides the default nroff -ms macro package. Causes deroff to skip lists; should be used if a docu-
ment contains many lists of nonsentences. Overrides the default nroff -ms macro package. Suppresses use of the default file (used with
-f). Only the user-created pattern file is used.
DESCRIPTION
Each phrase found by the diction command is enclosed in [ ] (brackets). Because diction runs deroff before looking at the text, include
formatting header files as part of the input.
Before using the explain command, use the diction command to obtain a list of poorly worded phrases. When you use the explain command, the
system prompts you for a phrase and responds with a grammatically acceptable alternative. You can continue typing phrases, or you can exit
by pressing the End-of-File key sequence.
The explain command can also take input redirected from a file. No other command line arguments are valid.
NOTES
Use of nonstandard formatting macros may cause incorrect sentence breaks. In particular, diction does not understand -me.
FILES
Default pattern file. Thesaurus used by the explain command.
SEE ALSO
Commands: deroff(1), nroff(1)
diction(1)