10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
Need your help again to get a best approach for the below scenario.
I am previously having one shell script which accepts request_id/s as the command line argument.
single req_id arg= 1111
Multiple arg= 1111,2222,3333
which gets passed to the embedded sql inside to... (9 Replies)
Discussion started by: Showdown
9 Replies
2. Shell Programming and Scripting
Hi all.
This is my first post on this forum. I've previously found great help in the huge knowledgebase that is here, but this time I have not been able to find a solution to my problem.
I have a large text file that looks like this:
typedef struct ABC_struct_nbr1_ {
char attr1; /*... (0 Replies)
Discussion started by: Yagi Uda
0 Replies
3. UNIX for Dummies Questions & Answers
Here is the requirement, When I run the "run file KSH (sql)", it should substitute
'${pCW_Bgn_DT}' with 201120
and
'${pCW_End_DT}' with 201124
Input File
----------
$ cat prevwk.dat
201124 20110711
run file KSH (sql)
------------------
In this file, I want to use the variables... (1 Reply)
Discussion started by: shanrice
1 Replies
4. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
5. Shell Programming and Scripting
Two things...
1) If I have an if statement that is true I want it to exit without running the rest of the file, but if it is false I want it to continue.. I just did
if ; then
exit
else
echo ""
fi
Can that work? I want it to exit if $1 is 0, and if not to continue running the rest of the... (1 Reply)
Discussion started by: glev2005
1 Replies
6. Shell Programming and Scripting
Hi,
I am using isql and putting the output in a file in a shell script in Linux.
However in my output i am getting the banner and a SQL prompt(at the start and the end of query output)
+---------------------------------------+
| Connected! |
| ... (6 Replies)
Discussion started by: lifzgud
6 Replies
7. UNIX for Dummies Questions & Answers
Hello Guys...
I want a small help from you guys.
Actually in Oracle, we are having a utlity called spool through which can store whatever SQL statements executed and other queries and the output of those queries in a file
So, similarly in Unix, if I start a session executing a number of Unix... (2 Replies)
Discussion started by: mraghunandanan
2 Replies
8. Shell Programming and Scripting
i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
Discussion started by: sw@pnil
1 Replies
9. Solaris
After dumping data from an Oracle database running on Solaris into a flat file, we need to run bcp and isql for MS SQL Server on the same Solaris box. Does Microsoft provide some tools that run on Unix?
Thanks for your assistance. (2 Replies)
Discussion started by: tomstone_98
2 Replies
10. Solaris
Hello,
On unix side, I have written below script for taking oracle db backup. But when I tried to execute it - i could not execute the sql statements from unix.
Please suggest
------------------------
$ more bkp.sh
#!/bin/ksh
# make sure database is shutdown cleanly
sqlplus '/ as sysdba'... (3 Replies)
Discussion started by: panchpan
3 Replies
oarnodesetting(1) OAR commands oarnodesetting(1)
NAME
oarnodesetting - Change the state and properties of a node in OAR.
SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]
DESCRIPTION
This command is used to Change the state and properties of a node in OAR.
OPTIONS
-a, --add
Add a new resource.
-s, --state STATE
Set the new state of the node. The available states are: Alive, Absent and Dead.
-m, --maintenance on/off
Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).
-h, --hostname HOSTNAME
Set the node hostname.
-r, --resource
Set the resource.
--sql
Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").
-p, --property "PROPERTY=VALUE"
Set the property of the node to the given value.
-n, --nowait
Do not wait for job ends when the node switches to Absent or Dead.
EXAMPLES
oarnodesetting -s Alive -h node012
oarnodesetting -s Absent -h node012
COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarnodesetting 2012-05-23 oarnodesetting(1)