I have a working SQL-Query here, in which I'm using subqueries to get the needed result.
The idea behind this, is to get a list of networks which have 2 tags set in the database. Because of the way it is stored, i get a tuple for each Tag, so I get a duplicate of all networks.
The Tables and the query:
The result without the subqueries:
Subqueries are evil in terms of performance. The last time I worked with this, I wrapped it in some lines of code and sorted out the duplicates.
I'm wondering if there's not a more clever alternative in plain SQL, which is not such a performance killer than the subqueries.
I have a script that looks for all jobs that contain a particular calendar.
Some of the calendars have '&' in them and sql freaks out when it encounters that.. is there a way around this?
I have tried:
select job_name from job where run_calendar='1&15dom'
select job_name from job... (3 Replies)
Hi ...
I am doing a switch user and then rsh and then running a sql query .
I am successfull in rsh and logging into the database , but my query doesnt run ..
Here's the command :
su - linus -c "rsh -l linus psmf ORACLE_SID=SMP;export ORACLE_SID;sqlplus... (1 Reply)
Hello Everyone,
I am looking to write a script that will run on many machines in a network at the same time. They need to write a result to a common location. I plan to use a SQLlite database as this common writing point. But the concern I have is how SQLlite will react to multiple writes that... (1 Reply)
Hi,
I am passing an argument for the script and that argument values should exist in database.
bill_period_input="'""$1""'"
bill_period=`sqlplus uname/pwd@dbname <<eof!
set verify off
set heading off
set feedback off
select bill_period from bill_period_ref where... (4 Replies)
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Hi Everyone,
Can anyone pls help me out......with my requirement, i am struggling since 3 days. Please find the requirement below
my file contains below data
R1|Array/Network Resistor - VIP|V_RES_CLASS|V_MOUNT_FEATURE|SURFACE MOUNT|AND|8533.10.00.20|8533.10.00.20|
R1|Array/Network Resistor... (9 Replies)
I used the following code
code
select * from tablename where columnname
Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem?
Thanks
Ananth (2 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi All ,
I have tried many times am getting syntax error on 'UNION'
can anybody tell me ...
INSERT INTO table1
(
Type
, num_items
, num_letters
, total_value
)
(select
type='1',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2
where
num_items = 1 (1 Reply)
Hello All,
I hope I'm posting this in the right section.
I have zero sql query writing skill, in fact, I've never done it before, but for some reason, a request came across my desk to get information from one of our databases. I have about 200 ticket numbers that have no information attached,... (8 Replies)
Discussion started by: bbbngowc
8 Replies
LEARN ABOUT DEBIAN
bio::alignio::arp
Bio::AlignIO::arp(3pm) User Contributed Perl Documentation Bio::AlignIO::arp(3pm)NAME
Bio::AlignIO::arp - ARP MSA Sequence input/output stream
SYNOPSIS
Do not use this module directly. Use it via the Bio::AlignIO class.
DESCRIPTION
This object can create Bio::SimpleAlign objects from ARP flat files. These are typically configuration-like data files for the program
Arlequin. For more information, see:
http://lgb.unige.ch/arlequin/
For the moment, this retains the allele sequence data in the DATA section and inserts them into SimpleAlign objects. ARP files that contain
other data (RFLP, etc.) are not expected to parse properly. Also, if the DNA data is actually SNP data, then the LocatableSeq object
instantiation will throw an error.
This is now set up as a generic parser (i.e. it parses everything) and collects as much data as possible into the SimpleAlign object. The
following in a general mapping of where data can be found:
Tag SimpleAlign
Method
----------------------------------------------------------------------
Title description
SampleName id
----------------------------------------------------------------------
Tag Bio::Annotation TagName Bio::Annotation
Class Parameters
----------------------------------------------------------------------
NE SimpleValue pfam_family_accession value
NL SimpleValue sequence_start_stop value
SS SimpleValue sec_structure_source value
BM SimpleValue build_model value
RN Reference reference *
----------------------------------------------------------------------
* RN is generated based on the number of Bio::Annotation::Reference objects
In addition, the number of samples found in the alignment is retained in a Bio::Annotation::TagTree object in the annotation collection and
is accessible via:
($samples) = $aln->annotation->get_Annotations('Samples');
say $samples->display_text;
# or use other relevant TagTree methods to retrieve data
FEEDBACK
Support
Please direct usage questions or support issues to the mailing list:
bioperl-l@bioperl.org
rather than to the module maintainer directly. Many experienced and reponsive experts will be able look at the problem and quickly address
it. Please include a thorough description of the problem with code and data examples if at all possible.
Reporting Bugs
Report bugs to the Bioperl bug tracking system to help us keep track the bugs and their resolution. Bug reports can be submitted via the
web:
https://redmine.open-bio.org/projects/bioperl/
AUTHORS
Chris Fields (cjfields)
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
next_aln
Title : next_aln
Usage : $aln = $stream->next_aln
Function: returns the next alignment in the stream.
Returns : Bio::Align::AlignI object - returns 0 on end of file
or on error
Args : -width => optional argument to specify the width sequence
will be written (60 chars by default)
See Bio::Align::AlignI
write_aln
Title : write_aln
Usage : $stream->write_aln(@aln)
Function: writes the $aln object into the stream in xmfa format
Returns : 1 for success and 0 for error
Args : L<Bio::Align::AlignI> object
See Bio::Align::AlignI
perl v5.14.2 2012-03-02 Bio::AlignIO::arp(3pm)