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)
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)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT SUSE
dviselect
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)