Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Assign the return value of the SQL to a variable in UNIX
Top Forums Shell Programming and Scripting Assign the return value of the SQL to a variable in UNIX Post 302943966 by KrishBalu on Thursday 14th of May 2015 10:49:44 AM
Old 05-14-2015
Assign the return value of the SQL to a variable in UNIX
Hi

I am new to UNIX. I am trying the below and getting the error.

I am trying to assign the variable with the value of the query result. I want this value to use in the next steps.

Created UNIX file (Batch.sh) as below

#!/bin/ksh
sqlplus callidus/callidus4u@attstcal @Batch.sql

Created UNIX file (Batch.sql) as below

batchname = ~sqlplus -s callidus/callidus@attstcal <<EOC
select batchname from cs_table where rownum = 1 order by 1 desc;
EOF!
)
echo $batchname

I am getting the below error

"SP2-0734: unknown command beginning "batchname=" - rest of line ignored.

Can anyone please help.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

return variable from PL/SQL procedure to shell

Hi i'm calling a pl/sql procedure which is returning one variable. i'm trying to assing this value to variable in shell script the code i wrote is ** in shell script** var= 'sqlplus user/pass @ret.sql' echo $var ** and variable dum_var number exec rt_test(:DUM_VAR); exit; in... (4 Replies)
Discussion started by: ap_gore79
4 Replies

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

3. Shell Programming and Scripting

To get value from oracle & assign it in UNIX variable

Hi Team, I need to get data from oracle table & need to assign that value to unix variable. I have serched the same in other threads. I found the following code. I have tried code to get the value from oracle. but it is not working. The error shows invalid identifier "NAM" & then list all... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies

4. Shell Programming and Scripting

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... (4 Replies)
Discussion started by: little_wonder
4 Replies

5. Shell Programming and Scripting

Assigning return value of an embedded SQL in a shell script variable

I've a script of the following form calling a simple sql that counts the no of rows as based on some conditions. I want the count returned by the sql to get assigned to the variable sql_ret_val1. However I'm finding that this var is always getting assigned a value of 0. I have verified by executing... (1 Reply)
Discussion started by: MxC
1 Replies

6. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies

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

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

9. Shell Programming and Scripting

How to assign value from isql to UNIX variable

I want output to be assigned to UNIX variables echo "Enter RRS ID: " read rrs isql -SPROD_DDS -USYBUSER -PSYBPASS -b -osfg.out << EOF use sip go set nocount on select issuerId, legalStructTxt, productName, issuerName from sf_product where rrsId = $rrs go EOF (1 Reply)
Discussion started by: JayDoshi
1 Replies

10. Shell Programming and Scripting

How to Assign the Output of an SQL Query to a Variable?

Hi iam new to shell scripting how to declare variables as redshift query and I have to compare two counts by using if condition . ex:count=select count(*) from prd; select count(*) from prd; select count(*) from tag; can any one help me . Please use CODE tags when displaying... (1 Reply)
Discussion started by: sam526
1 Replies

LEARN ABOUT MOJAVE

net::server::proto::unix5.18

Net::Server::Proto::UNIX(3)				User Contributed Perl Documentation			       Net::Server::Proto::UNIX(3)

NAME

       Net::Server::Proto::UNIX - Net::Server UNIX protocol.

SYNOPSIS

       See Net::Server::Proto.

DESCRIPTION

       Protocol module for Net::Server.  This module implements the UNIX SOCK_STREAM socket type.  See Net::Server::Proto.

       Any sockets created during startup will be chown'ed to the user and group specified in the starup arguments.

PARAMETERS

       The following paramaters may be specified in addition to normal command line parameters for a Net::Server.  See Net::Server for more
       information on reading arguments.

       unix_type
	   Can be either SOCK_STREAM or SOCK_DGRAM (default is SOCK_STREAM).  This can also be passed on the port line (see Net::Server::Proto).

	   However, this method is deprecated.	If you want SOCK_STREAM - just use proto UNIX without any other arguments.  If you'd like
	   SOCK_DGRAM, use the new proto UNIXDGRAM.

METHODS

       NS_unix_path/NS_unix_type
	   In addition to the standard NS_ methods of Net::Server::Proto classes, the UNIX types also have legacy calls to NS_unix_path and
	   NS_unix_type.

	   Since version 2.000, NS_unix_path is simply an alias to NS_port.  NS_unix_type is now redundant with NS_proto.

	   These methods were missing between version 2.000 and 2.003 but have been returned as legacy bridges.

QUICK PARAMETER LIST

	 Key		   Value		    Default

	 # deprecated UNIX socket parameters
	 unix_type	   (SOCK_STREAM|SOCK_DGRAM) SOCK_STREAM
	 port		   "filename"		    undef

	 # more recent usage
	 port		   "filename / UNIX"
	 port		   "filename / UNIXDGRAM"

LICENCE

       Distributed under the same terms as Net::Server

perl v5.18.2							    2012-06-06					       Net::Server::Proto::UNIX(3)
All times are GMT -4. The time now is 04:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy