Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
Hey Guys
from the below script what I understood is we are sending the the first parameter as input to the main (){} file
main > $LOGFILE 2>&1
but can we send two or three parameter as input to this main file as
main > $LOGFILE 2>&1 2>&2 like this
Can any one plz help I need to writ a... (0 Replies)
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Hi,
Currently i have a .sql file 1.sql.
I need to pass that as a parameter through a shell script to the sqlplus inside the same shell script.
How I should I do.can anyone help me pls.
I have an req where I need to send the .sql file and the place where the script has to create a .csv... (9 Replies)
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Why does this work
for myfile in `find . -name "R*VER" -mtime +1`
do
SHELLVAR=`grep ^err $myfile || echo "No error"`
ECHO $SHELLVAR
done
and outputs
No error
err ->BIST Login Fail 3922 err
No error
err ->IR Remote Key 1 3310 err
But... (2 Replies)
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT DEBIAN
bb-datepage.cgi
BB-DATEPAGE.CGI(1) General Commands Manual BB-DATEPAGE.CGI(1)NAME
bb-datepage.cgi - Xymon CGI script to view pre-built reports by date
SYNOPSIS
bb-datepage.cgi?type={day,week,month} --url=URLPREFIX [options]
DESCRIPTION
bb-datepage.cgi is invoked as a CGI script via the bb-datepage.sh CGI wrapper.
bb-datepage.cgi is passed a QUERY_STRING environment variable with the type of time-selection that is desired: Either "day", "week" or
"month" can be requested. It will then generate a web form with appropriate day/week/month selection boxes, and based on the users' selec-
tion a resulting url is built from the URLPREFIX and the time selection. The browser is then redirected to this URL.
The URL is constructed from the URLPREFIX, the type-parameter, the value of the "pagepath" or "host" cookie, and the users' selection as
follows:
type=day
The final URL is URLPREFIX/daily/YEAR/MONTH/DAY/PAGEPATH.
type=week
The final URL is URLPREFIX/weekly/YEAR/WEEK/PAGEPATH.
type=month
The final URL is URLPREFIX/monthly/YEAR/MONTH/PAGEPATH.
YEAR is the full year (4 digits, including century). MONTH is the two-digit number of the month (01..12). DAY is the number of the
day in the month (01..31). WEEK is the ISO 8601:1988 week-number (01..53). PAGEPATH is the current value of the "pagepath" cookie if
set; if it is not set but the "host" cookie is set, then this host is looked up in the bb-hosts file and the page where this host is
found is used for PAGEPATH. These two cookies are set by the default web-header templates supplied with Xymon.
OPTIONS --url=URLPREFIX
This specifies the initial part of the final URL. This option is required.
--hffile=FILENAME
Specifies the template files (from $BBHOME/web/) to use. The default is "--hffile=report".
--color=COLOR
Sets the background color of the generated webpage. The default is blue.
--env=FILENAME
Loads the environment defined in FILENAME before executing the CGI script.
--debug
Enables debugging output.
$BBHOME/web/report_form_daily
HTML form template for the date selection form when type=daily.
$BBHOME/web/report_form_weekly
HTML form template for the date selection form when type=weekly.
$BBHOME/web/report_form_monthly
HTML form template for the date selection form when type=monthly.
$BBHOME/web/report_header
HTML header file for the generated web page
$BBHOME/web/report_footer
HTML footer file for the generated web page
ENVIRONMENT VARIABLES
BBHOME Used to locate the template files for the generated web pages.
QUERY_STRING
Contains the parameters for the CGI script.
SEE ALSO bbgen(1), bb-hosts(5), hobbitserver.cfg(5)Xymon Version 4.2.3: 4 Feb 2009 BB-DATEPAGE.CGI(1)