Sponsored Content
Top Forums UNIX for Dummies Questions & Answers finding out tables not used in scripts. Post 100781 by Vasundhara on Thursday 2nd of March 2006 01:35:09 AM
Old 03-02-2006
script to search for the contents of a file

Hi all,

Please see my requirement and post me asap.

Spool all the tables names into a file . Take each table name and check if it is present in any of the scripts in a directory using grep -il command. The script has to loop through the tables list and take each table and find it's presence in directory. After this exercise, we need to get the list of tables that not present in any of the scripts.

As I am beginner to this shell scripting, I have given the below logic for this to be done. Logic can be same , but I want a clean debugged script.
I am not able to use the variables properly. Please let me know how to use the variables in this case.

Script:

for i in all_tables.txt (this is the spooled file which contains the table names)

do

tbl= head -i all_tables.txt|tail -1

search=grep -il tbl *

if(test -z $search)

then echo ${tbl}>>unused (I wanted to created a file with all the tables which are not used in the scripts)

fi

done

Thanks
Vasundhara
Vasundhara
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

use shell scripts to update tables from databases

Hi I need to write a shell script that will access tables available on webpages and update a table on my webpage on a periodic basis. It will access, say for example a website that periodically update a table with certain quantities and update my table accordingly.it should have the flexibility... (0 Replies)
Discussion started by: wannabegeek
0 Replies

2. Shell Programming and Scripting

finding duplicate files by size and finding pattern matching and its count

Hi, I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern. Note:These are the samples of two files,but i can have more... (2 Replies)
Discussion started by: jerome Sukumar
2 Replies

3. Shell Programming and Scripting

Converting tables of row data into columns of tables

I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated. Input: test_data_1 1 2 90% 4 3 91% 5 4 90% 6 5 90% 9 6 90% test_data_2 3 5 92% 5 4 92% 7 3 93% 9 2 92% 1 1 92% ... Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies

4. Shell Programming and Scripting

Finding tables from each script

Hi, I just want to take each sql script from specified directory and print all tables in those sqls. Below is the script but getting an error lik ksh: 0403-057 Syntax error: `(' is not expected. Script is---- ls /ukdw/prd/working/TDMatrix/srualcb02/ukdw/prd/bin | awk '{printf("%s... (2 Replies)
Discussion started by: subrat
2 Replies

5. Shell Programming and Scripting

tables in scripts

Hi , I have two tables with same length t1 and t2, I want to cretae a new third table where i put the difference between the elements of t2 and t1, t3= t1 - t2 t3= t1 - t2 I am new to scripts, any help please? thanks (7 Replies)
Discussion started by: Celine19
7 Replies

6. Shell Programming and Scripting

Changing the Bash Scripts to Bourne Scripts:URGENT

Hi, I have to write a program to compute the checksums of files ./script.sh I wrote the program using bash and it took me forever since I am a beginner but it works very well. I'm getting so close to the deadline and I realised today that actually I have to use normal Bourne shell... (3 Replies)
Discussion started by: pgarg1989
3 Replies

7. Shell Programming and Scripting

KSH - How to call different scripts from master scripts based on a column in an Oracle table

Dear Members, I have a table REQUESTS in Oracle which has an attribute REQUEST_ACTION. The entries in REQUEST_ACTION are like, ME, MD, ND, NE etc. I would like to create a script which will will call other scripts based on the request action. Can we directly read from the REQUEST_ACTION... (2 Replies)
Discussion started by: Yoodit
2 Replies

8. Shell Programming and Scripting

[Solved] Finding a word in all shell scripts

Hi i have to find the shell script that contain the word PROC__TO_UPDATE SEARCH SHOULD BE INSENSITIVE AND SCRIPT CAN BE DEPLOYED IN ANY PATH. I am on Solaris. (27 Replies)
Discussion started by: rafa_fed2
27 Replies

9. Shell Programming and Scripting

Scripts for exporting backup from selected tables of Oracle DB

dear all please help me ! i need a script for exporting the selected tables of oracle database installed on CentOs. i waiting your response. thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies

10. UNIX for Advanced & Expert Users

Identify tables from Oracle sql scripts

Hi, Please let me know if you have any thoughts on how to read a table that has all the oracle sql files or shell scripts at the job and step level to identify all the tables that does merge, update, delete, insert, create, truncate, alter table (ALTER TABLE XYZ RENAME TO ABC) and call them out... (1 Reply)
Discussion started by: techmoris
1 Replies
Font::TTF::Ttc(3pm)					User Contributed Perl Documentation				       Font::TTF::Ttc(3pm)

NAME
Font::TTF::Ttc - Truetype Collection class DESCRIPTION
A TrueType collection is a collection of TrueType fonts in one file in which tables may be shared between different directories. In order to support this, the TTC introduces the concept of a table being shared by different TrueType fonts. This begs the question of what should happen to the ' PARENT' property of a particular table. It is made to point to the first directory object which refers to it. It is therefore up to the application to sort out any confusion. Confusion only occurs if shared tables require access to non-shared tables. This should not happen since the shared tables are dealing with glyph information only and the private tables are dealing with encoding and glyph identification. Thus the general direction is from identification to glyph and not the other way around (at least not without knowledge of the particular context). INSTANCE VARIABLES
The following instance variables are preceded by a space fname (P) Filename for this TrueType Collection INFILE (P) The filehandle of this collection The following instance variable does not start with a space directs An array of directories (Font::TTF::Font objects) for each sub-font in the directory METHODS
Font::TTF::Ttc->open($fname) Opens and reads the given filename as a TrueType Collection. Reading a collection involves reading each of the directories which go to make up the collection. $c->read Reads a Collection by reading all the directories in the collection $c->find($direct, $name, $check, $off, $len) Hunts around to see if a table with the given characteristics of name, checksum, offset and length has been associated with a directory earlier in the list. Actually on checks the offset since no two tables can share the same offset in a TrueType font, collection or otherwise. $c->DESTROY Closees any opened files by us BUGS
No known bugs, but then not ever executed! AUTHOR
Martin Hosken Martin_Hosken@sil.org. See Font::TTF::Font for copyright and licensing. perl v5.10.1 2009-01-21 Font::TTF::Ttc(3pm)
All times are GMT -4. The time now is 04:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy