05-03-2009
How to retrieve all the linked script files/ctl files/sql files?
Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux.
Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for sqlloader use), or sql files.
Previously we wanted to list all the used files one by one manually, but we found it is too tedious, and is error-prone.
So, i wanted to write a program which list and copy all the “useful" shell scripts/ctrl files/sql files.
But i am not sure how to do it.
Can anybody shed some light on this?
Thanks a lot!
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
How do I rdist a directory from one server to another, excluding soft and hard links?
current rdist syntax:
1 2 * * * cd /apps/oasis/prdsch/log; rdist -c j1*.log oasis@oastdby:/apps/schiller/oasis/prdsch/log
31 2 * * * cd /apps/oasis/prdsch/log; rdist -c oasis_bin_trans*.log... (6 Replies)
Discussion started by: captainzeb
6 Replies
2. UNIX for Advanced & Expert Users
Hi,
What is command in unix to find what are all the files linked with an executable binary.
Thanks in advance.
Rgds,
Omkumar (2 Replies)
Discussion started by: tc.omkumar
2 Replies
3. Shell Programming and Scripting
I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it.
Requirement: files are ftp to... (1 Reply)
Discussion started by: dba_nh
1 Replies
4. Shell Programming and Scripting
hi Friends,
Please help me in writing shell script to run list of sql files.
database is Oracle 9i,
unix os is solaris
Requirement is
1. sql file must take two inputs a)feed id and b)business date
2.shell script must out put .xls or .csvfile as out put without trimming any column name and... (1 Reply)
Discussion started by: balireddy_77
1 Replies
5. UNIX Desktop Questions & Answers
How can we find files that were soft linked to an original file and then the original has been deleted. these soft linked files won't then be accessible. How can we find orphan linked files?
Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies
6. UNIX for Dummies Questions & Answers
A perl script that displays the list of files which have multiple links..!
ls -l shows number of links in a field. (0 Replies)
Discussion started by: aadi_uni
0 Replies
7. Shell Programming and Scripting
Hi, We are having multiple .sql files generated programatically which is not containing..
create or replace -- at the start
and
/ -- at the end
We need to append those .sql files with the above 2 statements at their respective positions.
We will be really thankful to get responses... (6 Replies)
Discussion started by: Rami Reddy
6 Replies
8. Shell Programming and Scripting
Hello,
I want to use shell script to generate network files (I tried with python but its taking too long).
I have a list of nodes:
node.txt
LOC_Os11g37970
LOC_Os01g07760
LOC_Os03g19480
LOC_Os11g45740
LOC_Os06g08290
LOC_Os07g02800
I have an edge-list as well: edge.txt
Source_node ... (2 Replies)
Discussion started by: Sanchari
2 Replies
9. Shell Programming and Scripting
Hi,
I require help to complete below requirement through Linux Script.
I have a SQL query which shows two columns as output. One is Report Name and other is report path. Query return multiple rows. below is the output.
Report Name
Cotton Stock Report (Net Weight)- Customized
Output... (3 Replies)
Discussion started by: usman_oracle
3 Replies
10. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
LEARN ABOUT DEBIAN
cscope-indexer
cscope-indexer(1) General Commands Manual cscope-indexer(1)
NAME
cscope-indexer - Script to index files for cscope
SYNOPSIS
cscope-indexer [-v] [-f database_file] [-i list_file] [-l] [-r]
DESCRIPTION
This script generates a list of files to index (cscope.out), which is then (optionally) used to generate a cscope database. You can use
this script to just build a list of files, or it can be used to build a list and database. This script is not used to just build a data-
base (skipping the list of files step), as this can be simply done by just calling "cscope -b".
Normally, cscope will do its own indexing, but this script can be used to force indexing. This is useful if you need to recurse into sub-
directories, or have many files to index (you can run this script from a cron job, during the night). It is especially useful for large
projects, which can contstantly have source files added and deleted; by using this script, the changing sources files are automatically
handled.
Currently, any paths containing "/CVS/" or "/RCS/" are stripped out (ignored).
OPTIONS
-f database_file
Specifies the cscope database file (default: cscope.out).
-i list_file
Specifies the name of the file into which the list of files to index is placed (default: cscope.files).
-l Suppress the generation/updating of the cscope database file. Only a list of files is generated.
-r Recurse into subdirectories to locate files to index. Without this option, only the current directory is searched.
-v Be verbose. Output simple progress messages.
SEE ALSO
cscope(1)
AUTHOR
This manual page was written for the Debian GNU/Linux system by Robert Lemmen <robertle@semistable.com> (but may be used by others, of
course)
Script to index files for cscope 30. December 2002 cscope-indexer(1)