08-12-2008
Your question is confusing. Can you please clarify ?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hello to all Unix gurus..
I am writing a generic script which takes the options of unix command as input and concatenate all the pieces and forms a complete executable command.
I am getting an error with the following command as I am resetting my own permission on the root directory. When the... (4 Replies)
Discussion started by: sdlayeeq
4 Replies
2. UNIX for Dummies Questions & Answers
I have a file "dbshot.xml" that contains lines that need replacing in a batch format but the parameters are based on two lines.
Ex.
<role roletype="01">
<status>1
needs to be changed to
<role roletype="01">
<status>0
I can't use simply "<status>1" replace since the... (2 Replies)
Discussion started by: E Orgill
2 Replies
3. UNIX for Dummies Questions & Answers
thank you for the help. (1 Reply)
Discussion started by: scooter17
1 Replies
4. UNIX for Dummies Questions & Answers
Hello,
I am aware of that Find command finds certain files and remove command removes certain files.
However, is there a way to Find certain DIRECTORY and remove that DIRECTORY?
thank you (3 Replies)
Discussion started by: scooter17
3 Replies
5. Shell Programming and Scripting
Dear Experts,
please can any body help me to explain the below commants in detail what exactly its doing what we mean by -mtime +2 and -exec and rm{};
find /home/data/ab.200* -mtime +2 -exec rm {} \;
Regards,
SHARY (3 Replies)
Discussion started by: shary
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I'm a complete noobie at UNIX and have hit a problem.
I'm using the 'Talend' ETL tool to try and extract flat files from UNIX on a weekly basis.
The dates are maintained in a control table and the appropriate folder has been mounted.
I am using a component in 'Talend' which enable... (1 Reply)
Discussion started by: markee
1 Replies
7. UNIX for Dummies Questions & Answers
so I saved a mail message of mine to a new dir/file
My question is how do I find the path to my file containing my saved email from my home dir prompt in unix?
Thanks. (1 Reply)
Discussion started by: drew211
1 Replies
8. UNIX for Dummies Questions & Answers
Hello, I am using ksh93 (/usr/dt/bin/dtksh) on Solaris and am stuck when trying to use find with the -prune option.
I need to search a directory (supplied in a variable) for files matching a certain pattern, but ignore any sub-directories.
I have tried:
find ${full_path_to_dir_to_search}... (9 Replies)
Discussion started by: gary_w
9 Replies
9. Shell Programming and Scripting
Hi!
hi
I used find command to find some file names as per input from user. I used it for current directory. It was working fine. Now I tried with giving some other directory path. Its giving issues.
Here what I tried. Script will take input from user say 1_abc.txt, find the file and print... (6 Replies)
Discussion started by: sukhdip
6 Replies
10. UNIX for Dummies Questions & Answers
Hi All
I have a requirement to find the file that are most latest to be modified in each directory. Can somebody help with the command please?
E.g of the problem.
The directory A is having sub directory which are having subdirectory an so on.
I need a command which will find the... (2 Replies)
Discussion started by: sudeep.id
2 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::procedure
SQL::Translator::Schema::Procedure(3pm) User Contributed Perl Documentation SQL::Translator::Schema::Procedure(3pm)
NAME
SQL::Translator::Schema::Procedure - SQL::Translator procedure object
SYNOPSIS
use SQL::Translator::Schema::Procedure;
my $procedure = SQL::Translator::Schema::Procedure->new(
name => 'foo',
sql => 'CREATE PROC foo AS SELECT * FROM bar',
parameters => 'foo,bar',
owner => 'nomar',
comments => 'blah blah blah',
schema => $schema,
);
DESCRIPTION
"SQL::Translator::Schema::Procedure" is a class for dealing with stored procedures (and possibly other pieces of nameable SQL code?).
METHODS
new
Object constructor.
my $schema = SQL::Translator::Schema::Procedure->new;
parameters
Gets and set the parameters of the stored procedure.
$procedure->parameters('id');
$procedure->parameters('id', 'name');
$procedure->parameters( 'id, name' );
$procedure->parameters( [ 'id', 'name' ] );
$procedure->parameters( qw[ id name ] );
my @parameters = $procedure->parameters;
name
Get or set the procedure's name.
$procedure->name('foo');
my $name = $procedure->name;
sql
Get or set the procedure's SQL.
$procedure->sql('select * from foo');
my $sql = $procedure->sql;
order
Get or set the order of the procedure.
$procedure->order( 3 );
my $order = $procedure->order;
owner
Get or set the owner of the procedure.
$procedure->owner('nomar');
my $sql = $procedure->owner;
comments
Get or set the comments on a procedure.
$procedure->comments('foo');
$procedure->comments('bar');
print join( ', ', $procedure->comments ); # prints "foo, bar"
schema
Get or set the procedures's schema object.
$procedure->schema( $schema );
my $schema = $procedure->schema;
equals
Determines if this procedure is the same as another
my $isIdentical = $procedure1->equals( $procedure2 );
AUTHORS
Ken Youens-Clark <kclark@cshl.org>, Paul Harrington <Paul-Harrington@deshaw.com>.
perl v5.14.2 2012-01-18 SQL::Translator::Schema::Procedure(3pm)