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 all ,
I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment
example :
runsql.sh "1" "2"
sql :
updat tables_x set y=0
where
A=:x should subsituted by "1"
and
B=:y shuold subsituted bt "2"... (1 Reply)
Hi guyz,
Posting a thread after a long time.
I want to pass two variables to unix shell script from sql script.
Note: I am calling sql script from unix script. sql script has 2 variables one is the return code for status of program run and second one email flag. I don't know how to capture... (3 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
Hi Experts,
I want to call script_name.ksh as many time as id in customer table and also pass it as a parameter to script.
someting Like below.
for i in select id from customer
do
./script_name.ksh $i &
done
I have figured out how to have ID from customer but now how to call... (3 Replies)
Hi, hope everyone are fine. Please find my issue below, and I request your help in the same
In a configuration file, i have a variable defined as below
TEST = 'One','Two','Three'
I am trying to pass this variable in to a sql script which is define in a pl/sql block
as follows,
In the... (1 Reply)
Hi all,
I am executing shell script in which I am using SQLLDR
In this SQLLDR I am passing text file having PL/SQL script. This script will produce some formated output, this output I have to spool in another text file. Currently I have given this in script file as following
Spool... (2 Replies)
Hi,
My requirement is to load a LONG datatype data value from one table to another as direct access does not work (DB: ORACLE).
eg.
SELECT *FROM ALL_VIEWS WHERE TEXT LIKE '%<SEARCH_STRING>%';
As an alternate we are creating a table and trying to insert in it from ALL_VIEWS as direct insert... (2 Replies)
Discussion started by: sanjaydubey2006
2 Replies
LEARN ABOUT REDHAT
rhn_check
RHN_CHECK(8) Red Hat Network RHN_CHECK(8)NAME
rhn_check - check for queued actions on RHN and execute them
SYNOPSIS
/usr/sbin/rhn_check [-v] [--verbose]
DESCRIPTION
rhn_check is a client program that connects to the Red Hat Network backend servers and retrieves information associated with the queued
actions for this particular system. This script reads the digital server ID from /etc/sysconfig/rhn/systemid and uses that to identify the
machine to the Red Hat Network. Upon successfull authentication, rhn_check will start processing the queued actions sequentially.
ACTION TYPES
The following types of actions are currently processed by rhn_check:
action type description
() ()
refresh This action will refresh the hardware or software profiles of this
machine with Red Hat Network. This fucntion is called as
refresh(hardware) or refresh(rpmlist)
new_systemid This action is used by the RHn Backend to update the Digital
system ID of this machine with a new one.
update_packages This action will trigger rhn_check into running a package
update for a list of packages queued from the Red Hat Network.
rhn_check will use modules from the up2date client to download
the packages, solve dependencies and install the on the system.
FILES
/etc/sysconfig/rhn/systemid The digital server ID for this machine if the system has been registered onto Red Hat Network. This file does
not exist otherwise.
/var/spool/up2date This directory is used by up2date to store package headers and RPM packages downloaded from Red Hat Network
SEE ALSO
man pages for up2date(8) and rhnsd(8).
AUTHORS
Cristian Gafton <gafton@redhat.com>
Preston Brown <pbrown@redhat.com>
()