I had DB2 Enterprise Edition 8.1.4 trial version on Windows 2000 sever. After it expired, I tried to remove it and reinstall it. but it keeps failing by showing this error message when I tried to reinstall it.
"No start database manager command was issued. SQLSTATE=57019"
I can't start DB2...
I have a table, called "person" that has "name" and "id" column that has the following data.
id, name
1 Tom
2 David
1 Tom
3 John
2 David
I want to display duplicated rows. i tried like this.
select * from person having count(*) > 1;
but it displays only one row.
but this statement...
my $sth = $dbh->prepare("select email, fname from member where email = 'MY\@EMAIL.COM' ");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref())
{
print "insert into mp_item_placement values ($ref->{'id'}, $ref->{'email'}, $ref->{'fname'} )\n";
}
when i run this simple perl program, i...
I have two computers. win 2k server is installed in one computer and red hat linux 9 is installed in another computer.
I installed samba 3.04 on linux computer to share files. I am using webmin to configure samba and other stuff. I can see server name(linux) in "Computers near me" section on...
I am building a search engine. but it is kind of complicated. i have a table that three columns, id, url, description. this is my sql.
select id, url from search where match(description) against ('oracle application server') limit 20
when i try this sql, it is really fast, but it doesn't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.