Yeah... For example.. consider the instance when we execute the statement and it iterates to find records that match the criteria... the output changes from:
There's a change right? Thats the only thing I want... It'll search for the string in Table_2, fetch the corresponding value and then update the same in Table1. I don't know the internal workings of SQL but what I was thinking was that if I delete the record which was just checked from Table_2, i can actually speed up the process of updating because it would then have to check less records each time it is checking.... Correct me if I'm wrong please... And the context in which I'm talking has some million records and thus I'm searching for a good way to speed up things...
I have a question:
Y X
Tabel a is a array multidimensional --> a(1024,20)
I load in to array a Text from 6000 row where:
in a(1,1) is present the row 1 of original text, in a(1024,1) is present then row 1024 of original test and in... (4 Replies)
Hi,
I have a file containing details of different departments . Infomration of departments is in various tags
file is as below
I want to create a new file from the above file which should contain only two fields belonging to one department
format
There are multiple files... (1 Reply)
Hi,
Please note that as a programmer I cannot tell the file format or details of my production files so I have re-framed my file and taken a case of departments. Kindly guide as its related to a production requirement of data containing recors of production customer NOT A HOMEWORK :)
I have... (10 Replies)
Hi All,
i have log file sample data is
2010/10/09|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/08|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/07|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/05|04:00:00.392|15Minute|BW=0|192.168.0.1
2010/10/03|04:00:00.392|15Minute|BW=0|192.168.0.1... (2 Replies)
ok im kinda stuck i have a bash script with 4 options
1. Create Script
2. Show Script
3 . Delete script
4. Exithow would i use an if statement for this? im not sure what test command i would use.
I know it would be like this (below) to display the script
if
then cat script1or for the... (10 Replies)
I have a script:
#!/bin/ksh
runmqsc CERN.PROD <<EOF
dis chs(to.*)
end
EOF
which gives me the output as:
1 : dis chs(to.*)
AMQ8417: Display Channel Status details.
CHANNEL(TO.CGPRODAPP2) CHLTYPE(CLUSRCVR)
CONNAME(10.60.16.50) CURRENT
... (5 Replies)
Gents,
I have an csv file which contends value GPS time for each record and x, y coordinates.. The purpose is to identify which vps does not match with the law parameters in the relation time and offset.
In the graphic attached you can see example of 3 vps which are showed in red color and... (12 Replies)
Hi,
I need some help taking a selection from a command and adding part of the output to an array.
I'd like to read the items into the array, have the user chose an option from the array and put the item from column 1 into a variable.
The command is:
awless -l list routetables --columns... (7 Replies)
Discussion started by: bignellrp
7 Replies
LEARN ABOUT DEBIAN
sql::statement::term
SQL::Statement::Term(3pm) User Contributed Perl Documentation SQL::Statement::Term(3pm)NAME
SQL::Statement::Term - base class for all terms
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::Term->new( $owner );
# access the value of that term
$term->value( $eval );
DESCRIPTION
SQL::Statement::Term is an abstract base class providing the interface for all terms.
INHERITANCE
SQL::Statement::Term
METHODS
new
Instantiates new term and stores a weak reference to the owner.
value
Abstract method which will return the value of the term. Must be overridden by derived classes.
DESTROY
Destroys the term and undefines the weak reference to the owner.
NAME
SQL::Statement::ConstantTerm - term for constant values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ConstantTerm->new( $owner, 'foo' );
# access the value of that term - returns 'foo'
$term->value( $eval );
DESCRIPTION
SQL::Statement::ConstantTerm implements a term which will always return the same constant value.
INHERITANCE
SQL::Statement::ConstantTerm
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the constant to deliver and a weak reference to the owner.
value
Returns the specified constant.
NAME
SQL::Statement::ColumnValue - term for column values
SYNOPSIS
# create a term with an SQL::Statement object as owner
my $term = SQL::Statement::ColumnValue->new( $owner, 'id' );
# access the value of that term - returns the value of the column 'id'
# of the currently active row in $eval
$term->value( $eval );
DESCRIPTION
SQL::Statement::ColumnValue implements a term which will return the specified column of the active row.
INHERITANCE
SQL::Statement::ColumnValue
ISA SQL::Statement::Term
METHODS
new
Instantiates new term and stores the column name to deliver and a weak reference to the owner.
value
Returns the specified column value.
AUTHOR AND COPYRIGHT
Copyright (c) 2009,2010 by Jens Rehsack: rehsackATcpan.org
All rights reserved.
You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
README file.
perl v5.10.1 2011-02-01 SQL::Statement::Term(3pm)