Hi,
I am trying to pass some of the variables in my shell scripts to the sqlplus call and use them as parameters.
For example, I would like to replace the 'SAS', and '20050612' with $var1 and $var2, respectively, how can I do that?
--------------------------------------------------------... (1 Reply)
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Hi,
I am using SYBASE database. in my script i am connecting to DB via using isql.
isql -U${S_USER} -S${S_SERV} -D${S_DB} -P${S_PWD} -b0 -w3000 -h0 -s"|" -i${MYDIR}/ABC.sql -oXYZ.txt << FINSQL
i am taking a ABC.sql file to use the queries written in it and storing the output in... (3 Replies)
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Gurus,
The issue I'm having is that my Shell won't accept SQL parameters properly......
Here's they way I'm running it....
applmgr@ga006hds
=> sh CW_MigrationDeployScript.sh apps <appspwd> <SID> '01-JAN' '31-MAR'
The process just hangs not submitting the SQL job...
... (3 Replies)
i have file in which i have employee id are there and every time number of employee id are different in file means number of count of employee id in file are every time different.
343535435
365765767
343534543
343543543
i want to pass this file to sqlplus
and sql command is
... (7 Replies)
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)
hello friend good morning
I have a problem, how can I take the value that the PROCEDURE returns to me in the variable "CodError", when the connection to the bbdd is closed I lose the value and I need it in the shell
#AIX
cat <<EOF | sqlplus -s ${ORA_LOGIN}/${ORA_PASSWORD} > $logftmp
set... (6 Replies)
Discussion started by: tricampeon81
6 Replies
LEARN ABOUT REDHAT
pdf2dsc
PDF2DSC(1) Ghostscript Tools PDF2DSC(1)NAME
pdf2dsc - generate a PostScript page list of a PDF document
SYNOPSIS
pdf2dsc input.pdf [ output.dsc ]
DESCRIPTION
pdf2dsc uses gs(1) to read an Adobe Portable Document Format (PDF) document "input.pdf" and create a PostScript(tm) document "output.dsc"
that conforms to Adobe's Document Structuring Conventions (DSC) requirements.
This new document simply tells Ghostscript to read the PDF file and to display pages one at a time. The generated document can then be
viewed with any PostScript viewer based on Ghostscript, like ghostview(1) on Unix or GSview on Windows, with which the user can browse
through the pages of the PDF document in any order.
If no output file is named on the command line, the name of the output file is that of the input file with any extension removed, followed
by the extension ".dsc".
CAVEATS
The DSC document uses Ghostscript-specific procedures. In addition, the original PDF document must be accessible when the DSC document is
processed.
You need the file "pdf2dsc.ps" (originally by Russell Lang) supplied with Ghostscript since release 3.53.
SEE ALSO gs(1), ghostview(1)VERSION
This document was last revised for Ghostscript version 7.05.
AUTHOR
Yves Arrouye <yves.arrouye@usa.net> and Russell Lang <rjl@aladdin.com>
7.05 22 April 2002 PDF2DSC(1)