Hi my UNIX Friends,
Im calling some SQL scripts through Unix Shell scripting.
How do I export the value of PL/SQL variable value into a Unix shell script variable?
Also could any one inform me about the 'search' and 'cut' utility of PL/SQL
(like 'grep' and 'cut' in Shell scripting).
... (10 Replies)
Hi Folks,
This is a small chunk of the bigger problem which i am facing and some help here will help me resolve the rest of the issue.
Problem is that i need to pass the value of a variable from a shell script to a SQL query (infact a lot of SQL's)
i have the following solution but somehow... (4 Replies)
hi I all ,
I have sql statment in my shell script , I pass two argument to the script I need to pass the this two arguments to the sql statment
example :
runsql.sh "1" "2"
sql :
updat tables_x set y=0
where
A=:x should subsituted by "1"
and
B=:y shuold subsituted bt "2"... (1 Reply)
Hi Gurus,
i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script.
ex:
abc.txt
2345
2346
1243
1234
i need to pass these arguments to .sql script rom unix
ex:
select * from... (1 Reply)
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
I have a requirement where i have a sql file (filetext.sql). This file contains a variable ss_code.
Now in a shell script im trying to replace the variable ss_code with a value contained in the shell script variable MTK_DC..tried the below in the script
MTK_DC="mit,cit,bit"
OUT=`awk -v... (4 Replies)
Here is the requirement, When I run the "run file KSH (sql)", it should substitute
'${pCW_Bgn_DT}' with 201120
and
'${pCW_End_DT}' with 201124
Input File
----------
$ cat prevwk.dat
201124 20110711
run file KSH (sql)
------------------
In this file, I want to use the variables... (1 Reply)
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
How to pass variable to sql file.
Im tryin in two ways,
Method 1:
my.sql
select * from table where col1 = '$1' and col2 = 'text';
Method 1execute: dbaccess database my.sql $var
Method2:
select * from table col1 in (`cat inputfile`) and col2 = 'text';
method... (2 Replies)
OS Solaris 10,
DB oracle 10g
Hello,
We currently have a BASH script that runs and moves image files from a remote server to the local db server. A snippet of the code shows that we are picking up all Images that are 'mtime -1'
some code...
for file in `ssh user@10.200.200.10 'find... (3 Replies)
Discussion started by: JonP
3 Replies
LEARN ABOUT DEBIAN
asn2fsa
ASN2FSA(1) NCBI Tools User's Manual ASN2FSA(1)NAME
asn2fsa - convert biological sequence data from ASN.1 to FASTA
SYNOPSIS
asn2fsa [-] [-A acc] [-D] [-E] [-H] [-L filename] [-T] [-a type] [-b] [-c] [-d path] [-e N] [-f path] [-g] [-h filename] [-i filename] [-k]
[-l] [-m] [-o filename] [-p path] [-q filename] [-r] [-s] [-u] [-v filename] [-x str] [-z]
DESCRIPTION
asn2fsa converts biological sequence data from ASN.1 to FASTA.
OPTIONS
A summary of options is included below.
- Print usage message
-A acc Accession to fetch
-D Use Dash for Gap
-E Extended Seq-ids
-H HTML spans
-L filename
Log file
-T Use Threads
-a type
Input ASN.1 type:
a Automatic (default)
z Any
e Seq-entry
b Bioseq
s Bioseq-set
m Seq-submit
t batch processing (suitable for official releases; autodetects specific type)
-b Bioseq-set is Binary
-c Bioseq-set is Compressed
-d path
Path to ReadDB Database
-e N Line length (70 by default; may range from 10 to 120)
-f path
Path to indexed FASTA data
-g Expand delta gaps into Ns
-h filename
Far component cache output file name
-i filename
Single input file (standard input by default)
-k Local fetching
-l Lock components in advance
-m Master style for near segmented sequences
-o filename
Nucleotide Output file name
-p path
Path to ASN.1 Files
-q filename
Quality score output file name
-r Remote fetching from NCBI
-s Far genomic contig for quality scores
-u Recurse
-v filename
Protein output file name
-x str File selection substring (.ent by default) [String]
-z Print quality score gap as -1
AUTHOR
The National Center for Biotechnology Information.
SEE ALSO asn2all(1), asn2asn(1), asn2ff(1), asn2gb(1), asn2xml(1), asndhuff(1).
NCBI 2011-09-02 ASN2FSA(1)