11-20-2005
evaluating params
Hi all,
I ve a script like....
TBL=employee
sql=`cat abhi.sql` \\ abhi.sql contains ------- select a from $TBL
echo $TBL
echo $sql
SQL=`echo $sql`
echo $SQL
now i want SQL as select a from employee
and as select a from $TBL
How can I achieve this?
Help appriciated
10 More Discussions You Might Find Interesting
1. HP-UX
i have hp-ux 11i on a rp2470 machine.
i'd like to change some kernel params with SAM.
i change the params, process new kernel and reboot the system.
after reboot i found that params does not change.
i have done the same things many times but i still have the pb.
plz what to do? (1 Reply)
Discussion started by: nabil_boussetta
1 Replies
2. UNIX for Advanced & Expert Users
Hi! How ican change parameters for daylight, i mean, i want change the daylight on december first week. I've tried with /usr/lib/tztab but result unsuccessful. (7 Replies)
Discussion started by: agustincm
7 Replies
3. Shell Programming and Scripting
i want to write a shell script that can be run as
./deployPortal.sh -version 5.1.2 -portlet -exportall
how can i do that?
version param is required. bu the others are optional.
in first step i only want to read 5.1.2, is portlet selected ? and is exportall selected ??
can you... (2 Replies)
Discussion started by: keromotti
2 Replies
4. Solaris
I am experienced with Solaris 8 where this type of thing was handled from /etc/system but now I have a Solaris 10 server and I am having trouble determining how to interact with the kernel parameters. I need to know how to check the values of the following, of the DB people I work with.
MAX... (8 Replies)
Discussion started by: NewSolarisAdmin
8 Replies
5. Shell Programming and Scripting
Hi all,
I need to call some script (s1) from within my shell script (s2). s1 accepts parameters and I want to feed it with values of params from my script. I tried many things but none work (I am so much of a beginner), please help
one of my attempts :
.
.
.
param1="hehe"
param2="haha"
... (12 Replies)
Discussion started by: Lorna
12 Replies
6. Shell Programming and Scripting
Hi,
Does awk ever resolve params in the search pattern?..
The following awk doesnt know how to resolve ${tables}$ inside a loop.
k=`awk '/${tables}$/ ${graph}`
The search pattern has ${tables}$ and I am narrowing down my search with a $ at the end of string.
So...this leaves me with a... (13 Replies)
Discussion started by: anduzzi
13 Replies
7. Shell Programming and Scripting
Hello!
I'm sorry if this is the false Forum, didn't really knew where to put it...
My question:
I have serveral USB-Sticks and wrote several Udev-Rules for theme, each Sticks needs to do something else, but all are using the same script (they have common tasks to do) and only some parts are... (2 Replies)
Discussion started by: al0x
2 Replies
8. Shell Programming and Scripting
I have 2 and three params, both I should make sure thay numbers at one single line insted of checking for each one .
Example I wroote the following way.. checking for 2 and three seperately but I shud be able to do it at on statement
echo $2 | egrep '^+$' >/dev/null 2>&1
if ; then
echo... (2 Replies)
Discussion started by: raopatwari
2 Replies
9. Shell Programming and Scripting
Hey i got trivial question but i cant figure it out. I want to grep a file for multiple unknown parameters. The user will enter these parameters at the command line. For example...
./program red apple filename
This would grep for the phrase red apple. But i cant just do $1 $2 because the... (8 Replies)
Discussion started by: GmGeubt
8 Replies
10. Shell Programming and Scripting
How to pass the getopts processed variable "${@}" to a function? It contains a list of package names needed in various functions.
Seems the issue I have is due to the order of the script, with the processed "${@}" falling after the unprossed "${@}".
I've been manually parsing options in the... (3 Replies)
Discussion started by: Cody Learner
3 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::view
SQL::Translator::Schema::View(3pm) User Contributed Perl Documentation SQL::Translator::Schema::View(3pm)
NAME
SQL::Translator::Schema::View - SQL::Translator view object
SYNOPSIS
use SQL::Translator::Schema::View;
my $view = SQL::Translator::Schema::View->new(
name => 'foo', # name, required
sql => 'select id, name from foo', # SQL for view
fields => 'id, name', # field names in view
);
DESCRIPTION
"SQL::Translator::Schema::View" is the view object.
METHODS
new
Object constructor.
my $view = SQL::Translator::Schema::View->new;
fields
Gets and set the fields the constraint is on. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
field names and keep them in order by the first occurrence of a field name.
$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );
my @fields = $view->fields;
tables
Gets and set the tables the SELECT mentions. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
table names and keep them in order by the first occurrence of a field name.
$view->tables('foo');
$view->tables('foo', 'bar');
$view->tables( 'foo, bar' );
$view->tables( [ 'foo', 'bar' ] );
$view->tables( qw[ foo bar ] );
my @tables = $view->tables;
options
Gets and sets a list of options on the view.
$view->options('ALGORITHM=UNDEFINED');
my @options = $view->options;
is_valid
Determine whether the view is valid or not.
my $ok = $view->is_valid;
name
Get or set the view's name.
my $name = $view->name('foo');
order
Get or set the view's order.
my $order = $view->order(3);
sql
Get or set the view's SQL.
my $sql = $view->sql('select * from foo');
schema
Get or set the view's schema object.
$view->schema( $schema );
my $schema = $view->schema;
equals
Determines if this view is the same as another
my $isIdentical = $view1->equals( $view2 );
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-05-01 SQL::Translator::Schema::View(3pm)