You need to enter the Oracle password (have sudo, ssh, or (yuk!) rsh set up to avoid that), and make sure you set your Oracle environment before running it.
I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job... (3 Replies)
I created a script to read a csv file with four columns. The script also saved values of each col in a arry.
In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file.
select Num from tableName
where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
query sql using shell script, is it possible?
my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script?
thanks in advance! (2 Replies)
Hi I'm looking to query a table on a database and then iterate over the results in a loop. I believe this is the last part of my script that I need (after finding out threads for passing variables to other scripts and calling functions in other scripts). I've searched the forums but the best... (8 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Hello Experts,
This sounds crazy, but one of my requirements is that if ID in 5th column in my input file (: separated) is not present in the oracle database table (say t_id) then this record should be skipped. I am using awk for all other requirements. So I was thinking if this requirement... (4 Replies)
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies
LEARN ABOUT SUSE
sys
SYS(1) AFS Command Reference SYS(1)NAME
sys - Reports the compile-time CPU/operating system type
SYNOPSIS
sys
DESCRIPTION
The sys command displays the string set at compile time that indicates the local machine's CPU/operating system (OS) type, conventionally
called the sysname. This string is the default for the value stored in kernel memory. The Cache Manager substitutes this string for the
@sys variable which can occur in AFS pathnames; the OpenAFS Quick Start Guide and OpenAFS Administration Guide explain how using @sys can
simplify cell configuration.
To set a new value in kernel memory, use the fs sysname command. To view the current value set in the kernel, use either fs sysname or
livesys.
CAUTIONS
You almost always want to use livesys rather than this command. The sys command displays a single value hard-coded at compile time. It
does not query the Cache Manager for the current value and it does not report sysname lists. If you have changed the local system type
with fs sysname, or if you run a version of sys compiled differently than the Cache Manager running on the system, the value returned will
not match the behavior of the Cache Manager. The only reason to use sys is that livesys wasn't available in older versions of AFS.
OUTPUT
The machine's system type appears as a text string:
I<system_type>
EXAMPLES
The following example shows the output produced on a Sun SPARCStation running Solaris 5.7:
% sys
sun4x_57
PRIVILEGE REQUIRED
None
SEE ALSO fs_sysname(1), livesys(1)
The OpenAFS Quick Start Guides at <http://docs.openafs.org/>.
The OpenAFS Administration Guide at <http://docs.openafs.org/AdminGuide/>.
COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 SYS(1)