How to read file names in the directory? Post: 302415992

Sponsored Content

Top Forums Shell Programming and Scripting How to read file names in the directory? Post 302415992 by pseudocoder on Saturday 24th of April 2010 06:16:48 AM

04-24-2010

Registered User

I think it's better doing it this way instead of calling sqlplus for each sql file:

autoload.sh

Code:

#!/bin/sh

# create runall.all file

touch runall.all
 
# copy paths to sql files in current directory in the runall.all file
# format: @/path/to/sql/file
 
for i in *.sql
do
echo "@`pwd`/$i" >> runall.all
done

# rename runall.all to runall.sql

mv runall.all runall.sql
 
# append "EXIT" to every sql file to avoid a hang

for i in *.sql
do
echo EXIT >> $i
done

# start sql

sqlplus uname/password@sid @`pwd`/runall.sql

Code:

$ ls
autoload.sh	load-002.sql	load-004.sql
load-001.sql	load-003.sql	load-005.sql
$ sh autoload.sh
sqlplus: not found
$ ls
autoload.sh	load-002.sql	load-004.sql	runall.sql
load-001.sql	load-003.sql	load-005.sql
$ cat runall.sql
@/usr/home/myuser/sql/load-001.sql
@/usr/home/myuser/sql/load-002.sql
@/usr/home/myuser/sql/load-003.sql
@/usr/home/myuser/sql/load-004.sql
@/usr/home/myuser/sql/load-005.sql
EXIT
$

HTH

pseudocoder

View Public Profile for pseudocoder

Find all posts by pseudocoder

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

File and Directory Names become hidden

Something very weird has been happening when I'm creating files and directories. When I create a directory, at times depending on the directory name and depth, it becomes hidden and can only be seen typing "ls -a". When I say the name of the directory matters, "my_c++" will be hidden but using...

2. Shell Programming and Scripting

directory names in a flat file

Hi, Consider a flat file abc.conf contains some rows. Each row contains the directory name with full path. now I want to find a particular file in every directory which are mentioned in the abc.conf file. How it can be done through unix shell script.

3. UNIX for Dummies Questions & Answers

Change All File Names in a Directory

Hi, If I have a directory full of say 100 random files, and I would like to organize them, for example: FILE001, FILE002, FILE003, FILE004, etc. How would I do this from Terminal, instead of manually changing each file? I'm using Mac OS X, if that makes a difference. Thank you in advance...

4. UNIX for Dummies Questions & Answers

How can I sort the file names in the directory

Hi , I have a list of files in the directory I want to sort based on the file name. But in the middle of filename contains the number based on that I need to sort.Could you suggest me on the same? Example filenames: /user1$ls RS.DEV.ISV.F1.RS.REFDATA.DATA...

5. Shell Programming and Scripting

Searching for file names in a directory while ignoring certain file names

Sun Solaris Unix Question Haven't been able to find any solution for this situation. Let's just say the file names listed below exist in a directory. I want the find command to find all files in this directory but at the same time I want to eliminate certain file names or files with certain...

6. Shell Programming and Scripting

Grepping file names, comparing them to a directory of files, and moving them into a new directory

got it figured out :)

7. UNIX for Dummies Questions & Answers

List Directory names which have the file

Hi All, Can any one help me to list out the directory names which contain the specified file. See for example File name : file.201307014.LKT Have the directory structure as below. /app/work/data/INDIA/file.201307014.LKT /app/work/data/AMERICA/file.201307014.KTP...

8. Shell Programming and Scripting

Compare file names on directory

Dears, Would you please help on following bash script: I want to get the most recent file named alfaYYYYMMDD.gz in one directory: for example: in directory /tmp/ ls -ltr alfa20130715.gz holding.gz alfa20130705.gz sart.txt merge.txt.gz alfa20130802.gz my result shoud be...

9. UNIX for Beginners Questions & Answers

Renaming the file names in a directory

Hi, I have about 60 files in a directory and need to rename those files. For example the file names are i_can_phone_yymmdd.txt (where yymmdd is the date. i.e 170420 etc) i_usa_phone_1_yymmdd.txt i_eng_phone_4_yymmdd.txt The new file names should be phone.txt phone_1.txt phone_4.txt I am...

LEARN ABOUT DEBIAN

oarresume

oarresume(1)							   OAR commands 						      oarresume(1)

NAME

       oarresume - resume a job in OAR batch scheduler.

SYNOPSIS

       oarresume [--array][job_ids][--sql "sql syntax"][-V][-h]

DESCRIPTION

       Ask OAR to change job_ids states into Waiting when it is Hold or in Running if it is Suspended.

OPTIONS

       --array
	   Resume array job(s) passed as parameter (all the sub-jobs of the given array job(s))

       --sql
	   Resume jobs which repond to the SQL where clause on the table jobs (ex: "project = 'p1'")

       -V, --version
	   Print OAR version number.

       -h, --help
	   Print help command message.

	   oarsub(1), oardel(1) oarstat(1), oarnodes(1), oarhold(1)

COPYRIGHTS

	Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

oarresume							    2012-05-23							      oarresume(1)