i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated.
my sql query provide output some thing like this -
col1 col2 count
---- ---- ------
A B 10
c D 6
e... (8 Replies)
I would like to use the result of a query in another query. How do I redirect/add the output to another variable?
$result = odbc_exec($connect, $query);
while ($row = odbc_fetch_array($result)) {
echo $row,"\n";
}
odbc_close($connect);
?>
This will output hostnames:
host1... (0 Replies)
Hi Everyone,
When i issue command like
ls -l | awk '/udtts/ {print $9}'
===============================
I am getting output as
udttsGEHLNAR.6864
udttsGEHLNAR.7921
udttsNARALAX.15415
udttsNARALAX.18016
But I want output after dot i.e like
6864
7921
15415
18016 (3 Replies)
I am running a query with contains blank spaces in between in the output. But when I open and read the file in UNIX i am not able to cursor the balnk spaces instead it is moving like tabs. Please help
suppose my query -
Select ' '||text from tab1;
the cursor should move to 1st and... (1 Reply)
I want to print the output of a db2 query, on to an unix file in a manner that the columns are separated by 'commas'. Please help me out..thanx in advance (1 Reply)
Hi,
I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen.
snapshot of my script:... (13 Replies)
Following is the output of a command ran inside the script:
2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-02 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5 2015-01-29-05-38-03 5... (8 Replies)
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 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 CENTOS
vwright
VWRIGHT(1) General Commands Manual VWRIGHT(1)NAME
vwright - normalize a RADIANCE view, shift it to the right
SYNOPSIS
vwright [ view options ] distance
vwright [ view options ] name
DESCRIPTION
In the first form, vwright shifts a RADIANCE view the specified distance to the right, putting out a complete set of view parameters in a
single line on the standard output. This utility is most often used to compute a right-eyed view from a left-eye view for stereo imaging.
If no options are specified on the command line, vwright reads a view from its standard input.
The distance given is in world coordinate units. A negative value indicates a shift to the left rather than the right.
The second form substitutes a name prefix in place of the shift distance, and produces constant assignments on the standard output suitable
for passing directly to rcalc(1). For a given prefix N, the constant names are as follows:
Nt: view type ('v'==1,'l'==2,'a'==3,'h'==4,'c'==5,'s'==6)
Npx: view point x value
Npy: view point y value
Npz: view point z value
Ndx: view direction x value (normalized)
Ndy: view direction y value (normalized)
Ndz: view direction z value (normalized)
Nd: view focal distance
Nux: view up vector x value (normalized)
Nuy: view up vector y value (normalized)
Nuz: view up vector z value (normalized)
Nh: view horizontal size
Nv: view vertical size
Ns: view shift
Nl: view lift
No: view fore clipping distance
Na: view aft clipping distance
Nhx: derived horizontal image vector x value (normalized)
Nhy: derived horizontal image vector y value (normalized)
Nhz: derived horizontal image vector z value (normalized)
Nhn: derived horizontal image vector multiplier
Nvx: derived vertical image vector x value (normalized)
Nvy: derived vertical image vector y value (normalized)
Nvz: derived vertical image vector z value (normalized)
Nvn: derived vertical image vector multiplier
EXAMPLES
To start rpict(1) on a view .06 meters left of the view in the file "right.vf":
rpict `vwright -.06 < right.vf` scene.oct > right.hdr &
To move the rad(1) view named "left" 2.5 inches to the right and render from there:
rad -v "right `rad -n -s -V -v left examp.rif | vwright 2.5`" examp.rif &
To pass a view to rcalc for conversion to some other view:
rcalc -n -e `vwright orig < orig.vf` -f viewmod.cal -o view.fmt > new.vf
AUTHOR
Greg Ward
SEE ALSO pdfblur(1), rad(1), rcalc(1), rpict(1), rvu(1)RADIANCE 8/29/96 VWRIGHT(1)