03-16-2008
Can you please explain how to do that?
Also, can you recommened any books aimed at beginners?
Thanks
10 More Discussions You Might Find Interesting
1. Solaris
I need to add a PCI NIC to a sunblade 100 running solaris 8. Im new to this and was hoping someone could give me some card names and models which will work for this system and has a driver for this sparc system.
thanks (3 Replies)
Discussion started by: meyersp
3 Replies
2. Solaris
hii alll
i have a problem with my sunblade100. when i switch on, no display comes but if i ping from a remote machine its pinging,but iam not able to telent to that sun server,what can be the problem,how can i sort ot this issue
2 thing in usb iam not able to use STOP N (to clear the... (3 Replies)
Discussion started by: solaris8in
3 Replies
3. Solaris
I have a sunblade 100. It is preloaded with Solaris 8 but I do not have root password. I want to erase and install Solaris 9 on it. What are my options?
I have a CD ROM. Could any one help me in getting started to install in from CDs? Appreciate your help guyz. (3 Replies)
Discussion started by: stevelrf
3 Replies
4. Solaris
Question,
when adding memory to a SunBlade 100, are you required to add it in matched pairs? My current box has 2 x 256mb sticks of PC-133 ram. I tried adding 1 512mb sticks and the system failed to come up. I saw at Sunsolve that you can mix and match different sized memory. (5 Replies)
Discussion started by: stocksj
5 Replies
5. Solaris
Hi guys,
I have a SunBlade 2000 that I am trying to configure. It has been configured previously with an IP address, hostname, DNS and so forth. I want to configure it with a new IP address. How can I achieve this? It has been one of the most difficult tasks for me as I am not really... (6 Replies)
Discussion started by: Arkayev
6 Replies
6. Solaris
Greetings,
I was in the mood of upgrading my sunblade100 in my bedroom, since I recuperated some RAM from intel servers, and found myself with what seems to not work (I was hoping to pass from 256Mb to 2GB... and then upgrading to solaris 10...)
after this failure I tried with just one 512 MB,... (2 Replies)
Discussion started by: vbe
2 Replies
7. Solaris
HW: SunBlade 1000 w/2x CPUs, DVD-ROM, XVR-1200
SW: Solaris 10 DVDs direct from Sun
Tried: probing scsi, boot -r, reset-all
When booting off cd: boot cdrom
Boot device: /pci@8, 700000/scsi/scsi@6/disk@6,0:f File and args:
SunOS Release 5.10 Version Generic_141444-09 64-bit
Copyright... (8 Replies)
Discussion started by: boolean2
8 Replies
8. Solaris
Hi everyone!
so i will warn you now, i was thrown into an IT position that is a tad over my head with everything it covers mainly with linux, so i'm pretty noobish. But i need to wipe a ton of sun scsi hard drives with this sunblade 1000 and i have no idea how to boot to the dvd of solaris 10 to... (3 Replies)
Discussion started by: Panther8644
3 Replies
9. Solaris
Good Morning,
I took a mirror drive from one Solaris 9 machine and used it to set up another. After syncing another mirror on the second machine I restarted but I don't get a login screen.
I see a message:The X-server cannot be started on display :0
Also during startup I see:... (8 Replies)
Discussion started by: Stellaman1977
8 Replies
10. UNIX for Beginners Questions & Answers
Good Afternoon,
I'm setting up a SunBlade 2500 using ufsrestoreand have gotten to the point where I have restored the root and usr partitions. However, the machine keeps rebooting, never really coming up. Looking at vfstab, it looks pretty empty- shouldn't I see entries like... (22 Replies)
Discussion started by: Stellaman1977
22 Replies
LEARN ABOUT DEBIAN
data::phrasebook::sql
Data::Phrasebook::SQL(3pm) User Contributed Perl Documentation Data::Phrasebook::SQL(3pm)
NAME
Data::Phrasebook::SQL - The SQL/DBI Phrasebook Model.
SYNOPSIS
use Data::Phrasebook;
use DBI;
my $dbh = DBI->connect(...);
my $book = Data::Phrasebook->new(
class => 'SQL',
dbh => $dbh,
file => 'queries.txt',
);
my $q = $book->query( 'find_author', {
author => "Lance Parkin"
});
while ( my $row = $q->fetchrow_hashref ) {
print "He wrote $row->{title}
";
}
$q->finish;
queries.txt:
find_author=select title,author from books where author = :author
DESCRIPTION
In order to make use of features like placeholders in DBI in conjunction with phrasebooks, it's helpful to have a phrasebook be somewhat
more aware of how DBI operates. Thus, you get "Data::Phrasebook::SQL".
"Data::Phrasebook::SQL" has knowledge of how DBI works and creates and executes your queries appropriately.
CONSTRUCTOR
new
Not to be accessed directly, but via the parent Data::Phrasebook, by specifying the class as SQL.
Additional arguments to those described in Data::Phrasebook::Generic are:
o "dbh" - a DBI database handle.
METHODS
dbh
Set, or get, the current DBI handle.
query
Constructs a Data::Phrasebook::SQL::Query object from a template. Takes at least one argument, this being the identifier for the query. The
identifier is used as a key into the phrasebook "file". A second argument can be provided, which is an optional hashref of key to value
mappings.
If phrasebook has a YAML source looking much like the following:
---
find_author:
sql: select class,title,author from books where author = :author
You could write:
my $q = $book->query( 'find_author' );
OR
my $q = $book->query( 'find_author', {
author => 'Lance Parkin'
} );
OR
my $author = 'Lance Parkin';
my $q = $book->query( 'find_author', {
author => $author,
} );
# sql = select class,title,author from books where author = ?
# args = 'Lance Parkin'
In the above examples, the parameters are bound to the SQL using the bind parameters functionality. This is more efficient in most cases
where the same SQL is reused with different values for fields.
However, not all SQL statements just need to bind parameters, some may require the ability to replace parameters, such as a field list.
---
find_author:
sql: select :fields from books where author = :author
my $q = $book->query( 'find_author',
replace => { fields => 'class,title,author' },
bind => { author => 'Lance Parkin' }
);
# sql = select class,title,author from books where author = ?
# args = 'Lance Parkin'
In all instances, if the SQL template requested does not exist or has no definition, then an error will be thrown.
Consult Data::Phrasebook::SQL::Query for what you can then do with your returned object.
For reference: the bind hashref argument, if it is given, is given to the query object's "order_args" and then "args" methods.
SEE ALSO
Data::Phrasebook, Data::Phrasebook::Generic, Data::Phrasebook::SQL::Query.
SUPPORT
Please see the README file.
AUTHOR
Original author: Iain Campbell Truskett (16.07.1979 - 29.12.2003)
Maintainer: Barbie <barbie@cpan.org> since January 2004.
for Miss Barbell Productions <http://www.missbarbell.co.uk>.
COPYRIGHT AND LICENSE
Copyright (C) 2003 Iain Truskett.
Copyright (C) 2004-2010 Barbie for Miss Barbell Productions.
This module is free software; you can redistribute it and/or
modify it under the Artistic Licence v2.
perl v5.10.1 2010-08-31 Data::Phrasebook::SQL(3pm)