05-06-2009
How to assign the result of a SQL command to more than one variable in shell script.
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname <<EOF
set heading off
set feedback off
SELECT no from table_A where no=123;
exit
EOF`
--------------------------------------------------------------------
please help me, that I want to assign the result of below query to two variables 1.no and 2.name
select no,name from table_A where no=123
Thankyou for all of your answers!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Discussion started by: kattics
1 Replies
2. Shell Programming and Scripting
Hi,
I'm quite new to scripting and I want to modify following line of an existing script:
MYVAR=`subst |grep 'L:\\\:' | sed -e 's/.*\\\//'`;
What I have to do is to use the content of a variable instead of the constant expression 'L:\\\:' as the grep string to be matched.
Assuming I already... (5 Replies)
Discussion started by: snowbiker99
5 Replies
3. Shell Programming and Scripting
#!/bin/sh
#
##
MYSTRING = `awk '/myApp.app/' /Users/$USER/Library/Preferences/loginwindow.plist`
if
then
echo String not found
defaults write /Users/$USER/Library/Preferences/loginwindow AutoLaunchedApplicationDictionary -dict-add -string Hide -bool YES -string Path -string... (9 Replies)
Discussion started by: dedmakar
9 Replies
4. Shell Programming and Scripting
Hi friends,
firstly, i can run following expression and i took 100 value.
sqlplus -s username/password@TTTEST @umt.sql
umt.sql exists "select t.deger from parametre t where t.id=30".
result of this query =100
i need to assign this value(100) to variable(for example x... (2 Replies)
Discussion started by: temhem
2 Replies
5. Shell Programming and Scripting
Dear All,
we have a command output which looks like :
Total 200 queues in 30000 Kbytes
and we're going to get "200" and "30000" for further process. currently, i'm using :
numA=echo $OUTPUT | awk '{print $2}'
numB=echo $OUTPUT | awk '{print $5}'
my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
im trying to assign the result of the db2 command to a variable inside a shell script...
: tab_cnt=`db2 "select count(*) from syscat.tables where tabname = 'ABC' and tabschema = 'MATT01'" |head -4|tail +4|cut -c 11`
: echo $tab_cnt
when i echo im getting a blank value.. im expecting... (1 Reply)
Discussion started by: matt01
1 Replies
7. Shell Programming and Scripting
I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this.
#!/bin/sh
minlimit=0
maxlimit=10
size=100
while... (0 Replies)
Discussion started by: vel4ever
0 Replies
8. Shell Programming and Scripting
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
Discussion started by: santosh2eee
2 Replies
9. Shell Programming and Scripting
Hi,
I have the following command that lists all the .o files from all the directories except of vwin (which I don't want it)
for i in `ls -d */*.o|awk '$0 !~ "vwin"'`; do echo $i; done
The result is something like that
dir1/file1.o
dir1/file2.o
dir2/file3.o
etc.
So, I want to create a... (9 Replies)
Discussion started by: scor6800
9 Replies
10. UNIX for Beginners Questions & Answers
I have the following script, and I want to assign the output ($10 and $5) from awk to N and L:
grdinfo data.grd | awk '{print $10,$5}'| read N L
output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 Replies
uname(2) System Calls Manual uname(2)
NAME
uname - Gets the name of the current system
SYNOPSIS
#include <sys/utsname.h>
int uname(
struct utsname *name);
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
uname(): XSH5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
PARAMETERS
Points to a utsname structure.
DESCRIPTION
The uname() function stores information identifying the current system in the structure pointed to by the name parameter.
The uname() function uses the utsname structure, which is defined in the sys/utsname.h file and contains the following members: char sys-
name[_SYS_NMLN]; char nodename[_SYS_NMLN]; char release[_SYS_NMLN]; char version[_SYS_NMLN]; char machine[_SYS_NMLN];
The uname() function returns a null-terminated character string naming the current system in the sysname character array. The nodename
array contains the name that the system is known by on a communications network. The release and version arrays further identify the sys-
tem. The machine array identifies the CPU hardware being used.
RETURN VALUES
Upon successful completion, a nonnegative value is returned. Otherwise, -1 is returned and errno is set to indicate the error.
ERRORS
If the uname() function fails, errno may be set to the following value: [Tru64 UNIX] The name parameter points outside of the process
address space.
RELATED INFORMATION
Commands: uname(1)
Standards: standards(5) delim off
uname(2)