Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Send filename as variable in a shell script
Top Forums Shell Programming and Scripting Send filename as variable in a shell script Post 302505232 by neva on Wednesday 16th of March 2011 01:12:51 PM
Old 03-16-2011
Send filename as variable in a shell script
I am having some trouble with a shell script I am writing. In the program I pass the path of where certain file names exist. I then want to loop through each file name and pass it as a DATA variable when calling sqlldr for a control file. This is what I have:
Code:
 
ls $FILEPATH/${FILENAME}*.csv
 
ALLFILES='ls $FILEPATH/${FILENAME}*.csv'

if [ $? -ne 0 ]
then
  echo "\n    No inbound files to process"
  exit 1
fi
## Loop through each file and load to staging table 
for EACHFILE in $ALLFILES
do
TEMP_FILE=${EACHFILE}a
if [ $? -ne 0 ]
then
  echo "\n    Error"
else
  echo "\nCalling Control File"
sqlldr "$FCP_LOGIN" silent=feedback silent=header silent=partitions control=$CONTROLFILE data=$TEMP_FILE

This does NOT send the file name to the DATA variable and I receive an error message stating no file was found to process. Any ideas on what I'm doing wrong? Any help is greatly appreciated.
Last edited by vbe; 03-16-2011 at 02:17 PM.. Reason: use code tags please
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to send filename as variable in a shell script

Can we can pass the filename as variable in the shell script. Sending the filename as a parameter file, the shell script takes the filename, needs to replace the string containing the filename with the variable in the shell script. EX: test1.sh is the shell script and takes file1.csv as... (6 Replies)
Discussion started by: gthokala9
6 Replies

2. Shell Programming and Scripting

Shell script to use the last modified filename in a variable

Forgive me if this is a trivial question, but I haven't been able to find the answer to this. Basically I've got a list of files in a particular directory that have the general form t_*.dat. (I have other files in the same directory as well). Essentially what I want to do is obtain the name... (1 Reply)
Discussion started by: lost.identity
1 Replies

3. UNIX for Dummies Questions & Answers

How to send e-mail from shell script ( C shell )?

Hi , How to send e-mail from shell script ( C shell ) . Mailx command is not working ( It didn't giving error also ). Please help me (2 Replies)
Discussion started by: arukuku
2 Replies

4. Shell Programming and Scripting

Which shell script will call if i execute sh (without filename)?

Hi Friends, The below shell script is written by third party to create B2k_session_id.iam trying to execute this script.When i execute below script it is calling some other scripts.How to find which scripts is calling? . `execom commfunc.com` echo " $PRESENTATION_MODE " if then echo... (1 Reply)
Discussion started by: vadlamudy
1 Replies

5. Shell Programming and Scripting

Call a awk script with variable and input filename

HI, MY question is a very simple one: if i want to call an awk script with the input file name and also pass a variable value , then how to do it. #>awk -f my_script.awk -v variable=value my_inputfile.txt I can't do it like this. throws error: awk: my_script.awk:18:... (0 Replies)
Discussion started by: Onkar Banerjee
0 Replies

6. Shell Programming and Scripting

Shell script if [[ -L <filename> ]]

Hi Please describe about following condition if ] in shell script. Also please provide the link related all the flags which are applicable for if condition in Shell (4 Replies)
Discussion started by: munna_dude
4 Replies

7. Shell Programming and Scripting

Help shell script to list filename file_path

HI owner date and time and size of file in a row shell script to list filename file_path i have tried the below code present_dir=`pwd` dir=`dirname $0` list=`ls -lrt | awk {'print $9,$3,$6,$7,$8'}` size=`du -h` path=`cd $dir;pwd;` printf "$list" printf "$path" printf " $size" ... (4 Replies)
Discussion started by: abiram
4 Replies

8. Shell Programming and Scripting

How to sort the timestamp in the filename in shell script?

originally the shellscript #ln_file_name=`echo $ld_interface_date"_"${8}".csv"` #ln_file_name=`echo 201202011527_HL_HLTM1_B04A.csv` ln_file_name="*"`echo ${7}".csv"` get_file_list_1=$log_path"tm1_file_list.gfl1" cd ${source_path} echo "Try to find any file exist in the... (10 Replies)
Discussion started by: feilhk
10 Replies

9. Shell Programming and Scripting

Fetch the latest filename shell script

Hi I want to fetch the latest file form the list example example= filename RATE_STATE_SETUPS.20151222.ccyymmdd.hhmmss.txt File pick which have latest ccyymmdd.hhmmss list of file in directory are RATE_STATE_SETUPS.20151222.20151222.170101.txt... (5 Replies)
Discussion started by: MOHANP12
5 Replies

10. Shell Programming and Scripting

A shell script to run a script which don't get terminated and send a pattern from the output by mail

Hi Guys, I am very new to shell script and I need your help here to write a script. Actually, I have a script abc.sh which don't get terminated itself. So I need to design a script to run this script, save the output to a file, search for a given string in the output and if it exists send those... (11 Replies)
Discussion started by: Sambit Sahu
11 Replies

LEARN ABOUT CENTOS

tping

TPING(1)							   LAM COMMANDS 							  TPING(1)

NAME

       tping - Send echo messages to LAM nodes.

SYNOPSIS

       tping [-hv] [-c count] [-d delay] [-l length] nodes

OPTIONS

       -h	     Print the command help menu.

       -v	     Turn OFF verbose mode.

       -c count      Send count messages.

       -d delay      Delay delay seconds between each message.

       -l length     Each message is length bytes long.

DESCRIPTION

       The  tping  command  sends  messages  to,  and  collects replies from, a list of nodes, via the LAM echo server.  It is similar to the UNIX
       ping(8) command, and is used as a quick diagnosis of the LAM network.

       Unless options are specified, tping sends a 1 byte message an infinite number of times, displaying the roundtrip time of each message as it
       completes,  with  a delay of 1 second between roundtrips.  After the loop is broken (with keyboard interrupt, eg: ^C), tping prints statis-
       tics about all roundtrip messages.

EXAMPLES

       tping h
	   Echo messages to the local node.

       tping -v n7 -l 1000 -c 10
	   Echo 1000 byte messages to node 7.  Stay silent while working.  Stop after 10 roundtrips and report statistics.

BUGS

       There is no built-in timeout and tping will wait forever to receive an echo.  If no echo is received, due to a dead  link  or  node,  tping
       hangs.	Stop  the  process  with  a  keyboard suspend signal (eg: ^Z) and terminate LAM with lamhalt(1) or lamwipe(1) (although the use of
       lamwipe(1) is deprecated).

SEE ALSO

       lamhalt(1), lamwipe(1)

LAM 7.1.4							    July, 2007								  TPING(1)
All times are GMT -4. The time now is 01:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy