How to assign the result of a SQL command to more than one variable in shell script. Post: 302313890

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

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...

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...

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...

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...

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...

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...

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...

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...

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...

LEARN ABOUT HPUX

rcsmerge

rcsmerge(1)						      General Commands Manual						       rcsmerge(1)

NAME

       rcsmerge - merge RCS revisions

SYNOPSIS

       rev2] file

DESCRIPTION

       incorporates  the  changes between rev1 and rev2 of an RCS file into the corresponding working file.  If is given, the result is printed on
       the standard output; otherwise the result overwrites the working file.

       A file name ending in is an RCS file name; otherwise it is a working file name.	derives the working file name from the RCS file  name  and
       vice versa, as explained in rcsintro(5).  A pair consisting of both an RCS and a working file name can also be specified.

       rev1  cannot  be omitted.  If rev2 is omitted, the latest revision on the trunk is assumed.  Both rev1 and rev2 can be given numerically or
       symbolically.

       prints a warning if there are overlaps, and delimits the overlapping regions as explained for the option of co(1).  The command	is  useful
       for incorporating changes into a checked-out revision.

EXAMPLES

       Suppose	you  have released revision 2.8 of Assume furthermore that you just completed revision 3.4 when you receive updates to release 2.8
       from someone else.  To combine the updates to 2.8 and your changes between 2.8 and 3.4, put the updates to 2.8 into file and execute:

       Then examine Alternatively, if you want to save the updates to 2.8 in the RCS file, check them in as revision 2.8.1.1 and execute

       As another example, the following command undoes the changes between revision 2.4 and 2.8 in your currently checked out revision in

       Note the order of the arguments, and that is overwritten.

WARNINGS

       does not work for files that contain lines with a single

AUTHOR

       was developed by Walter F. Tichy.

SEE ALSO

       ci(1), co(1), merge(1), ident(1), rcs(1), rcsdiff(1), rlog(1), rcsfile(4).

																       rcsmerge(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to assign sql output data to shell script variable

Discussion started by: kattics

2. Shell Programming and Scripting

assign subst|grep|sed command result to a variable

Discussion started by: snowbiker99

3. Shell Programming and Scripting

assign awk command result to a variable

Discussion started by: dedmakar

4. Shell Programming and Scripting

Assign result to variable

Discussion started by: temhem