11-11-2010
Hi VBE,
can you please show me exact way.
Much appreciated..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I search all post...and no soluation about..if i would like to run a sql statement and output the result to txt file.
for example,
i usually run "sql" to logon the database and run select statement. Then I need to copy the output into the result.txt. Can I run the script to do this... (7 Replies)
Discussion started by: happyv
7 Replies
2. Shell Programming and Scripting
Hi ,
I just found you while surfing for the string
'Redirecting sql select query output from within a shell script to txt file/excel file'
Could you find time sending me the code for the above question?
It'll be great help for me.
I have a perl file that calls the sql file... (1 Reply)
Discussion started by: dolphin123
1 Replies
3. Shell Programming and Scripting
Hi Yogesh,
Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel"
I tried creating a simple text file to get the query output, but the... (1 Reply)
Discussion started by: dolphin123
1 Replies
4. Shell Programming and Scripting
Hi All,
I want to format the result driven from the query into neat format.
For example pls find the below code,
#! /bin/sh
result='
sqlplus -s uname/passwrd@DBname
select no,name,address,ph_no, passport_no,salary,designation
from emp_table where salary>1000;
exit
EOF'
... (8 Replies)
Discussion started by: little_wonder
8 Replies
5. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
6. Shell Programming and Scripting
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Discussion started by: Himanshu_soni
7 Replies
7. Shell Programming and Scripting
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Discussion started by: juzz4fun
13 Replies
8. Shell Programming and Scripting
How to Get SQL query result to file in putty?
I have one SQL query and I want that query output to be redirected to the file.
uname -a
SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R
Please suggest. (7 Replies)
Discussion started by: pamu
7 Replies
9. Programming
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Discussion started by: Lord Spectre
5 Replies
10. UNIX for Beginners Questions & Answers
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LEARN ABOUT DEBIAN
notmuch-search
NOTMUCH-SEARCH(1) General Commands Manual NOTMUCH-SEARCH(1)
NAME
notmuch-search - Search for messages matching the given search terms.
SYNOPSIS
notmuch search [options...] <search-term>...
DESCRIPTION
Search for messages matching the given search terms, and display as results the threads containing the matched messages.
The output consists of one line per thread, giving a thread ID, the date of the newest (or oldest, depending on the sort option) matched
message in the thread, the number of matched messages and total messages in the thread, the names of all participants in the thread, and
the subject of the newest (or oldest) message.
See notmuch-search-terms(7) for details of the supported syntax for <search-terms>.
Supported options for search include
--format=(json|text)
Presents the results in either JSON or plain-text (default).
--output=(summary|threads|messages|files|tags)
summary
Output a summary of each thread with any message matching the search terms. The summary includes the thread ID, date, the num-
ber of messages in the thread (both the number matched and the total number), the authors of the thread and the subject.
threads
Output the thread IDs of all threads with any message matching the search terms, either one per line (--format=text) or as a
JSON array (--format=json).
messages
Output the message IDs of all messages matching the search terms, either one per line (--format=text) or as a JSON array
(--format=json).
files
Output the filenames of all messages matching the search terms, either one per line (--format=text) or as a JSON array (--for-
mat=json).
tags
Output all tags that appear on any message matching the search terms, either one per line (--format=text) or as a JSON array
(--format=json).
--sort=(newest-first|oldest-first)
This option can be used to present results in either chronological order (oldest-first) or reverse chronological order (new-
est-first).
Note: The thread order will be distinct between these two options (beyond being simply reversed). When sorting by oldest-first the
threads will be sorted by the oldest message in each thread, but when sorting by newest-first the threads will be sorted by the
newest message in each thread.
By default, results will be displayed in reverse chronological order, (that is, the newest results will be displayed first).
--offset=[-]N
Skip displaying the first N results. With the leading '-', start at the Nth result from the end.
--limit=N
Limit the number of displayed results to N.
--exclude=(true|false|flag)
Specify whether to omit messages matching search.tag_exclude from the search results (the default) or not. The extra option flag
only has an effect when --output=summary In this case all matching threads are returned but the "match count" is the number of
matching non-excluded messages in the thread.
SEE ALSO
notmuch(1), notmuch-config(1), notmuch-count(1), notmuch-dump(1), notmuch-hooks(5), notmuch-new(1), notmuch-reply(1), notmuch-restore(1),
notmuch-search-terms(7), notmuch-show(1), notmuch-tag(1)
Notmuch 0.13.2 2012-06-01 NOTMUCH-SEARCH(1)