Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Running a select script through UNIX and sending output to file
Top Forums Shell Programming and Scripting Running a select script through UNIX and sending output to file Post 302513514 by Corona688 on Wednesday 13th of April 2011 12:01:38 PM
Old 04-13-2011
Quote:
Originally Posted by dbchud
*Thinking about it, guess the CD and Oracle_Home bits at the start are probably cocking it up.
I don't think the cd will stop it from working.

The export won't hurt it, but I don't think it's doing what you wanted either. If ORACLE_HOME wasn't set to anything, exporting it won't figure out the right value for you. Exporting a blank ORACLE_HOME variable won't actually help Oracle find its home. Smilie

Instead do:
Code:
ORACLE_HOME=/correct/path/to/oracle/stuff
export ORACLE_HOME

Also: You're still putting that in a variable for no benefit. How about using the code directly, instead of cramming it into a variable?

You also haven't moved the last 'selectupdate' to the beginning of the line. It absolutely HAS to be at the beginning of the line, no tabs, no spaces, no nothing.

Code:
cd <wherever>
ORACLE_HOME=/path/to/oracle/stuff/
export ORACLE_HOME

sqlplus -r u/p@sid <<selectupdate
spool <some dir>/selectupdateX.txt
@<script>.sql;
selectupdate

This User Gave Thanks to Corona688 For This Post:
dbchud
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sending mail from Unix - For html output

I have automated some checks - and I want to send a email when there is an issue. This is fine and I can send the email. However - I want to generate the email in html format so I can highlight any issues to a reader.. ie. If there is a disk space issue - then the email will highlight the... (2 Replies)
Discussion started by: frustrated1
2 Replies

2. Windows & DOS: Issues & Discussions

Want to use the output of Select statement in Unix script

Hi, I have a UNIX script which calls SQL Select statement: Now i want to use the output of that select statement within my UNIX script so as to call different shell script depending upon the output of the select statement. Can anyone help me in this regard. TIA Akhil Goel (4 Replies)
Discussion started by: akhilgoel9
4 Replies

3. Shell Programming and Scripting

FTP script for sending a file from one unix directory to another unix server director

Hi, My local server is :/usr/abcd/ Remote server is :/Usr/host/test/ I want to send files from local unix directory(All files starting with O_999) to remote host unix directory. Can any body give me the Unix Shell script to do this. One more doubt: Shall we need to change the file... (1 Reply)
Discussion started by: raja_1234
1 Replies

4. Shell Programming and Scripting

Running a shell script in cron...email not sending - help??

I am pretty new to Unix shell scripting, but wondered if anyone could help (in layman's terms if possible!!) :) I have a shell script which ultimately sends an alert to an email address if part of a batch of programs fails. Here's the script that sends the email: Script: 6check.csh... (8 Replies)
Discussion started by: tjhorwood
8 Replies

5. Shell Programming and Scripting

output file of the shell script running through crontab is deleting automatical daily.

Dear Friends, I am working on IBM AIX. I have written one script and kept in the crontab as to run daily at 11:38 AM. and the output of the script to be appended to the file generated with the month name. but my file deleting daily and the new file is creating with the output of the shell... (2 Replies)
Discussion started by: innamuri.ravi
2 Replies

6. AIX

Sending script output as email

Hi i have a script which executes daily through cron. The output of the script is appended to a log file everyday It also emails me the output of the logfile as we have the mailx command in the script The below is my requirement : Normally When I get the email it sends the entire content... (3 Replies)
Discussion started by: newtoaixos
3 Replies

7. Shell Programming and Scripting

sql select command output formatting in shell script

Hi, I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification in short select var,data from usage; o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies

8. Shell Programming and Scripting

How to process select list of files and output to the same file?

Hi, I've a list of files ac_info.tps, subscription_array.tps, .......and many other files one of the file, bin_range_list.tps has the following content CREATE OR REPLACE TYPE "BIN_RANGE_LIST" AS TABLE OF BIN_RANGE_ELEM; / grant execute on... (4 Replies)
Discussion started by: jediwannabe
4 Replies

9. Shell Programming and Scripting

How to print the output of a select query using shell script?

HI, I want to connect to database and fetch the count from a table. The sql query is as below : select count(*) from table_test where test_column='read'; How can I print the output of this statement using shell script. Thanks in advance. (4 Replies)
Discussion started by: confused_info
4 Replies

10. Shell Programming and Scripting

Select command going to infinite loop after running the script

cd /opt/et/WAS/apps/8.0 find . -name "HostIntegration.properties" -o -name "HostSocket.properties" -o -name "environment.properties" 2> /dev/null | awk -F '' '{print $4}'|awk '!x++' | cat>/home/cbadmin/file1.txt cd /home/cbadmin/ PS3='Please enter a number from list of applications==>:' select... (3 Replies)
Discussion started by: bhas85
3 Replies

LEARN ABOUT SUNOS

asadmin-export

asadmin-export(1AS)						   User Commands					       asadmin-export(1AS)

NAME

       asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode

SYNOPSIS

       export  [ name=value  [ name=value]*]

       Marks  a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values
       as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable  name	is
       displayed.  If  the  export  command  is  used  without	any arguments, a list of all the exported variables and their values is displayed.
       Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and  set  as  exported  variables
       within asadmin. Unexported environment variables cannot be read by the asadmin utility.

OPERANDS

       name=value	       variable name and value for automatic export to the environment to be used by subsequent commands.

       Example 1: Using export to list the environment variables

       asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password
       asadmin> export AS_ADMIN_PREFIX=server1.jms-service
       asadmin> export //to list the environment variables that are set
       AS_ADMIN_HOST=bluestar
       AS_ADMIN_PORT=8000
       AS_ADMIN_USER=admin
       AS_ADMIN_PASSWORD=********
       AS_ADMIN_PREFIX=server1.jms-service

       Where:  the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host
       is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-unset(1AS), asadmin-multimode(1AS)

J2EE 1.4 SDK							    March 2004						       asadmin-export(1AS)
All times are GMT -4. The time now is 11:22 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy