How to get the output of a ISQL command in a variable?
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
The output of the variable comes as below
while i am expecting output as 58.
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)
Using a ksh script, I'm dumping the data from our sybase database into an output file. This output file is for what ever reason cut at 2GB.
There is enough space on the unix machine and as there is no error message is received I have no clue to start looking for a solution.
#!... (1 Reply)
hi all
i m running following code
# set up environment
. /u/pimms/pimms_global.ksh
echo "Get record from database"
#echo ${PIMMS_ID}
#echo ${PIMMS_PWD}
#echo "1"
isql -U${PIMMD_ID} -P${PIMMS_PWD} -S$SRV << eof > /sybase/applications/pimms/bin/automate1.txt
use pimms
... (6 Replies)
Hi
I am formatting informix isql output(vertical) to horizontal format. Suppose I have the following content in the flat file from isql output -
item_nbr 0
usfn_label Subscriber Class
usfn_name SBCLASS
usfn_value bl5
item_nbr 1
usfn_label Switch Name
usfn_name switchName... (2 Replies)
isql output comes as below,
(0 rows affected)
(1 row affected)
(7 rows affected)
How to extract the resultset number alone from the particular line ??
such as
0
1
7 (3 Replies)
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)
Hi all,
I have wrote a script to redirect the output of Sybase query to a file.
Its a single XML message i am fetching with sybase query.
The problem i faced here is the XML message line crosses the normal line limit in unix.
Could some please help me how to get complete xml message... (1 Reply)
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)
I am using ISQL command in ksh script.
Suppose if i get NULL value from the query which i run,how can i handle it?
I am getting a NULL result set and the following error is coming.
############### output of isql command for getting the sum of JEs ################
-----------
NULL... (4 Replies)
Discussion started by: Sharma331
4 Replies
LEARN ABOUT DEBIAN
test::regression
Test::Regression(3pm) User Contributed Perl Documentation Test::Regression(3pm)NAME
Test::Regression - Test library that can be run in two modes; one to generate outputs and a second to compare against them
VERSION
Version 0.05
SYNOPSIS
use Test::Regression;
ok_regression(sub {return "hello world"}, "t/out/hello_world.txt");
DESCRIPTION
Using the various Test:: modules you can compare the output of a function against what you expect. However if the output is complex and
changes from version to version, maintenance of the expected output could be costly. This module allows one to use the test code to
generate the expected output, so that if the differences with model output are expected, one can easily refresh the model output.
EXPORT
ok_regression
FUNCTIONS
ok_regression
This function requires two arguments: a CODE ref and a file path. The CODE ref is expected to return a SCALAR string which can be compared
against previous runs. If the TEST_REGRESSION_GEN is set to a true value, then the CODE ref is run and the output written to the file.
Otherwise the output of the file is compared against the contents of the file. There is a third optional argument which is the test name.
ENVIRONMENT VARIABLES
TEST_REGRESSION_GEN
If the TEST_REGRESSION_GEN environment file is unset or false in a perl sense, then the named output files must exist and be readable and
the test will run normally comparing the outputs of the CODE refs against the contents of those files. If the environment variable is true
in a perl sense, then model output files will be overwritten with the output of the CODE ref.
AUTHOR
Nicholas Bamber, "<nicholas at periapt.co.uk>"
BUGS
Please report any bugs or feature requests to "bug-test-regression at rt.cpan.org", or through the web interface at
<http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Test-Regression>. I will be notified, and then you'll automatically be notified of
progress on your bug as I make changes.
testing of STDERR
The testing of stderr from this module is not as thorough as I would like. Test::Builder::Tester allows turning off of stderr checking but
not matching by regular expression. Handcrafted efforts currently fall foul of Test::Harness. Still it is I believe adequately tested in
terms of coverage.
SUPPORT
You can find documentation for this module with the perldoc command.
perldoc Test::Regression
You can also look for information at:
o RT: CPAN's request tracker
<http://rt.cpan.org/NoAuth/Bugs.html?Dist=Test-Regression>
o AnnoCPAN: Annotated CPAN documentation
<http://annocpan.org/dist/Test-Regression>
o CPAN Ratings
<http://cpanratings.perl.org/d/Test-Regression>
o Search CPAN
<http://search.cpan.org/dist/Test-Regression/>
ACKNOWLEDGEMENTS
Some documentation improvements have been suggested by toolic (http://perlmonks.org/?node_id=622051).
Thanks to Filip GraliXski for pointing out I need to test against output of zero length and providing a patch.
COPYRIGHT & LICENSE
Copyright 2009-10 Nicholas Bamber.
This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as
published by the Free Software Foundation; or the Artistic License.
See http://dev.perl.org/licenses/ for more information.
perl v5.10.1 2010-08-29 Test::Regression(3pm)