03-28-2013
Any Sample ksh script to validate all the database objects
Hi,
I need a sample script to validate all the database objects like
1. table structure(columns, datatypes,key contraints if any)
2. synonyms
3. grants
4. indexes
....etc
thank you!
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi everybody,
Does somebody has a sample of script that control a daemon?
for example use loop until the daemon is on and if is not on
do something else?
Thanks
Pier (0 Replies)
Discussion started by: pierrelaval
0 Replies
2. Shell Programming and Scripting
Hi All,
I need to convert the data from excel to database table in sybase. Please provide some sample script..
thanks,
Royal. (1 Reply)
Discussion started by: royal9482
1 Replies
3. Shell Programming and Scripting
Hi all:
Trying to count the number of oracle instances on HPUX 11.23 - using ksh. I have multiple instances running and I would like to have a count for how many processes for each instance. Example, run the 'ps -efu oracle' command and for each instance increment a counter. So I am looking for... (4 Replies)
Discussion started by: raggmopp
4 Replies
4. Shell Programming and Scripting
how do i validate xml agaist xsd is ksh? (1 Reply)
Discussion started by: LiorAmitai
1 Replies
5. Shell Programming and Scripting
Hi All,
I want to validate the Production Database password at the time of login through script. If incorrect password entererd by the user, the script will ask again for the password.
Below is the sample of my script...
#########################
# Unix Code Starts here #... (6 Replies)
Discussion started by: saps19
6 Replies
6. Shell Programming and Scripting
Hello, I'm new to this forum, and I apologize in advance if I did something wrong here.
I am pretty stumped here as I am still getting the error message, "./comc1.sh: test: argument expected." after executing the script itself.
Here's the script file I modified:
I tried executing line 4... (1 Reply)
Discussion started by: ConcealedKnight
1 Replies
7. Shell Programming and Scripting
hi all, I need some help in regards of how to process just a sample from a large .txt file
I have a large file from many new lines (say above 200.000 new lines), I need a script that process just a sample of it, say 10.000 bur a random sample (taking rows from top top to the the bottom)
... (4 Replies)
Discussion started by: c_lady
4 Replies
8. Shell Programming and Scripting
Below is the code. Its the 1st line of a file.
How can I remove the bracket and display like below.
123 web int 1 09:30:45 2013
I dont want to use AWK or SED or PERL. I need to use only the bash shell scripting commands to do it. (3 Replies)
Discussion started by: ghosh_tanmoy
3 Replies
9. UNIX for Beginners Questions & Answers
Sample shell script to add a user:
Today i learn how to add a user to linux server with a password.
#!/bin/bash
# Script to add a user to Linux system
if ; then
read -p "Enter username : " username
read -s -p "Enter password : " password
egrep "^$username" /etc/passwd >/dev/null
if ;... (0 Replies)
Discussion started by: ulaxmi
0 Replies
LEARN ABOUT DEBIAN
alzabo::index
Alzabo::Index(3pm) User Contributed Perl Documentation Alzabo::Index(3pm)
NAME
Alzabo::Index - Index objects
SYNOPSIS
foreach my $i ($table->indexes)
{
foreach my $c ($i->columns)
{
print $c->name;
print '(' . $i->prefix($c) . ')' if $i->prefix($c);
}
}
DESCRIPTION
This object represents an index on a table. Indexes consist of columns and optional prefixes for each column. The prefix specifies how
many characters of the columns should be indexes (the first X chars). Some RDBMS's do not have a concept of index prefixes. Not all col-
umn types are likely to allow prefixes though this depends on the RDBMS. The order of the columns is significant.
METHODS
columns
Returns an ordered list of the "Alzabo::Column" objects that are being indexed.
prefix ("Alzabo::Column" object)
A column prefix is, to the best of my knowledge, a MySQL specific concept, and as such cannot be set when using an RDBMSRules module for a
different RDBMS. However, it is important enough for MySQL to have the functionality be present. It allows you to specify that the index
should only look at a certain portion of a field (the first N characters). This prefix is required to index any sort of BLOB column in
MySQL.
This method returns the prefix for the column in the index. If there is no prefix for this column in the index, then it returns undef.
unique
Returns a boolean value indicating whether the index is a unique index.
fulltext
Returns a boolean value indicating whether the index is a fulltext index.
function
For function indexes, this returns the function being indexed.
id
The id is generated from the table, column and prefix information for the index. This is useful as a canonical name for a hash key, for
example.
Returns a string that is the id which uniquely identifies the index in this schema.
table
Returns the "Alzabo::Table" object to which the index belongs.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Index(3pm)