Sponsored Content
Full Discussion: Unable to open .sql file
Top Forums UNIX for Dummies Questions & Answers Unable to open .sql file Post 302141857 by Ananth.p on Tuesday 23rd of October 2007 03:56:39 AM
Old 10-23-2007
Unable to open .sql file

Hi,

Thanks for your reply.
I am using the following script. GetJobDetails is a script in unix. It assigns the value for JobCommand, $JobDesc and JobType. Then i am passing this sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" command in IF loop.
The partial script is

==================================================

GetJobDetails

case $JobType
in
SQL)
InsertLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'START'
if ( PrereqsCheck ) then
print "$Step - $JobCommand > $LogString 2>$ErrorString"
if (time sqlplus -s @"$JobCommand" > "${LogString}" 2>"${ErrorString}" ) then
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'COMPLETE' 0
else
UpdateLoadStatus $WorkDate "$JobDesc" $Step $Iteration 'HALTED' 0
NotifyOperator 1 "$JobDesc" URGENT
fi
CompressInput
CompressOutput
fi
;;
esac

---------------------------------------------------

Thanks in Advance.

Regards,
Ananth P
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

PCC-F-NOERRFILE, unable to open error message file, facility PR2

I am trying to build a tuxedo server which in turn depends on several Pro*C programs. I am doing it on HP-UX system. It looks to me that the ORACLE_HOME is set properly. But I am getting error message when trying to build. PCC-F-NOERRFILE, unable to open error message file, facility PR2 exit... (1 Reply)
Discussion started by: asutoshch
1 Replies

2. UNIX for Dummies Questions & Answers

SP2-0310 unable to open file

Hi , We are running Oracle 8.1.7 on HP-UX B.11.00. Recently we have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script we use has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out . However we receive the error SP2-0310: unable to open file... (2 Replies)
Discussion started by: guru_2007
2 Replies

3. Solaris

unable to open a .log(4MB) file in vi

am unable to open a .log file which is 4MB size. (18 Replies)
Discussion started by: venkatramana
18 Replies

4. AIX

Probably an easy SMIT question- "Unable to open temp file"

Hi All, Can't find any documentation on the web for this anywhere, except about three web pages that are in Chinese. When I enter SMIT on this box, I get ERROR MESSAGE: Unable to open temp file I suspected smit.log, but it is universal readable, writeable by root, and I am root.... (6 Replies)
Discussion started by: jeffpas
6 Replies

5. UNIX for Advanced & Expert Users

Unable to delete an open file

I am working on a unix server. I killed all the processes with my id on the machine. After that I tried to delete a file, I got an error:- file not removed.Text File busy. Deletion of directory prompted:- Directory not empty. Can anyone help me regarding this...??? Thanks, Vikas (11 Replies)
Discussion started by: vikasrout
11 Replies

6. Shell Programming and Scripting

PCC-F-NOERRFILE, unable to open error message file

Hi, I was compiling few C programs in the unix server and getting the following error message rm: /home/a0xxx28/AVT/SEEDLIBRARYDB/LIB/*.a non-existent proc MODE=ANSI CODE=ANSI_C INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARYDB/INCLUDE INCLUDE=/home/a0xxx28/PVT/SEEDLIBRARY/INCLUDE ... (1 Reply)
Discussion started by: kavithakuttyk
1 Replies

7. Red Hat

unable to open / create any file in vi

Hi, I am unable to create/open any file in vi editor for normal user, though using root I am able to create/open any file, using redhat 5.5, example vi test it showing nothing after entering command (9 Replies)
Discussion started by: manoj.solaris
9 Replies

8. Shell Programming and Scripting

Unable to open a file in perl

Not able to open a file using this code why not? use strict; use warnings; my $file = "verInfo.txt"; unless(open FILE, $file) { # Die with error message # if we can't open it. die "\nUnable to open $file\n"; } my $line = <FILE>; print $line; close FILE; (7 Replies)
Discussion started by: srijith
7 Replies

9. Shell Programming and Scripting

Unable to pass value from .Shell script to .SQL file

Hi All, I am new to shell script. I am trying to pass value from .sh file to .sql file . But I am able to run the .sql file from .sh file with values in sql file. But I am unable to pass the values from .sh file. can some one please help to resolve this. here is my .sh file s1.sh ... (4 Replies)
Discussion started by: reddy298599
4 Replies

10. UNIX for Beginners Questions & Answers

Unable to open input kickstart file curl#37

Hi, Getting the below error while installing from ks.cfg unable to open input kickstart file curl#37 Couldn't open file /tmp/swappart Here am trying to include /tmp/swappart file from pre section under disks and partition section. Dont know where exactly am doing wrong My kickstart file... (3 Replies)
Discussion started by: Sumanthsv
3 Replies
Parse::ErrorString::Perl(3pm)				User Contributed Perl Documentation			     Parse::ErrorString::Perl(3pm)

NAME
Parse::ErrorString::Perl - Parse error messages from the perl interpreter VERSION
version 0.15 SYNOPSIS
use Parse::ErrorString::Perl; my $parser = Parse::ErrorString::Perl->new; # or: my $parser = Parse::ErrorString::Perl->new(lang => 'FR') # to get localized explanations my @errors = $parser->parse_string($string_containing_stderr_output); foreach my $error(@errors) { print 'Captured error message "' . $error->message . '" in file ' . $error->file . ' on line ' . $error->line . " "; } METHODS
new(lang => $lang) Constructor. Receives an optional "lang" parameter, specifying that error explanations need to be delivered in a language different from the default (i.e. English). Will try to load "POD2::$lang::perldiag". parse_string($string) Receives an error string generated from the perl interpreter and attempts to parse it into a list of "Parse::ErrorString::Perl::ErrorItem" objects providing information for each error. SEE ALSO
splain ACKNOWLEDGEMENTS
Part of this module is based on code from splain. BUGS
Please report any bugs or feature requests to "bug-parse-errorstring-perl at rt.cpan.org", or through the web interface at <http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Parse-ErrorString-Perl>. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes. SUPPORT
You can find documentation for this module with the perldoc command. perldoc Parse::ErrorString::Perl o RT: CPAN's request tracker <http://rt.cpan.org/NoAuth/Bugs.html?Dist=Parse-ErrorString-Perl> o AnnoCPAN: Annotated CPAN documentation <http://annocpan.org/dist/Parse-ErrorString-Perl> o CPAN Ratings <http://cpanratings.perl.org/d/Parse-ErrorString-Perl> o Search CPAN <http://search.cpan.org/dist/Parse-ErrorString-Perl/> AUTHORS
o Petar Shangov, "<pshangov at yahoo.com>" o Gabor Szabo <http://szabgab.com/> o Ahmad M. Zawawi <ahmad.zawawi@gmail.com> COPYRIGHT AND LICENSE
This software is copyright (c) 2010 by Petar Shangov. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.10.1 2010-11-29 Parse::ErrorString::Perl(3pm)
All times are GMT -4. The time now is 08:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy