12-05-2006
Hi All
I have tried the following script but am not getting any output, can any one help me to know the problem in my script
export v_test=0
v_test='sqlplus -s apps/apps <<END
set feedback off
set heading off
select 6 from dual;
EXIT;
END'
echo out put is $v_test
Thanks & Regards
Abdul Hafeez Shaik
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies
2. UNIX for Dummies Questions & Answers
Need to select count(*) from table to check for zero result in unix script (2 Replies)
Discussion started by: struggle
2 Replies
3. Shell Programming and Scripting
How to redirect postgresql select query to a variable using shell scripts?
I tried to use
psql -c "select ip from servers" db | egrep '+\.+\+\+' | sed 's/^ *\(.*\) *$/\1/'
Output:
10.10.10.180
10.10.10.181
It display ip addresses from the databasem, but how could i redirect the... (3 Replies)
Discussion started by: uativan
3 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have file on below pattern, and i want to write a generic awk to handle all cases.
input_file:
col1~col2~col3~col4~col5~col6
I need to generate 4 files something like this
File1:
col1~~col2~~col3
File2:
col1~~col2~~col4
File3:
col1~~col2~~col5
File4:
col1~~col2~~col6 (1 Reply)
Discussion started by: luckybalaji
1 Replies
5. Shell Programming and Scripting
Hi All
I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all... (1 Reply)
Discussion started by: amitsinha
1 Replies
6. Shell Programming and Scripting
Hi All,
I have browsed through the forums for a similar topic, but there is no topic which explains about this problem, when the backend is DB2.
I want to assign the output of a select count(*) from tablename to a unix variable in a shell script.
I am using ksh.
The database used to... (3 Replies)
Discussion started by: Siddarth
3 Replies
7. Shell Programming and Scripting
Hi,
I have a requirement to store oracle sqlplus output to some unix variable, count the records and then print the output on the screen.
Can you please point me to any sample program for reference purpose.
Thanks a lot for your time. (0 Replies)
Discussion started by: bhupinder08
0 Replies
8. Shell Programming and Scripting
The following is my script :
#!/bin/bash
echo "please give app_instance_id"
read app_instance_id
echo "id is $app_instance_id"
export app_id=app_instance_id
sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF
SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies
9. Shell Programming and Scripting
I have a sql statement , i need to assign to a variable in Unix
sel count(*) AS num_files from TABLE_A;
i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files (1 Reply)
Discussion started by: nani1984
1 Replies
10. Shell Programming and Scripting
I am fairly new to writing scripts, and have gotten a lot of help from this site in the past with many of the posts.
I have a question/issue with a script I am attempting to write and have a question regarding executing an sql statement inside of a loop (do while). I have in the past written... (1 Reply)
Discussion started by: josbor01
1 Replies
LEARN ABOUT SUNOS
gnome-calculator
gnome-calculator(1) User Commands gnome-calculator(1)
NAME
gnome-calculator, gcalctool - perform basic, financial, and scientific calculations
SYNOPSIS
gnome-calculator [-a accuracy] [-D] [-E] [gnome-std-options]
DESCRIPTION
The Calculator application is multifunctional and can handle different types of mathematical approaches.
Calculator has the following modes:
Basic Mode Provides standard calculator functions. You can store numbers in 10 different memory registers, and easily retrieve
and replace the numbers in the memory registers. Basic Mode is the default mode. You can use all of the Basic Mode
functions in each of the other modes.
Financial Mode Provides several complex financial functions.
Scientific Mode Provides many additional mathematical functions, including trigonometric and logical functions. You can also store
your own functions and constants, when you use Scientific Mode.
EXTENDED DESCRIPTION
On startup, Calculator uses the following configuration resources stored in a GConf database.
Resource: /schemes/apps/gcalctool/accuracy
Values: Accuracy value
Description: The number of digits displayed after the
numeric point. This value must be in the
range 0 to 9.
Resource: /schemes/apps/gcalctool/base
Values: Numeric Base
Description: The initial numeric base. Valid values are
"BIN" (binary), "OCT" (octal), "DEC" (deci-
mal), and "HEX" (hexadecimal).
Resource: /schemes/apps/gcalctool/display
Values: Display mode
Description: The initial display mode. Valid values are
"ENG" (engineering), "FIX" (fixed-point), and
SCI" (scientific).
Resource: /schemes/apps/gcalctool/mode
Values: Mode
Description: The initial calculator mode. Valid values are
"BASIC", "FINANCIAL", and "SCIENTIFIC".
Resource: /schemes/apps/gcalctool/showzeroes
Values: true, false (true)
Description: Whether to show trailing zeroes after the
numeric point in the display value.
Resource: /schemes/apps/gcalctool/showregisters
Values: true, false (true)
Description: Whether to display the memory register window
when Calculator starts.
Resource: /schemes/apps/gcalctool/trigtype
Values: Trig. type
Description: The initial trigonometric type. Valid values
are "DEG" (degrees), "GRAD" (grads), and
"RAD" (radians).
Any constants or functions that the user defines are also stored in the GConf database.
OPTIONS
The following options are supported:
-a accuracy Specifies the number of digits displayed after the numeric point. This value must be in the range 0 to 9.
-D Enable debug mode.
-E Enable debug mode in the multiple-precision arithmetic package.
gnome-std-options Standard options available for use with most GNOME applications. See gnome-std-options(5) for more information.
EXAMPLES
Example 1: Launching Calculator
example% gnome-calculator
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/gnome-calculator Executable for Calculator.
~/.gcalctoolrc User-specific resources for customizing the appearance and color of Calculator.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-calculator |
+-----------------------------+-----------------------------+
|Interface stability |External |
+-----------------------------+-----------------------------+
SEE ALSO
Calculator Manual
Latest version of the GNOME Desktop User Guide for your platform.
gnome-std-options(5)
NOTES
Written by Glynn Foster and Rich Burridge, Sun Microsystems Inc., 2003.
SunOS 5.10 1 Oct 2003 gnome-calculator(1)