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)
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)
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)
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)
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)
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)
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)
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)
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)