Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Hi,
I wanted to o/p the number of rows in a table to a variable in linux. How can i achieve this.
I wrote the query and its settings like feedback, pagesize line size in a file and using this file as a parameter to the sqlplus command. now can i redirect the o/p of that query to a variable.... (2 Replies)
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
How to redirect postgresql select query to a variable using shell scripts?
I tried to use
psql -c "select ip from servers" db | egrep '+\.+\+\+' | sed 's/^ *\(.*\) *$/\1/'
Output:
10.10.10.180
10.10.10.181
It display ip addresses from the databasem, but how could i redirect the... (3 Replies)
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Hi ,
I am purging two tables based on date.
In my script I am taking the count of the tables purging them and then taking the after counts. I need to mail the before and after counts of the two tables in a mail in table format as mentioned in the result section.
For Eg:
## Count of the... (14 Replies)
Hello,
I'm trying to send email from Greenplum query results as HTML table with status Red/Green
Select Server, Last_Date from Table;
Results
Server, Last_Date
Prod, 2018-04-09
Final email Output in HTML format
Server Status LastDate
Prod GREEN(BOX) 2018-04-09 (if... (2 Replies)
Good morning all,
This is the file name in question OD_Orders_2019-02-19.csv
I am trying to create a bash script to read into files with yesterdays date on the file name while retaining the rest of the files name. I would like for $y to equal, the name of the file with a formula output with... (2 Replies)
Discussion started by: Ibrahim A
2 Replies
LEARN ABOUT DEBIAN
recoll
RECOLL(1) General Commands Manual RECOLL(1)NAME
recoll - user interface for the Recoll full text search system
SYNOPSIS
recoll [ -c <configdir> ] [ -o | -l | -f | -a ] [ -t ] [ -q <query> ]
DESCRIPTION
The recoll command will start the graphical user interface for querying the Recoll database.
On the first run, recoll will create the user configuration which can be customized before starting the first indexation.
The -c option specifies the configuration directory name, overriding the default or $RECOLL_CONFDIR.
The -q option can be used to specify an initial query on the command line. This query will be interpreted by default as a query language
string. If -a is specified, the query string will be interpreted as an all words simple search query. If -o is specified, the query string
will be interpreted as an any word simple search query. If -f is specified, the query string will be interpreted as a file name simple
search query. If -l is specified, the query string will be interpreted as a query language simple search query.
If -t is specified, the Graphical User Interface will not be started, and results will be printed to the standard output. Additional
options understood by the recollq command may be specified in this case. These can control the output format and the maximum number of
results to be printed.
Please refer to online help for a full description.
SEE ALSO recollindex(1)recollq(1)recoll.conf(5)
8 January 2006 RECOLL(1)