Sponsored Content
Top Forums Shell Programming and Scripting How to Assign the Output of an SQL Query to a Variable? Post 302998408 by sam526 on Wednesday 31st of May 2017 10:55:15 PM
Old 05-31-2017
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;

Code:
select count(*) from prd;
 
select count(*) from tag;

can any one help me .
Moderator's Comments:
Mod Comment Please use CODE tags when displaying sample input, output, and code segments (as required by forum rules).

Last edited by Don Cragun; 06-01-2017 at 12:47 AM.. Reason: Add CODE and ICODE tags.
 

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

How to store the sql query's output in a variable

Hi, My requirement is : We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this. Can you please share a code snippet which... (4 Replies)
Discussion started by: venkatesh_sasi
4 Replies

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

4. Shell Programming and Scripting

bash assign mysql query single field to variable

I'm running a bash script query and assigning the output to a variable like this: exists=`mysql -u $USER_NAME --password=$PASSWORD -D "somedb" \ -e "SELECT * FROM somedb.sometable WHERE field1 ='$a' \ AND field2 ='$b' LIMIT 0 , 30";` which returns something like: echo... (2 Replies)
Discussion started by: unclecameron
2 Replies

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

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

7. Shell Programming and Scripting

How to Assign SQL Query Results to Variables in Linux?

Hi, I am new to linux... How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me. Ex: SQL> Select * from EMP; O/P: Emp_No Emp_Name 1 AAA 2 BBB 3 CCC and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies

8. Shell Programming and Scripting

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

9. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

10. Shell Programming and Scripting

Sql query output count

Hi Team, below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1. and i don't use count() in sql query... based on count, i need to fail the script. No_of_step=`echo ${g_count} | wc -l` function gf_count() { g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies
DVISELECT(1)                                                  General Commands Manual                                                 DVISELECT(1)

NAME
dviselect - extract pages from DVI files SYNOPSIS
dviselect [ -s ] [ -i infile ] [ -o outfile ] list of pages [ infile [ outfile ] ] DESCRIPTION
Dviselect selects pages from a DVI file produced by TeX, creating a new DVI file usable by any of the TeX conversion programs, or even by dviselect itself. A range is a string of the form even, odd, or first:last where both first and last are optional numeric strings, with negative numbers indicated by a leading underscore character ``_''. If both first and last are omitted, the colon may also be omitted, or may be replaced with an asterisk ``*''. A page range is a list of ranges separated by periods. A list of pages is described by a set of page ranges sepa- rated by commas and/or white space. Dviselect actually looks at the ten count variables that TeX writes; the first of these (count0) is the page number, with count1 through count9 having varied uses depending on which macro packages are in use. (Typically count1 might be a chapter or section number.) A page is included in dviselect's output if all its count values match any one of the ranges listed on the command line. For example, the com- mand ``dviselect *.1,35:'' might select everything in chapter 1, as well as pages 35 and up. ``dviselect 10:30'' would select pages 10 through 30 (inclusive). ``:43'' means everything up to and including page 43 (including negative-numbered pages). To get all even-num- bered pages, use ``even''; to get all odd-numbered pages, use ``odd''. If a Table of Contents has negative page numbers, ``:_1'' will select it. Note that ``*'' must be quoted from the shell; the empty string is more convenient to use, if harder to read. Instead of count values, dviselect can also select by ``absolute page number'', where the first page is page 1, the second page 2, and so forth. Absolute page numbers are indicated by a leading equal sign ``=''. Ranges of absolute pages are also allowed: ``dviselect =3:7'' will extract the third through seventh pages. Dot separators are not legal in absolute ranges, and there are no negative absolute page numbers. Even/odd specifiers, however, are legal; ``dviselect =even'' selects every other page, starting with the second. More precisely, an asterisk or an empty string implies no limit; an equal sign means absolute page number rather than counts; a leading colon means everything up to and including the given page; a trailing colon means everything from the given page on; the word ``even'' means only even values shall be accepted; the word ``odd'' means only odd values shall be accepted; and a period indicates that the next count should be examined. If fewer than 10 ranges are specified, the remaining counts are left unrestricted (that is, ``1:5'' and ``1:5.*'' are equivalent). A single number n is treated as if it were the range n:n. An arbitrary number of page selectors may be given, separated by commas or whitespace; a page is selected if any of the selectors matches its counts or absolute page number. Dviselect normally prints the page numbers of the pages selected; the -s option suppresses this. AUTHOR
Chris Torek, University of Maryland SEE ALSO
dviconcat(1), latex(1), tex(1) MC-TeX User's Guide The TeXbook BUGS
A leading ``-'' ought to be allowed for negative numbers, but it is currently used as a synonym for ``:'', for backwards compatibility. Section or subsection selection will sometimes fail, for the DVI file lists only the count values that were active when the page ended. Clever macro packages can alleviate this by making use of other ``free'' count registers. Chapters normally begin on new pages, and do not suffer from this particular problem. The heuristic that decides which arguments are page selectors and which are file names is often wrong. Using shell redirection or the -i and -o options is safest. Dviselect does not adjust the parameters in the postamble; however, since these values are normally used only to size certain structures in the output conversion programs, and the parameters never need to be adjusted upward, this has not proven to be a problem. DVISELECT(1)
All times are GMT -4. The time now is 09:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy