Setting variable for query using iSql / Korn Shell Post: 302285652

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting value of Shell variable from within ISQL

Hi Guys, Need help. I am using ISQL inside a shell script. Is there a way to set the value of shell script variable from inside the ISQL code. I do not want to write the results from the SQL to an output file. Please let me know. Regards, Tipsy.

2. Shell Programming and Scripting

compound variable in korn shell

in a text " Korn Shell Unix programming Manual 3� Edition" i have found this sintax to declare a compoud variable: variable=( fild1 fild1 ) but this sintax in ksh and sh (HP-UNIX) not work... why?? exist another solution for this type of variable ???

3. Shell Programming and Scripting

isql query in unix shell script

Dear all I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below. isql -U -P use gdb_1 go select count (*) from table_x go

4. UNIX for Dummies Questions & Answers

Using isql in korn shell

Hi all, I have two accounts in a Unix server, the first one uses .tcsh as default shell and the other uses .ksh (korn shell) as default. When I login using the account with .tcsh default, I can use the isql command and connect to our database server. However, when I use the other...

5. Shell Programming and Scripting

Isql query in unix shell

Hi i want write a script for list of sysbase are having access or open. then i wrote like: USER="abc" PASS="xyz" SERVER="SCCS" DB="blue" WORK_DIR="/usr/home/ramakrishna" set -x isql -U${USER} -P${PASS} -S${SERVER}<<EOF>$WORK_DIR/output.log go use blue (database name) go use...

6. UNIX for Dummies Questions & Answers

Korn Shell Script / Clearcase Query

Hi, I wonder can you help me ... I have the following clearcase code that works on the command line: ct mkattr -replace Four_Legs '"cat dog"' lbtype:Animal however when i try to use it in my script it fails with the following error message: + ct mkattr -replace Four_Legs "cat dog"...

7. Shell Programming and Scripting

How to assign record count output of isql to a shell variable ?

isql select count(*) from Table eof How to assign record count output of isql query to a shell variable ?

8. Programming

How to refer to variable (korn shell)?

Hi I have the following block of code in korn shell and don't now how to refer to variable `print variable1.$dvd` ? --- integer dvd=4 integer number=0 while (( dvd!=0 )) do print "Iteracja numer : $dvd" print "$_" #it refers to $dvd var but want to refer...

9. UNIX for Dummies Questions & Answers

how to use shell variable in isql

Hi , I want to use shell variable in isql. example.. $ksh ./sudh.ksh "2041qwer" sudh.ksh is my script passing the perameter "2041qwer" Code in my script : =========== $SYBASE/$SYBASE_OCS/bin/isql -I$SYBASE/interfaces -S$OTHRSRVR -U$SYBUSER -P$SYBPASS -w...

10. Shell Programming and Scripting

Return value inside isql to a shell variable in ksh

Hello, I have a shell script where I am doing an isql to select some records. the result i get from the select statement is directed to an output file. I want to assign the result to a Shell variable so that I can use the retrieved in another routine. e.g. "isql -U${USER} -P${PASSWD} -S${SERVER}...

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Setting value of Shell variable from within ISQL

Discussion started by: tipsy

2. Shell Programming and Scripting

compound variable in korn shell

Discussion started by: ZINGARO

3. Shell Programming and Scripting

isql query in unix shell script

Discussion started by: jaydeep_sadaria

4. UNIX for Dummies Questions & Answers

Using isql in korn shell

Discussion started by: risk_sly