05-26-2010
Quote:
Originally Posted by
durden_tyler
In version 11.0.x and higher, specify "set nocount on" option to suppress the rows affected line.
In pre 11 versions, use sed to delete the lines that have the word "affected" in them.
tyler_durden
Is there any option like ,
establishing isql connection only once, and executing multiple queries and getting their respective record counts in separate variables...?
My need is like,
isql >>
recordcount1= query1
recordcount2= query2
>>
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am giving a grep command, and i am getting the output. i want to store it in a variable
for eg
a = grep '12345' /dir/1/2/log.txt ( the output is number)
b= grep 'basic' /dir/1/2/log1.txt (in this case the output is character)
so how to assign the output of grep to a variable
... (1 Reply)
Discussion started by: vasikaran
1 Replies
2. Shell Programming and Scripting
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)
Discussion started by: kattics
1 Replies
3. Shell Programming and Scripting
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. (3 Replies)
Discussion started by: tipsy
3 Replies
4. Shell Programming and Scripting
What I am trying to do is check if the database query returned any records.
If no records returned then output a message else output results to a file.
Right now if I take out the if and else statements the code runs fine and sends the email. If no records returned the email sends the column... (4 Replies)
Discussion started by: johnu122
4 Replies
5. Shell Programming and Scripting
Hi All-
First time using iSql.
I have 4 query files - some have more than 1 line of sql statements
After a bit of research it appears I can just use the -i command and specify the input file.
Questions:
Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)
Discussion started by: Cailet
3 Replies
6. Shell Programming and Scripting
Hello,
I am writing a ksh script on an AIX system. I need to get the date and time from a file into a variable. I found the following perl script from another post on this site and modified it slightly to output the format I need:
perl -e '@d=localtime ((stat(shift)));... (4 Replies)
Discussion started by: swimp
4 Replies
7. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: sudhakarpasala
1 Replies
8. Shell Programming and Scripting
I want output to be assigned to UNIX variables
echo "Enter RRS ID: "
read rrs
isql -SPROD_DDS -USYBUSER -PSYBPASS -b -osfg.out << EOF
use sip
go
set nocount on
select issuerId,
legalStructTxt,
productName,
issuerName
from sf_product
where rrsId = $rrs
go
EOF (1 Reply)
Discussion started by: JayDoshi
1 Replies
9. Shell Programming and Scripting
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}... (1 Reply)
Discussion started by: RookieDev
1 Replies
10. Shell Programming and Scripting
I am trying to run a query which returns a sum value(a number).
I want to get it in a variable so that i can refer to that variable in different places.
when i am running the following command
variable=`isql -Uuser -Sserver -Ppassword
1> select sum(count(*)) from xyz..abc where clm_id... (2 Replies)
Discussion started by: Sharma331
2 Replies
LEARN ABOUT PHP
yaz_search
YAZ_SEARCH(3) 1 YAZ_SEARCH(3)
yaz_search - Prepares for a search
SYNOPSIS
bool yaz_search (resource $id, string $type, string $query)
DESCRIPTION
yaz_search(3) prepares for a search on the given connection.
Like yaz_connect(3) this function is non-blocking and only prepares for a search to be executed later when yaz_wait(3) is called.
PARAMETERS
o $id
- The connection resource returned by yaz_connect(3).
o $type
- This parameter represents the query type - only "rpn" is supported now in which case the third argument specifies a Type-1 query
in prefix query notation.
o $query
- The RPN query is a textual representation of the Type-1 query as defined by the Z39.50 standard. However, in the text represen-
tation as used by YAZ a prefix notation is used, that is the operator precedes the operands. The query string is a sequence of
tokens where white space is ignored unless surrounded by double quotes. Tokens beginning with an at-character ( @) are considered
operators, otherwise they are treated as search terms.
RPN Operators
+-----------------------------+---------------------------------------------------+
| Construct | |
| | |
| | Description |
| | |
+-----------------------------+---------------------------------------------------+
| | |
| @and query1 query2 | |
| | |
| | intersection of query1 and query2 |
| | |
| | |
| @or query1 query2 | |
| | |
| | union of query1 and query2 |
| | |
| | |
| @not query1 query2 | |
| | |
| | query1 and not query2 |
| | |
| | |
| @set name | |
| | |
| | result set reference |
| | |
| | |
| @attrset set query | |
| | |
| | specifies attribute-set for query. This con- |
| | struction is only allowed once - in the beginning |
| | of the whole query |
| | |
| | |
|@attr [set] type=value query | |
| | |
| | applies attribute to query. The type and value |
| | are integers specifying the attribute-type and |
| | attribute-value respectively. The set, if given, |
| | specifies the attribute-set. |
| | |
+-----------------------------+---------------------------------------------------+
You can find information about attributes at the Z39.50 Maintenance Agency site.
Note
If you would like to use a more friendly notation, use the CCL parser - functions yaz_ccl_conf(3) and yaz_ccl_parse(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Query Examples
You can search for simple terms, like this:
computer
The query
"knuth donald"
This query applies two attributes for the same phrase.
The query
@and @or a b @not @or c d e
(a or b) and ((c or d) not e).
Another, more complex, one:
@attrset gils @and @attr 1=4 art @attr 1=2000 company
art occur in the title (GILS,BIB-1) and in which company occur as Distributor (GILS).
PHP Documentation Group YAZ_SEARCH(3)