group="0023"
sqlplus -s $USER <<EOF 1>>$SBI_LOG/oracle_error.log
whenever sqlerror exit 1
set serveroutput off;
set echo off;
set termout off;
set linesize 600;
set line 1000;
set pagesize 5000;
set newpage 0;
set feedback off;
set trimspool on;
set trimout off;
set define off;
set verify off;
set escape off;
set colsep "|"
set doc off;
spool $SBI_LOG/$SPOOLFILE
@CREATE_SBI_LIST_GROUP.sql $group
spool off;
quit;
EOF
Please advice me what i am missing here.
Thanks
Amit
You turned off variable substitution (in red above).
Dear Friends,
Please help me to achieve the following:
I want to pass one parameter from Shell-script to Sql-script.
Example:
My ShellScript.sh is calling report.sql like this:
/bin/sqlplus /reports.sql
And
My report.sql is calling many Stored-Procedures like this:
exec... (0 Replies)
Hi,
I need to pass 4 parameters from Oracle Procedure to Unix Shell script..
procedure signature :-
UNIX Shell script:
Problem: 1. Suppose pdffile and pdfresult has Null values in Oracle procedures but unix shell will read parameters by spaces so
I am getting wrong parameters... (7 Replies)
Hi,
I am writing a wrapper script(wrap_script.sh) to one of the main scripts (main_script.sh)
The main script is executed as following:
./main_script.sh <LIST> <STARTDATE> <ENDDATE>
looks for a parameter which is a LIST(consists of different list names that need to be processed), START/END... (0 Replies)
There are 4 parameters that I have to pass from korn shell to sql script.
1) I have to check if $1 , $2 , $3 and $4 are null values or not .
How can I do that ?
2) Once its determined that these values are null (in the sense they are empty) how can I pass null values to sql script... (11 Replies)
Discussion started by: megha2525
11 Replies
6. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
Hi,
I have an XML file like the following...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ONDEMAND_JOB VERSION="5.1" LOCALE="en_US">
<IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (2 Replies)
Hi,
I have an XML file like the following...
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ONDEMAND_JOB VERSION="5.1" LOCALE="en_US">
<IMPORT_JOBSET TC_CONNECTION_NAME="default" ENVIRONMENT="PRD" USERNAME="Administrator" PASSWORD="AdminPassword" CALENDAR="Main Monthly Calendar"... (3 Replies)
I have written a script which will take input parameter as another script.
However, if the script passed as input parameter has parameters then this script doesn't work.
I have a script b.ksh which has 1 and 2 as parameters
I have a script c.ksh which has 3,4 and 5 as parameters
vi a.ksh... (1 Reply)
Discussion started by: Vee
1 Replies
LEARN ABOUT DEBIAN
snntpd
snntpd,v0.3.8(8) System Manager's Manual snntpd,v0.3.8(8)NAME
snntpd - small news server
SYNOPSIS
snntpd [-t timeout] [-P] [-S] [logger...]
DESCRIPTION
snntpd is a small news server. It needs to be run under inetd or tcpserver, as root or as the owner of /var/spool/sn. snntpd does not
fork into the background. It expects to read and write from and to the network on descriptors 0 and 1.
ARGUMENTS
logger... (usually /usr/bin/logger) is taken to be a logging program, and all log output is piped to it. If logger... is not specified,
log messages are directed to descriptor 2.
OPTIONS -t timeout
specifies how long snntpd should wait for input before it gives up and exits. timeout is in seconds and defaults to 600.
-P snntpd includes it's pid in log output.
-S Suppress NNTP greeting on startup. This is useful if you want to perform authentication before running snntpd, or want to provide
your own greeting, from a wrapper.
POSTING AND POSTING PERMISSIONS
Posts are usually handled externally by the /usr/sbin/SNPOST script, which is responsible for fine-grain posting control; handling of con-
trol messages; and the ultimate distribution of the posted article.
snntpd permits or denies posting in a very simple manner:
If /var/spool/sn/.nopost exists, posting is not allowed.
Otherwise, if the environment variable POSTING_OK is not set, posting is not allowed.
Otherwise if POSTING_OK is set (to the empty string), posting is generally allowed, and all POSTed articles are piped to the SNPOST script,
which has the final say in the matter. The value of $POSTING_OK is not currently used, but is reserved.
FILES
/var/spool/sn/.fifo
If this file exists, and is a fifo, snntpd will write the name of a newsgroup into it as that newsgroup becomes the current one. If
the fifo does not exist snntpd will not create it.
/var/spool/sn/.noservice
If this file exists, snntpd will display its first line and exit. If the file can't be read or is empty, a default message is dis-
played. This is useful for temporarily disabling the news server while you perform any maintenance.
/var/spool/sn/.nopost
See POSTING PERMISSIONS above.
/var/spool/sn/.SNPOST
If this script or program exists, it is invoked instead of SNPOST to accept a posted article.
/var/spool/sn/news.group.name/.nopost
These files really belong to SNPOST, and it is unfortunate that snntpd has to check for their existence to determine the posting
flag for the LIST command. See /usr/sbin/SNPOST.
/var/spool/sn/news.group.name/.info
If this file exists, its first line is taken as the description of that group for use with the LIST NEWSGROUPS command.
/var/spool/sn/news.group.name/.times
is a binary file containing entry times, to support the NEWNEWS command.
/var/spool/sn/news.group.name/.created
is an empty file retained for it's timestamp, to support the NEWGROUPS command.
SIGNALS
If snntpd catches SIGHUP, the files /var/spool/sn/{.fifo,.noservice,.nopost} (see below) are checked again, as they are during startup.
Other signals have default behaviour.
ENVIRONMENT VARIABLES
See also /usr/sbin/SNPOST for a list of environment variables exported by snntpd.
PATH The PATH must be set such that snntpd can find SNPOST in order to accept postings. If PATH does not include /usr/sbin, /usr/sbin
will be appended to it.
POSTING_OK
This variable helps determine the site-wide posting policy. See POSTING PERMISSIONS above.
TCPREMOTEIP
If this value is set, it is taken to be the dotted-quad IP address of the connecting client. If it is not set, snntpd attempts to
derive it for itself, and then set its value.
TCPLOCALIP
as above, but for the server's dotted-quad IP.
SNROOT If this is set and is not empty, the value is used everywhere in place of /var/spool/sn, the default news spool directory.
SEE ALSO snsend(8), /usr/sbin/SNPOST
N.B. Harold Tay snntpd,v0.3.8(8)