...
However i do not know how to capture SQL output into a UNIX variable.
Below is what i have tried, but i get an error: Error 3706 Failure 3706 Syntax error: expected something between the beginning of the request and the word 'var1'
... . /bto/CommonUtils.ksh ... #a function saved in another script (CommonUtils.ksh) called here. BTEQ ${LOADACCT} <<EOF var1='SELECT IP_NUMBER FROM Table6_A WHERE SMGR_CLLI = '${CLLI}';' EOF ...
You haven't mentioned anything about the database. Is it Oracle, MySQL, DB2 ?
The technique of saving a database value in a Unix variable may vary according to the database involved.
Also, it's not clear what's there in "CommonUtils.ksh" or "BTEQ".
So I shall assume you have Oracle, you want to run a query passing a value to it and capture the output in a Unix shell 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)
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)
I am trying to assgn the output of the select statement to a variable, like this
"VARIABLE_NAME=$ db2 "select COLUMN_NAME_1 from TABLE_NAME where COLUMN_NAME_2='VALUE_TO_CHECK'"; "
but the value that is getting into VARIABLE_NAME is
"COLUMN_NAME_1
-----------------
VALUE
1... (3 Replies)
Hi
I tried searching but I used to see , this has been answered may times.
But I could not find.
I am looking a SQLPLUS output to be assigned to shell variable.
This is what I coded.
##/bin/ksh
sqlplus dmishr/mishra#09@ps004d.world <<ENDOFSQL
spool abc.log
SET ECHO OFF NEWP... (4 Replies)
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Hi,
I have a requirement to store oracle sqlplus output to some unix variable, count the records and then print the output on the screen.
Can you please point me to any sample program for reference purpose.
Thanks a lot for your time. (0 Replies)
I have a sql statement , i need to assign to a variable in Unix
sel count(*) AS num_files from TABLE_A;
i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files (1 Reply)
I have a below syntax its working fine...
var12=$(ps -ef | grep apache | awk '{print $2,$4}')
Im getting expected output as below:
printf "%b\n" "${VAR12}"
dell 123
dell 456
dell 457
Now I wrote a while loop.. the output of VAR12 should be passed as input parameters to while loop and results... (5 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
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 DEBIAN
rackdiag
NWDIAG(1) General Commands Manual NWDIAG(1)NAME
rackdiag - generate rack-structure-diagram image file from spec-text file.
SYNOPSIS
rackdiag [options] files
DESCRIPTION
This manual page documents briefly the rackdiag commands.
rackdiag is generate sequence-diagram image file from spec-text file.
OPTIONS
These programs follow the usual GNU command line syntax, with long options starting with two dashes (`-'). A summary of options is
included below. For a complete description, see the Info files.
-h, --help
show this help message and exit.
--version
show program's version number and exit.
-a, --antialias
Pass diagram image to anti-alias filter.
-c FILE, --config=FILE
read configurations from FILE.
-o FILE
write diagram to FILE.
-f FONT, --font=FONT
use FONT to draw diagram.
-T TYPE
Output diagram as TYPE format.
SEE ALSO
The programs are documented fully by
http://blockdiag.com/en/nwdiag/
AUTHOR
rackdiag was written by Takeshi Komiya <i.tkomiya@gmail.com>
This manual page was written by Kouhei Maeda <mkouhei@palmtb.net>, for the Debian project (and may be used by others).
June 11, 2011 NWDIAG(1)