I am new to this forum. I have a script which randomly throws error.Following are steps followed in this script:
Generate Term file
Remove previous term and rpt files from utility directory.
copy term file to utility directory
call sql to generate rpt file using term file as input
copy the generated rpt file from run directory to utility directory.
I get error from sql as :
Code:
ORA-29283 - Invalid file operation.
This happens when term file is not present in utility directory when sql is called.
Code snippet is shown below. Please ignore the syntax error, if any.
Code:
> RUN_DIR/nj.terms
if [[ -s RUN_DIR/nj.terms ]] then
rm -f /utl/nj.terms
rm -f /utl/nj.rpt
cp RUN_DIR/nj.terms utl
/bin/sqlplus USER PSWD @sql
cp utl/nj.RPT RUN_DIR
fi
After script runs, if we check utility directory we can find term file
This error occurs randomly. Is there any chance system takes more time to copy the Term file to Utility directory and before completing the copy command, sql started running?
Moderator's Comments:
Thread moved. Please post in the correct forum ...
Good Day
I mistakely renamed the dld.sl file in the /usr/lib directory. When i try to ls/ftp into the box i get this error :eek:
crt0: ERROR couldn't open /usr/lib/dld.sl errno:000000002
I have tried to rename it back from the renamed file to the original file name, but it gives me the... (2 Replies)
Command works but not in SH
At terminal if i type:
scp test.tar.gz user1@server2:/home/user
Everything run smoothly (keyed, no password need)
At script , test.sh
#!/bin/sh
scp test.tar.gz user1@server2:/home/user
Nothing happen and clue ? ? ? ? ? (3 Replies)
at command does not work with graphic programs like firefox, evolution, etc
It works with other commands
for example:
at now
shutdown -h now
OK
but
at now
firefox
does not work
Anyone knows if its possible to open a firefox window at a scheduled time?
Thanks
Jose (0 Replies)
I am trying to copy a folder which contains a list of C executables.
It takes 2 mins for completion,where as the entire script takes only 3 more minutes for other process.
Is there a way to copy the folder faster so that the performance of the script will improve? (2 Replies)
How can we copy a command string from a previous command line and paste it into the cursor position on the current command line? I know that ^c will not work as the shell will interpret as an interrupt signal.
Thanks, (1 Reply)
Hi
I have a problem with scp command :
I try to copy a list of files from source to destination, it works fine but if there is a directory not existing on destination, it doesn't automatic create.
Syntax :
scp -rp /<PATH>/<NEW_DIR>/<FILE> <USER_DEST>@<HOST_DEST>:<PATH>/<NEW_DIR>/<FILE>... (5 Replies)
need help, trying make a command where the user presses any keys and it will go to the home page, however it doesnt work, why ?
echo -p "press any key to return to main menu" menu
if ]; then
echo -p "\n"
home
fi (5 Replies)
Hi,
I want to copy a file/directory ( recursively , if needed) and if destination directory does not exist create it ( with parent directory, if needed).
funcopy () {
if ; then
echo "$2 exists , copying files"
cp -r "$1" "$2"
else
echo "Directory does not exist;Create directory"
mkdir... (1 Reply)
Hello.
I have a question as to why my grep command does not seem to be working.
grep -c '^?*' ~
grep -c '^.*' ~
I wanted to count the number of files starting with the letter K and have some letters after that. I have such files in my home directory. However, the output is 0. So, I have no... (2 Replies)
I want copy Files:
But cp don't work:
shell_exec("cp ".$pfad." ".$genzone);
shell_exec("cp ../Chrysanthemum.jpg ../test");
Whats wrong? (3 Replies)
Discussion started by: Linuxmann
3 Replies
LEARN ABOUT SUSE
sql::statement::term
SQL::Statement::Term(3) User Contributed Perl Documentation SQL::Statement::Term(3)NAME
SQL::Statement::Term - base class for all terms
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::Term->new( $owner );
# access the value of that term
$term->value( $eval );
DESCRIPTION
SQL::Statement::Term is an abstract base class providing the interface for all terms.
INHERITANCE
SQL::Statement::Term
METHODS
new
Instantiates new term and stores a weak reference to the owner.
value
Abstract method which will return the value of the term. Must be overridden by derived classes.
DESTROY
Destroys the term and undefines the weak reference to the owner.
NAME
SQL::Statement::ConstantTerm - term for constant values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' );
# access the value of that term - returns 'foo'
$term->value( $eval );
DESCRIPTION
SQL::Statement::ConstantTerm implements a term which will always return the same constant value.
INHERITANCE
SQL::Statement::ConstantTerm
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the constant to deliver and a weak reference to the owner.
value
Returns the specified constant.
NAME
SQL::Statement::ColumnValue - term for column values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ColumnValue->new( $owner, 'id' );
# access the value of that term - returns the value of the column 'id'
# of the currently active row in $eval
$term->value( $eval );
DESCRIPTION
SQL::Statement::ColumnValue implements a term which will return the specified column of the active row.
INHERITANCE
SQL::Statement::ColumnValue
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the column name to deliver and a weak reference to the owner.
value
Returns the specified column value.
AUTHOR AND COPYRIGHT
Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.12.1 2010-05-06 SQL::Statement::Term(3)
02-19-2015
