Learning SQL - suggestions Post: 302477370

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Backup Suggestions.

Hi all, Have two SCO 5.0.5 systems and one Slackware(joy?) system. I've been asked to backup all three systems onto a newly acquired AIT Tape drive that we've installed on one of the SCO boxes. Using the existing cpio backup script on the one SCO works a treat and is really fast (which is...

2. UNIX for Advanced & Expert Users

Looking for Suggestions...

We run WebSphere and by default it wants to install everything under /usr. While I can understand the default (everyone has a /usr) I would like to move this over to a dedicated volume group called apps and then setup my lv's and fs's here. Our WebSphere Admin doesn't like this because apparently...

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

4. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

5. UNIX for Advanced & Expert Users

Need suggestions.......

Hello there....i am a final year comp science student.......i am thinking of doing my project on unix platform......which one do u suggest?thanx in advance...

6. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;...

7. AIX

AIX learning path: suggestions

Hello, Am fresher to AIX domain but trained in RHEL 5. I want to go for AIX certifications in future and very much eager to learn AIX from basics.Kindly provide me the guides or the links or the books for study. What are the recent IBM AIX certifications in the market as of today and their...

8. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

9. UNIX for Dummies Questions & Answers

Suggestions for the interview

Hi guys, i'm undergoing a traning in solaris administration and i request if any one have an idea on the interview questions on solaris. thank you.

10. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to...

LEARN ABOUT DEBIAN

oarnodesetting

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)

10 More Discussions You Might Find Interesting

1. Filesystems, Disks and Memory

Backup Suggestions.

Discussion started by: Cameron

2. UNIX for Advanced & Expert Users

Looking for Suggestions...

Discussion started by: scottsl

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

4. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Discussion started by: reptile