07-28-2015
Hello Arun,
We would like to know following answers please on your request.
1st: What you have tried so far?
2nd: Do you want anything to fetch from the output of above queries?
3rd: If yes for above, then please do show us the output (Please make it is as a habit to show input and expected output).
4th: If any other information which is necessary to be added should be included too.
Thanks,
R. Singh
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. Currently, the script will stop at a cursor where I can then manually enter the SQL statment. This is... (11 Replies)
Discussion started by: MadHatter
11 Replies
2. Shell Programming and Scripting
Hi,
I want to get the value of the first field till space in a variable.
e.g x=323 /test/personel/logs/File1
I want to get the first field till space i.e 323 in another variable ,lets say y.
echo $x|cut -d' ' -f1 gives 323
but when I'm trying y=`echo $x|cut -d' ' -f1 its giving... (3 Replies)
Discussion started by: autosys_nm
3 Replies
3. Shell Programming and Scripting
Hi,
I am trying to execute this command
if ; then
but getting error .Some problem with reteriving the value of $exception_info.
Please help.Its urgent.
thanks (4 Replies)
Discussion started by: khushboo
4 Replies
4. Shell Programming and Scripting
Hi,
I am writing a script which creates an external table using a shell script. My requirement is like this.
Usage: . ./r.ksh <table_name> - this should create an external table.
e.g . ./r.ksh abc - this should create an external table as abc_external.
How do i achieve this? Please... (5 Replies)
Discussion started by: Anaramkris
5 Replies
5. UNIX for Dummies Questions & Answers
Hi Guys,
I have written a script that declares all the variables and its values in a conf file.
Now i use a variable whose value i need to change it in one of the sub-file that is used in the script.
In the startup file i want to print or check its value.
The value get changed and printed... (5 Replies)
Discussion started by: Swapna173
5 Replies
6. Shell Programming and Scripting
Hi,
I am trying to fetch the different values in an xml file by searching with the same variable in AIX Server.
<name>SharedResources/Shared/JNDI/Username</name>
<value>admin</value> <name>SharedResources/Shared/JNDI/Username</name>
... (1 Reply)
Discussion started by: tejastrikez
1 Replies
7. Shell Programming and Scripting
Hi, I'm a it stuck on the below code where a variable is pulled from sqlplus and used in awk. It runs with no errors but still pulls back all records in the input file.
It should pull the max reference from sql plus and then only print those records where the reference value in column 1 is... (4 Replies)
Discussion started by: jonathanb30
4 Replies
8. UNIX for Advanced & Expert Users
I am having a file called variable_info.ksh in that file I am having following global variable information like…
EMAIL_PATH=/var/mail
TMP_PATH=/home/tmp
And we are having another temporary parameter file abcd.txt, in that file we are having the following information like…
EMAIL|EMAI_PATH
I... (4 Replies)
Discussion started by: mesahammad
4 Replies
9. Shell Programming and Scripting
Input.txt
NOTE1|VALUE1|HMM|UPSTR|
NOTE2||HMP|UPSTR|
NOTE3|VALUE3|HML|UPSTR|
NOTE4||HMD|UPSTR|
NOTE5|VALUE5|HMS|UPSTR|
NOTE6|VALUE6|HSD|UPSTR|
NOTE7||HSS|UPSTR|
NOTE8|VALUE8|HEE|UPSTR|
NOTE9|VALUE9|HER|DOWNSTR|
NOTE50|VALUE1|HEE|DOWNSTR|
I am trying to read field 1, 2 and 3 from the... (4 Replies)
Discussion started by: Joselouis
4 Replies
10. UNIX for Beginners Questions & Answers
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT DEBIAN
bio::taxonomy::factoryi
Bio::Taxonomy::FactoryI(3pm) User Contributed Perl Documentation Bio::Taxonomy::FactoryI(3pm)
NAME
Bio::Taxonomy::FactoryI - interface to define how to access NCBI Taxonoy
DESCRIPTION
NB: This module has been deprecated.
$factory->fetch is a general method to fetch Taxonomy by either NCBI taxid or any types of names.
$factory->fetch_parent($taxonomy), returns a Taxonomy that is one-step higher rank of the taxonomy specified as argument.
$factory->fetch_children($taxonomy), reports an array of Taxonomy those are one-step lower rank of the taxonomy specified as the argument.
AUTHOR - Juguang Xiao
juguang@tll.org.sg
CONTRIBUTORS
Additional contributors' names and emails here
APPENDIX
The rest of the documentation details each of the object methods. Internal methods are usually preceded with a _
fetch
Title: fetch
Usage: my $taxonomy = $factory->fetch(-taxon_id => 9605);
my $taxonomy = $factory->fetch(-common_name => 'mammals');
Fuctnion: Fetch taxonomy by taxon_id, common name or scientific name.
Returns: an instance of Bio::Taxonomy
Args: -taxon_id => NCBI taxonomy ID
-common_name => comon name, such as 'human', 'mammals'
-scientifc_name => specitic name, such as 'sapiens', 'Mammalia'
fuzzy_fetch
Title: fuzzy_fetch
Usage: my @taxonomy = $factory->fuzzy_fetch(-name => 'mouse');
Function: Fuzzy fetch by name, or any text information found in DB
Returns: an array reference of Bio::Taxonomy objects
Args: -name => any name, such as common name, variant, scientific name
-description, or -desc => any text information
fetch_parent
Title: fetch_parent
Usage: my $parent_taxonomy = $factory->fetch_parent($taxonomy);
Function: Fetch the parent that is one-rank higher than the argument.
Returns: an instance of Bio::Taxonomy, or undef if the arg is the top one.
Args: a Bio::Taxonomy object.
fetch_children
Title: fetch_children
Usage: my @children_taxonomy = $factory->fetch_children($taxonomy);
Function: Fetch all children those are one-rank lower than the argument.
Returns: an array reference of Bio::Taxonomy objects
Args: a Bio::Taxonomy object.
perl v5.14.2 2012-03-02 Bio::Taxonomy::FactoryI(3pm)