05-14-2010
Quote:
Originally Posted by
vikram3.r
Actually with this option, the variable gets the value like '(1 row affected)' or '(0 rows affected)'. But i need only the exact record count. How to achieve this..?
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
This User Gave Thanks to durden_tyler For This Post:
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
MT(1) General Commands Manual MT(1)
NAME
mt - magnetic tape control
SYNOPSIS
mt [-f device] [count]
DESCRIPTION
Mt is a user interface to the magnetic tape commands described in mtio(4). It allows one to space a tape forwards or backwards, write end
of file markers, etc.
With the -f option a tape device can be named, otherwise the environment variable TAPE is used if set, otherwise the default device
/dev/nrst4 is assumed. Standard input is used if the tape name is a dash (-). The count argument is used to tell how many blocks or files
to space or how many file markers to write. It may be a C-style decimal, octal or hexadecimal constant, by default "1".
Command is the action to perform, it may be one of the following, or any unambiguous prefix (like st for status):
eof, weof Write count end-of-file markers.
fsf Forward space count file markers.
fsr Forward space count records. (The size of a record depends on the tape, and may even be variable, depending on the size of
the writes.)
bsf Backwards space count files. The count may be zero to backspace to the start of the current file. (A tape device need not
support backwards movement, or may be very slow doing it. Rewinding and forward spacing may be better.)
bsr Backwards space count records. The tape is positioned after the last block of the previous file if you hit a filemark when
spacing backwards. The block count is set to -1 to indicate that the driver has no idea where it is on the previous file.
eom Forward space to the end of media.
rewind Rewind the tape.
offline, rewoffl
Rewind and take offline. This may cause some drives to eject the tape.
status Shows the status of the drive, the sense key of the last SCSI error, current file number, current record number, residual
count if the last command that encountered end-of-file, and the current block size.
retension Removes tape tension by winding and rewinding the tape completely.
erase Erases the tape completely and rewinds it.
density Sets the density code to read or write the tape to count. Density codes supported depend on the drive. This command need
not be used if the drive senses the proper density on read and can only write one density.
blksize, blocksize
Sets the block size used to read or write the tape to count. This command may be used to select a fixed block size for a
variable block size tape. This will speed up I/O for small block sizes. Use a zero count to use variable sized blocks
again.
ENVIRONMENT
TAPE Tape drive to use if set.
FILES
/dev/nrst4 Default tape device.
SEE ALSO
mtio(4), st(4).
AUTHOR
Kees J. Bot (kjb@cs.vu.nl)
MT(1)