Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to assign the result of a SQL command to more than one variable in shell script.
Top Forums Shell Programming and Scripting How to assign the result of a SQL command to more than one variable in shell script. Post 302313590 by little_wonder on Wednesday 6th of May 2009 05:32:01 AM
Old 05-06-2009
MySQL 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

how to assign sql output data to shell script variable

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

assign subst|grep|sed command result to a variable

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

assign awk command result to a variable

#!/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

Assign result to variable

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

assign awk's variable to shell script's variable?

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

Assign SQL result in shell variable

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

How to assign a shell variable to a NUMBER parameter in pl/sql?

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

Passing the result of an anonymous pl/sql block to a shell script

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

Assign the result of a multiline command to a variable

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

How can I assign awk's variable to shell script's variable?

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

LEARN ABOUT DEBIAN

bsqlodbc

bsqlodbc(1)							 FreeTDS Utilities						       bsqlodbc(1)

NAME

       bsqlodbc - batch SQL script processor using ODBC

SYNOPSIS

       bsqlodbc [-U username] [-P password] [-S server] [-D database]
	      [-i input_file] [-o output_file] [-e error_file]
	      [-t field_term] [-qv]

DESCRIPTION

       bsqlodbc is a utility program distributed with FreeTDS.

       bsqlodbc  is  a non-interactive equivalent of the "isql" utility programs distributed by Sybase and Microsoft. Like them, bsqlodbc uses the
       command "go" on a line by itself as a separator between batches. The last batch need not be followed by "go".

       bsqlodbc makes use of the ODBC API provided by FreeTDS. This API is of course also available to application developers.

OPTIONS

       -U username
	      Database server login name.

       -P password
	      Database server password.

       -S server
	      Database server to which to connect.

       -D database
	      Database to use.

       -i input_file
	      Name of script file, containing SQL.

       -o output_file
	      Name of output file, holding result data.

       -e error_file
	      Name of file for errors.

       -t field_term
	      Specifies the field terminator. Default is two spaces ('	').  Recognized escape sequences are tab ('	'), carriage  return  ('
'),
	      newline ('
'), and backslash ('\').

       -h     Print column headers with the data to the same file.

       -q     Do not print column metadata, return status, or rowcount. Overrides -h.

       -v     Verbose  mode,  for  more  information  about the ODBC interaction.  This also reports the result set metadata, including and return
	      code. All verbose data are written to standard error (or -e), so as not to interfere with the data stream.

NOTES

       bsqlodbc is a filter; it reads from standard input, writes to standard output, and writes errors to standard error.  The  -i,  -o,  and	-e
       options override these, of course.

EXIT STATUS

       bsqlodbc exits 0 on success, and >0 if the server cannot process the query.

HISTORY

       bsqlodbc first appeared in FreeTDS 0.65.

AUTHORS

       The bsqlodbc utility was written by James K. Lowden <jklowden@freetds.org>

doc								 13 November 2011						       bsqlodbc(1)
All times are GMT -4. The time now is 12:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy