Recent content by windskystar73

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...