11-11-2010
Would setting "spool" to a list file in your sql script not suffice?
Then of course you would have to extract what you want to append elsewhere...
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
WEDGED(8) System Manager's Manual WEDGED(8)
NAME
wedged - HylaFAX modem wedged script
SYNOPSIS
/var/spool/hylafax/bin/wedged devid device
DESCRIPTION
bin/wedged is the command script invoked by the facsimile server when a modem is deemed to be in an irreparable state and requires operator
intervention. This decision is based on the setting of the MaxSetupAttempts configuration parameter described in hylafax-config(5). The
default wedged script sends electronic mail to the FaxMaster alias. The interval at which emails are sent can be configured in the
etc/FaxDispatch file by setting the WEDGED_EMAIL_INTERVAL variable to the desired number of minutes (emails will be sent no more than every
WEDGED_EMAIL_INTERVAL minutes, until the wedged condition persists). If the variable WEDGED_DISABLE_FAXGETTY is set in etc/FaxDispatch
then the script will attempt to disable any faxgetty processes spawned by the init(8) process for the problematic modem. In addition the
faxq(8) process automatically disables use of the modem for servicing outbound jobs.
The devid argument is the identifier derived from the name of the modem's device file by substituting ``_'' characters for ``/'' charac-
ters; e.g. term_10 for /dev/term/10. The device argument is the name of the character special device associated with the modem.
If there exists an executable file /var/spool/hylafax/etc/resetmodem then that file will be executed upon execution of the wedged script in
an effort to recover the modem.
FILES
/usr/lib/sendmail for delivering mail
SEE ALSO
faxq(8), hylafax-config(5)
October 3, 1995 WEDGED(8)