If I execute this script:
$ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log
$DB_id/$DB_pswd@$DB_server
start test.sql
EOF
the sql script executes with no errors.
IF I execute the following script:... (12 Replies)
i have script say some_script.ksh that takes an argument
I need to run some_script.ksh in background parallely at the sametime with different arguments.
Once all the background jobs complete, i need to run this script again in parallel with another 5 set of arguments.
Would really... (1 Reply)
Hi All,
I have 3 shell scripts, Script1,Script2 and Script3. Now I want to run Script1 and Script2 in parallel and Script3 should depend on successful completion of both Script1 and Script2.
Could you please suggest an approach of acheiving this...
Thanks in advance (2 Replies)
Hello,
I have a shell script "Test.ksh" and I need to pass 8 parameters/arguments while executing the script
./Test.ksh 1 2 3 4 5 6 7 8
Out of these I want first 3 to be compulsory and rest 5 to be optional. Can you suggest the way to do this like and also how to pass these optional... (3 Replies)
Hi,
I am stuck into a situation where i want to execute a command in my shell script well along with a previous command in order to achieve something but i am not figuring out a way.
here is a snippet:
service management restart
rm -rf lock.file
in the above, if you see, i am trying to... (5 Replies)
i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes
sqlplus username1/password1@DB1 @sql >> log1 &
sqlplus username2/password2@DB2 @sql2 >> log1 &
how can i execute the... (7 Replies)
I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit.
Sample Query:
SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2
SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2
... (2 Replies)
Hi ,
I have a script which is using a text file as I/P.
I want a code where it reads n lines from this file and pass the parameters to a function and now this script should run in such a way where a function can be called in parallel with different parameters. Please find below my script, it... (1 Reply)
Hello,
This is my Script which configure a list of nodes. ( 40 nodes, and the configuration 10 minutes)
#! /bin/sh
if
then
echo "USE: ./start.sh nodes
else
nb_lignes=`wc -l $1 | cut -d " " -f1`
echo "$nb_lignes machines"
for i in $(seq $nb_lignes)
//instructions
done
fi
My... (2 Replies)
Hi Folks,
I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with ideas on how this can be achieved?
create table list_of_sql
(
id number,
full_sql... (3 Replies)
Discussion started by: member2014
3 Replies
LEARN ABOUT DEBIAN
tangram::type::set::frommany
Tangram::Type::Set::FromMany(3pm) User Contributed Perl Documentation Tangram::Type::Set::FromMany(3pm)NAME
Tangram::Type::Set::FromMany - maps Set::Object using a link table
SYNOPSIS
use Tangram;
# or
use Tangram::Core;
use Tangram::Type::Set::FromMany;
$schema = Tangram::Schema->new(
classes => { Company => { fields => {
set =>
{
# long form
employee =>
{
class => 'Person',
table => 'Company_employees',
coll => 'company',
item => 'employee',
},
# short form
assets => 'Asset',
}
DESCRIPTION
Maps a reference to a Set::Object. The persistent fields are grouped in a hash under the "set" key in the field hash.
The set may contain only objects of persistent classes. These classes must have a common persistent base class.
Tangram uses a link table to save the state of the collection. The table has two columns: one contains the id of the container objects; the
other contains the ids of the elements.
The field names are passed in a hash that associates a field name with a field descriptor. The field descriptor may be either a hash or a
string. The hash uses the following fields:
* class
* aggreg
* table
* coll
* item
* deep_update
Mandatory field "class" specifies the class of the elements.
Optional field "aggreg" specifies that the elements of the collection must be removed (erased) from persistent storage along with the con-
taining object. The default is not to aggregate.
Optional field "table" sets the name of the link table. This defaults to 'C_F', where C is the class of the containing object and F is the
field name.
Optional field "coll" sets the name the column containing the ids of the containing objects. This defaults to 'coll'.
Optional field "item" sets the name the column containing the ids of the elements. This defaults to 'item'.
Optional field "deep_update" specificies that all elements have to be updated automatically when "update" is called on the collection
object. Automatic update ensures consisitency between the Perl representation and the DBMS state, but degrades update performance so use it
with caution. The default is not to do automatic updates.
If the descriptor is a string, it is interpreted as the name of the element's class. This is equivalent to specifying only the "class"
field in the hash variant.
perl v5.8.8 2006-03-29 Tangram::Type::Set::FromMany(3pm)