Unable to set variables in Linux script Post: 302503200

Sponsored Content

Top Forums Shell Programming and Scripting Unable to set variables in Linux script Post 302503200 by smr.ryl on Wednesday 9th of March 2011 11:09:33 PM

03-10-2011

Registered User

Yes Johnson I have written this script in windows editor and then moved on to linux server. Thanks Johnson!! I removed carriage returns and it worked.

Also I am trying to spool data from oracle to a file, but along with data sql query and other stuff is also spooling, can you please help me to spool only data into the file.

my script has :

Code:

`sqlplus $crdn<<END >$sfile
set def off;
set echo off
SPOOL $sqfile
set pagesize 10  head off linesize 165
select CTRL_FILE_NM||' '||LND_TBL_NM||' '||FEED_CD||' '||DOWNLOAD_DIR from DIM_INV_DETL where FEED_NM='${feednm}';
SPOOL OFF
exit;
END`

spool file:

Code:

SQL> set pagesize 10  head off linesize 165
SQL> select CTRL_FILE_NM||' '||LND_TBL_NM||' '||FEED_CD||' '||DOWNLOAD_DIR from DIM_INV_DETL where FEED_NM='ERO140I.P.ICGFLEX';
CNTRL2.CTL LND_PP_2 ERO140I /opt/rectify/fasttrac/AML/transform/AGU065D/                                                                                     
SQL> SPOOL OFF

Thanks in advance.

Last edited by Franklin52; 03-10-2011 at 03:42 AM.. Reason: Please use code tags

smr.ryl

View Public Profile for smr.ryl

Find all posts by smr.ryl

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to set up linux environment variables?

Hi I'm using Linux, in the directory /root/my there is a.out. but when I try to run it , the shell indicate "bash:a.out: command not found" but I AM working in this directory. if I use "./a.out" , it works perfectly. can any body tell me how to do a permanent set up so that I can use...

2. UNIX for Dummies Questions & Answers

Using Variables to Set Other Variables

I have a script that I'm trying to shorten (below) by removing repetitive code. if ] then commodity_ndm_done=Y fi if ] then customer_ndm_done=Y fi if ] then department_ndm_done=Y fi if ] then division_ndm_done=Y fi

3. Shell Programming and Scripting

Ksh script - Design ? - Search file and set variables

Hi - I'm trying to think of a clever way to write a shell script (trying to stay w/ ksh as that's what I know the best...) that will resolve the following problem: Problem - On a daily basis I have to email folks who are on-call to remind them. I was hoping to script this out so I could have...

4. Linux

DNS unable to set up!!

Hi Experts, I am a newbie like in Linux world, practising Fedora Linux on VMWare but DNS is never set up: Below are my conf files: 1. named.conf options { directory "/var/named"; /* * If there is a firewall between you and nameservers you want * to talk...

5. Programming

How to convert byteArray variables to HexaString variables for Linux?

Hello everybody, I am having problem in converting byte array variables to Hexa String variables for Linux. I have done, converting byte array variables to Hexa String variables for Windows but same function doesn't work for linux. Is there any difference in OS ? The code for Windows is given...

6. Shell Programming and Scripting

Unable to set a data to array

Hi All, Iam trying to set the value to the array... Still its not happening Following is the code: #!/usr/bin/ksh filenames="x"; filenames="y"; echo $filenames; echo $filenames; O/P: x x Iam expecting

7. Shell Programming and Scripting

Unable to change environment variables in bash script

Hello! For the moment some settings in my .bashrc contain the password of my company's firewall, which is not a good idea. I would like to use the string "PASSWORD" set in .bashrc and a script that changes all appearances of "PASSWORD" in the environment variables by the actual password (which...

8. Shell Programming and Scripting

Unable to set my PATH variable

Hello All, Hope you can understand my problem from the below code. $ cat ~/.profile PS1=`whoami`@`hostname`':$PWD $ ' export PATH="$PATH:.:/logarchive/utility/util:/usr/sbin:" $ echo $PATH /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:.:/usr/sbin: $ echo $SHELL /usr/bin/ksh ...

9. Shell Programming and Scripting

<< Environmental Variables are not set when script completes >>

Hi Team, I have a wrapper script which i have pasted below, it internally calls one python script to generate Environmental in a file called /home/oracle/myenv.sh, when i execute this script via wrapper script, its not reflecting in my current session, still showing old env variables. any...

10. Linux

Unable to set static ip address

Hi All, Am using centos 7 in my vmware workstatio with the bridged network. when run the ifconfig cmd its not at all showing the ip address and pls advise how to set static ip address in my linux box.

LEARN ABOUT HPUX

pollrcvd

POLLRCVD(8)						      System Manager's Manual						       POLLRCVD(8)

NAME

       pollrcvd - HylaFAX script for delivering facsimile received by polling

SYNOPSIS

       /var/spool/hylafax/bin/pollrcvd mailaddr faxfile devid commid error-msg

DESCRIPTION

       bin/pollrcvd  is the command script invoked by the HylaFAX server whenever a facsimile is received as a result of a polling operation.  The
       default script uses electronic mail to deliver the facsimile to the user that submitted the poll request, and can be controlled by  editing
       the etc/PollDispatch shell script in the spooling area that is sourced by pollrcvd when it runs.  The arguments are:

       mailaddr  the electronic mail address of the user that submitted the poll request.

       faxfile	 the pathname of the received TIFF file relative to the root of the spooling hierarchy.

       commid	 The communication identifier associated with the call (used to include a transcript when an error occurs).

       devid	 the modem device on which the document was received.

       error-msg an error message that is non-null if an error was encountered during the receive operation.

NOTES

       The default script delivers facsimile as PostScript wrapped in MIME.

FILES

       /var/spool/hylafax   spooling area
       /usr/sbin/faxinfo    for printing information about the facsimile
       /usr/bin/fax2ps	    for converting TIFF to PostScript
       /usr/lib/sendmail    for delivering mail

SEE ALSO

       faxq(8), hylafax-server(5), recvq(5)

								   May 12, 1996 						       POLLRCVD(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how to set up linux environment variables?

Discussion started by: dell9

2. UNIX for Dummies Questions & Answers

Using Variables to Set Other Variables

Discussion started by: superdelic

3. Shell Programming and Scripting

Ksh script - Design ? - Search file and set variables

Discussion started by: littlefrog

4. Linux

DNS unable to set up!!

Discussion started by: vikasdh