02-28-2008
Well, you are redirecting standard output to $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc
Either remove this redirection or change the ">>" into "2>"...
At least, assuming all the other stuff is OK...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies
2. Shell Programming and Scripting
I am executing a SQL query in Unix Server:
select status,location from user_information where request_id='DS-43720'
In shell script I am writing this query in the below manner:
echo "select status,location from user_information where request_id='DS-43720' ;" >> $directory/info.sql
... (3 Replies)
Discussion started by: debu
3 Replies
3. Shell Programming and Scripting
I created a script to read a csv file with four columns. The script also saved values of each col in a arry.
In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file.
select Num from tableName
where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies
4. Shell Programming and Scripting
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
5. UNIX for Advanced & Expert Users
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Discussion started by: jam_prasanna
6 Replies
6. Shell Programming and Scripting
#bash
curVer=`cat /var/sadm/clsversion | cut -f 2 -d "_"`
echo "CurVer:$curVer"
ls |grep -v tar| grep -v sh| grep -v log|cut -f 1 -d "_" | sort -u >tmp1
for line in $(cat tmp1)
do
ver=`echo $line_$curVer`
ls $line* |sort >tmp2
grep -n ${ver} tmp2 >/dev/null
... (2 Replies)
Discussion started by: rajamohan
2 Replies
7. Shell Programming and Scripting
I tried the below :
#!/bin/ksh
testvar=$(
sqlplus $user/$pass << EOF
set pagesize 0 feedback off verify off heading off echo off;
whenever sqlerror exit 1
SELECT 1+1 FROM DUAl;
COMMIT;
EXIT;
EOF)
echo "testvar="$testvar
The output that I am getting is :
> sh example.sh... (3 Replies)
Discussion started by: SriRamKrish
3 Replies
8. Shell Programming and Scripting
Hi,
I'm trying to asign to ksh varible some values of a sql query. The output query would be:
xxxx 1
yyyy 2
I do:
values=`$PATH_UTI/query_sh "
select think1||'------'||think2 from some_table
where think3 = '$1';
... (2 Replies)
Discussion started by: mierdatuti
2 Replies
9. Shell Programming and Scripting
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
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
tau_merge
TAU_MERGE(1) Tools TAU_MERGE(1)
NAME
tau_merge - combine multiple node and or thread TAU tracefiles into a merged tracefile
SYNOPSIS
tau_merge [-a] [-r] [-n] [-e eventfile_list] [-m output_eventfile] {tracefile_list} [{output_tracefile} { - }]
DESCRIPTION
tau_merge is generated when TAU is configured with the -TRACE option.
This tool assembles a set of tau trace and event files from multiple multiple nodes or threads across a program's execution into a single
unified trace file. Many TAU trace file tools operate on merged trace files.
Minimally, tau_merge must be invoked with a list of unmerged trace files followed by the desired name of the merged trace file or the -
flag to send the output to the standard out. Typically the list can be designated by giving the shared name of the trace files to be merged
followed by desired range of thread or node designators in brackets or the wild card character '*' to encompass variable thread and node
designations in the filename (trace.A.B.C.trc where A, B and C are the node, context and thread numbers respectively). For example
tautrace.*.trc would represent all tracefiles in a given directory while tautrace.[0-5].0.0.trc would represent the tracefiles of nodes 0
through 5 with context 0 and thread 0.
tau_merge will generate the specified merged trace file and an event definition file, tau.edf by default.
The event definition file can be given an alternative name by using the '-m' flag followed by the desired filename. A list of event
definition files to be merged can be designated explicitly by using the '-e' flag followed by a list of unmerged .edf files, specified in
the same manner as the trace file list.
If computational resources are insufficient to merge all trace and event files simultaneously the process may be undertaken hierarchically.
Corresponding subsets of the tracefiles and eventfiles may be merged in sequence to produce a smaller set of files that can then be to
merged into a singular fully merged tracefile and eventfile. E.g. for a 100 node trace, trace sets 1-10, 11-20, ..., 91-100 could be merged
into traces 1a, 2a, ..., 10a. Then 1a-10a could be merged to create a fully merged tracefile.
OPTIONS
-e eventfile_list explicitly define the eventfiles to be merged
-m output_eventfile explicitly name the merged eventfile to be created
- send the merged tracefile to the standard out
-a adjust earliest timestamp time to zero
-r do not reassemble long events
-n do not block waiting for new events. By default tau_merge will block and wait for new events to be appended if a tracefile is
incomplete. This command allows offline merging of (potentially) incomplete tracefiles.
EXAMPLES
To merge all TAU tracefiles into app.trc and produce a merged tau.edf eventfile:
tau_merge *.trc app.trc
To merge all eventfiles 0-255 into ev0_255merged.edf and TAU tracefiles for nodes 0-255 into the standard out:
tau_merge -e events.[0-255].edf -m ev0_255merged.edf
tautrace.[0-255].*.trc -
To merge eventfiles 0, 5 and seven info ev057.edf and tau tracefiles for nodes 0, 5 and 7 with context and thread 0 into app.trc:
tau_merge -e events.0.edf events.5.edf events.7.edf -m ev057.edf
tautrace.0.0.0.trc tautrace.5.0.0.trc tautrace.7.0.0.trc app.trc
SEE ALSO
tau_convert
tau2profile
tau2vtf
tau2elg
tau2slog2
12/22/2005 TAU_MERGE(1)