04-07-2009
Thanks R.T.
It is worked properly for me.
Cheers ,
gehlnar
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I would want to spool file for a database query, however by using crontab, the file is not spooled. Below shows my script:
ORACLE_HOME="/u01/oraprod/perpdb/10.1.0/db_1"
OUTFILE="/tmp/invalid.out"
FILE="$HOME/admin/scripts"
$ORACLE_HOME/bin/sqlplus -s "/as sysdba"... (0 Replies)
Discussion started by: *Jess*
0 Replies
2. Shell Programming and Scripting
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Discussion started by: hazno
0 Replies
3. Shell Programming and Scripting
I am running a query with contains blank spaces in between in the output. But when I open and read the file in UNIX i am not able to cursor the balnk spaces instead it is moving like tabs. Please help
suppose my query -
Select ' '||text from tab1;
the cursor should move to 1st and... (1 Reply)
Discussion started by: sbmk_design
1 Replies
4. Shell Programming and Scripting
Hello,
I have a file. its content are like below.
mdn:87439842
imsi:23082038203
Ctime:12082010 01:20:10
mdn:9324783783
imsi:402349823322
Ctime: 12072010 01:20:10
mdn:87439842
imsi:23082038203
Ctime: 23072010 01:20:10
mdn:87439842
imsi:23082038203
Ctime:18072010 01:20:10
mdn:87439842... (3 Replies)
Discussion started by: Sanket11
3 Replies
5. Shell Programming and Scripting
Good afternoon!
I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first.
I have poured some blood, sweat and tears into... (4 Replies)
Discussion started by: brianjb
4 Replies
6. UNIX for Dummies Questions & Answers
I was performing the wc -l operation in one data file the result is less when i was giving -nu on the view of the file.
while giving wc -l the count is 5023
after setting line numbers in view of file is giving 5024.
Can anyone help on this.... (5 Replies)
Discussion started by: abhii
5 Replies
7. UNIX for Dummies Questions & Answers
Following is the output of a command ran inside the script:
2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5... (8 Replies)
Discussion started by: Devendra Hupri
8 Replies
8. Shell Programming and Scripting
#! /bin/ksh
#] && . ./.profile 2>/dev/null
if test -f '.profile'; then . ./.profile; fi;
#. .profile
LOG_DIR=/app/rpx/jobs/scripts/just/logs
sendEmail()
{
pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7"
(
... (21 Replies)
Discussion started by: ankit.mca.aaidu
21 Replies
9. Solaris
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
Discussion started by: tharmendran
2 Replies
10. Shell Programming and Scripting
Hi Team,
below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1.
and i don't use count() in sql query... based on count, i need to fail the script.
No_of_step=`echo ${g_count} | wc -l`
function gf_count()
{
g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies
LEARN ABOUT OPENSOLARIS
scha_resourcetype_get
scha_resourcetype_get(1HA) Sun Cluster Commands scha_resourcetype_get(1HA)
NAME
scha_resourcetype_get - access resource type information
SYNOPSIS
scha_resourcetype_get -O optag -T type
DESCRIPTION
The scha_resourcetype_get command accesses information about a resource type that is registered with the Resource Group Manager (RGM).
Use this command in shell script implementations of the callback methods for resource types that represent services that are controlled by
the RGM. This command provides the same information as the scha_resourcetype_get(3HA) C function.
Information is output by this command to the standard output (stdout) in formatted strings, as described in the scha_cmds(1HA) man page.
Output is a string or several strings that are output on separate lines. You can store the output in shell variables. You can also parse
the output by using the awk(1) command or other shell commands for further use by the script.
You need solaris.cluster.resource.read RBAC authorization to use this command. See the rbac(5) man page.
Authorized users can issue privileged Sun Cluster commands on the command line from the pfsh(1), pfcsh(1), or pfksh(1) profile shell. A
profile shell is a special kind of shell that enables you to access privileged Sun Cluster commands that are assigned to the Sun Cluster
Commands rights profile. A profile shell is launched when you run su(1M) to assume a role. You can also use pfexec(1) to issue privileged
Sun Cluster commands.
OPTIONS
The following options are supported:
-O optag Indicates the information to be accessed.
Note -
optag options, such as API_VERSION and BOOT, are not case sensitive. You can use any combination of uppercase and lowercase
letters when you specify optag options.
The following optag values retrieve the corresponding resource type properties. The value of the named property of the
resource's type is output.
API_VERSION
BOOT
FAILOVER
FINI
INIT
INIT_NODES
INSTALLED_NODES
IS_LOGICAL_HOSTNAME
IS_SHARED_ADDRESS
MONITOR_CHECK
MONITOR_START
MONITOR_STOP
PKGLIST
POSTNET_STOP
PRENET_START
RESOURCE_LIST
RT_BASEDIR
RT_DESCRIPTION
RT_SYSTEM
RT_VERSION
SINGLE_INSTANCE
START
STOP
UPDATE
VALIDATE
-T type Is the name of a resource type that is registered for use by the RGM cluster facility.
EXIT STATUS
The following exit values are returned:
0 The command completed successfully.
nonzero An error occurred.
Failure error codes are described scha_calls(3HA).
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWscdev |
+-----------------------------+-----------------------------+
|Interface Stability |Stable |
+-----------------------------+-----------------------------+
SEE ALSO
awk(1), scha_cmds(1HA), scha_calls(3HA), scha_resourcetype_get(3HA), attributes(5), rt_properties(5)
Sun Cluster 3.2 31 May 2006 scha_resourcetype_get(1HA)