09-29-2010
hi all
i did both of the above thing still output is coming blank
don't know what is the problem
---------- Post updated at 07:09 AM ---------- Previous update was at 12:41 AM ----------
now i modified my script in such a way below
GetDBValue()
{
#
# Returns value from $DATABASE for the given select.
#
typeset SelectSQL=$1
sqlplus -s <<!EOF! | tr -d ' ' | read SQLValue
$DATABASE
SET PAGESIZE 0 FEEDBACK OFF TRIMOUT ON;
${SelectSQL}
!EOF!
RC=$?
}
GetDBValue " Select count(*) from gparams ; "
echo "${SQLValue}"
the name of the shell script is test4.sh here is the output
dolhin5/work/CR10 > ./test4.sh
dolhin5/work/CR10 >
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Have the following lines in a script: echo "-----------------------------------------------"\
"---------------------" >> $xdfrpt
echo "- Date - - / - /stand - /u - /u1 - /u2 -"\
"/x1 - /x2 - /x3 -" >> $xdfrpt
echo... (1 Reply)
Discussion started by: Cameron
1 Replies
2. Shell Programming and Scripting
Hi,
I have given the following statement in a script to put the values of variables (VAR1, VAR2,...) in a file.
echo " $VAR1 $VAR2 $VAR3 $VAR4 $VAR5" >> filename
But the output is not coming properly. Variables VAR5, VAR4 are replacing the first (VAR1, VAR2,..). I can't... (5 Replies)
Discussion started by: abrd600
5 Replies
3. Shell Programming and Scripting
hi
I have say five variable.
I would ask the user which one they want me to print and then print accordingly.
TEST_1='10.2.3.4'
TEST_2='11.2.3.5'
TEST_3='12.2.3.5'
TEST_4='13.2.3.5'
TEST_5='14.2.3.5'
print_var()
{
echo "Accessing var num $1"
echo TEST$1
#??? But How do... (6 Replies)
Discussion started by: sabina
6 Replies
4. Shell Programming and Scripting
echo "XXXXX" >> /xx/output.txt
cat /xx/file.txt| awk '{tony=tony+$1+$2; print tony/$3*100}' >> /xx/output.txt
Dear all,
In this situation i will have 2 lines in the output file. What i want is to have only one output line. e.g: XXXXX "value"
HOW to put the output of the "cat and awk" in... (1 Reply)
Discussion started by: tontal
1 Replies
5. UNIX for Dummies Questions & Answers
Hi
I am using tcsh.
I want display in a file_1 like this.
$VARIBALE
I gave in a termianl
> echo "\$VARIBALE" > file_1
Its not workning.
It was giving VARIBALE: Undefined variable.
I gave \ before $, but why it was giving undefined varible?
Please help me.
Thanks in advance (4 Replies)
Discussion started by: chaitubek
4 Replies
6. Shell Programming and Scripting
Hello all,
Please help with the below.
I have a requirement where in I have to read a pattern and print it as shown below.
Patterns will be as below.
Input Output
Pattern Should be printed as below with spaces such that I can awk.
-*--* - * - - *
*--**... (2 Replies)
Discussion started by: tenderfoot
2 Replies
7. Shell Programming and Scripting
I'm parsing a router configuration file and printing out some of the fields. Given the following output,
I'd like to add the filename to the first column. I'm definately a neophyte in scripting.
COUNTER=${#array1
}
while ; do
######## echo -n $JUNOS_FILE | ... (3 Replies)
Discussion started by: nocleader
3 Replies
8. Shell Programming and Scripting
Hi
I am facing a strange problem
a=03
echo ${a}
the output is 3
But i want to display it is 03
Can you people help me how to display it like 03.
Thanks (2 Replies)
Discussion started by: aishsimplesweet
2 Replies
9. Shell Programming and Scripting
Hey all! I'm in an intro to UNIX class at university, and we've just began writing scripts. Naturally I can't get it to do what I want.
Basic script as follows:
COMPARE1=`ls|wc -l`
tar czf archive.tgz ~/path/to/file
COMPARE2=`tar tvzf archive.tgz|wc -l`
if
then
... (7 Replies)
Discussion started by: nickzourdos
7 Replies
10. Shell Programming and Scripting
I am trying to get ascii file using echo command, e.g. -
echo "\050"
It is correctly working on RHEL 4 but not in RHEL 5. Please help me to fix the issue.
## Working as expected in RHEL 4
$ lsb_release -d
Description: Red Hat Enterprise Linux AS release 4 (Nahant Update 8)
$ echo... (4 Replies)
Discussion started by: atanubanerji
4 Replies
PAPS(1) General Commands Manual PAPS(1)
NAME
paps - UTF-8 to PostScript converter using Pango
SYNOPSIS
paps [options] files...
DESCRIPTION
paps reads a UTF-8 encoded file and generates a PostScript language rendering of the file. The rendering is done by creating outline curves
through the pango ft2 backend.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below.
--landscape
Landscape output. Default is portrait.
--columns=cl
Number of columns output. Default is 1.
Please notice this option isn't related to the terminal length as in a "80 culums terminal".
--font=desc
Set the font description. Default is Monospace 12.
--rtl Do right to left (RTL) layout.
--paper ps
Choose paper size. Known paper sizes are legal, letter and A4. Default is A4.
Postscript points
Each postscript point equals to 1/72 of an inch. 36 points are 1/2 of an inch.
--bottom-margin=bm
Set bottom margin. Default is 36 postscript points.
--top-margin=tm
Set top margin. Default is 36 postscript points.
--left-margin=lm
Set left margin. Default is 36 postscript points.
--right-margin=rm
Set right margin. Default is 36 postscript points.
--gutter-width=gw
Set gutter width. Default is 40 postscript points.
--help Show summary of options.
--header
Draw page header for each page.
--markup
Interpret the text as pango markup.
--lpi Set the lines per inch. This determines the line spacing.
--cpi Set the characters per inch. This is an alternative method of specifying the font size.
--stretch-chars
Indicates that characters should be stretched in the y-direction to fill up their vertical space. This is similar to the texttops
behaviour.
AUTHOR
paps was written by Dov Grobgeld <dov.grobgeld@gmail.com>.
This manual page was written by Lior Kaplan <kaplan@debian.org>, for the Debian project (but may be used by others).
April 17, 2006 PAPS(1)