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
go::parsers::base_parser
GO::Parsers::base_parser(3pm) User Contributed Perl Documentation GO::Parsers::base_parser(3pm)NAME
GO::Parsers::base_parser - base class for parsers
SYNOPSIS
do not use this class directly; use GO::Parser
DESCRIPTION AUTHOR
show_messages
Usage -
Returns -
Args -
normalize_files
Usage - @files = $parser->normalize_files(@files)
Returns -
Args -
takes a list of filenames/paths, "glob"s them, uncompresses any compressed files and returns the new file list
litemode
Usage - $p->litemode(1)
Returns -
Args - bool
when set, parser will only throw the following events:
id|name|is_a|relationship|namespace
(optimisation for fast parsing)
acc2name_h
Usage - $n = $p->acc2name_h->{'GO:0003673'}
Returns - hashref
Args - hashref [optional]
gets/sets a hash mapping IDs to names
this will be automatically set by an ontology parser
a non-ontology parser will use this index to verify the parsed data (see $p->acc_not_found($id), below)
acc_not_found
Usage - if ($p->acc_not_found($go_id)) { warn("$go_id not known") }
Returns - bool
Args - acc string
uses acc2name_h - if this hash mapping has been created AND the acc is not in the hash, THEN it is considered not found
This is useful for non-ontology parsers (xref_parser, go_assoc_parser) to check whether a referenced ID is actually present in the ontology
note that if acc2name_h has not been created, then accs cannot be considered not-found, and this will always return 0/false
perl v5.14.2 2010-07-24 GO::Parsers::base_parser(3pm)