Recent content by markmorgan

To install it I searched for the file on cpan.org. Saved the .pm file to the C:\Perl\lib\XML\LibXML\ (after creating the directory) and ensured that Internet Explorer did not append a .txt extension. I have since (sending the first mail) discovered the cpan shell utility can be used to install...

I'm getting the following message in XML module GDOME.pm Can't locate loadable object for module XML::LibXML::Common in @INC (@INC contains: c:/Perl/lib c:/Perl/site/lib .) I have downloaded Common.pm from CPAN and put it in a directory at C:\Perl\lib\XML\LibXML Am I missing something obvious...

After a bit of digging I found that LWP can use an environment variable for the proxy server http_proxy=http://www.myproxyserver.com I set the environment variable and added these lines to my code before the get use LWP::UserAgent; my $ua = new LWP::UserAgent; $ua->env_proxy; This...

I ran waiterm's idea of the SimpleLinkChecker above, here are the results LWP::UserAgent::request: () LWP::UserAgent::simple_request: HEAD http://www.hostpipe.co.uk/ LWP::UserAgent::_need_proxy: Not proxied LWP::Protocol::http::request: () LWP::UserAgent::request: Simple response: Internal...

The print statement gives "Use of uninitialized value in print" as the $page variable hasn't been assigned a value because the get failed. The script I am trying to get working comes from here http://hacks.oreilly.com/lpt/a/4406 Mark.

I am a Perl novice and am trying to get the following script to work # use strict; use warnings; use LWP::Simple qw(get); my $url = "http://www.a-valid-url.html"; my $page = get($url); exit unless $page; The get function appears to do something as it takes time to execute, but the result...

http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v8pubs.d2w/en_main

I had the same question. I see that fixpack 7 is out but pre-reqs fixpack 3, but I'm not sure if I have fixpack 3? db2level gives DB21085I Instance "DB2" uses DB2 code release "SQL07020" with level identifier "03010105" and informational tokens "DB2...

Either way is ok. It depends on your deletes and updates... Though there is obviously a vast overhead of declaring indices for every foreign key. If a delete occurs on the parent table, then DB2 must check that there are no rows referencing this row via a foreign key, otherwise these...

You can do that, and the index would be created. Unfortunately, it would treat NULL as any other value and only allow one instance of the NULL column in the whole table. Mark.

CREATE UNIQUE WHERE NOT NULL INDEX ... The 'WHERE NOT NULL' syntax does not appear to be supported under DB2 UDB v7.2 for Windows, whereas it is under OS/390. Anyone know why? Anyone know if v8 will support it? Can anyone think of a way around it? My only option, at the moment, appears to...

Thanks, I missed the library link on the side! I have added it to my bookmarks. Mark.

I thought it was 2 or 3 part names as follows. The column names are implicitly referenced by the table / view object that has been referenced [database].[schema name].[table name] or: [schema name].[table name] or the schema can be replaced by OwnerId Mark.

The OS/390 DB2 manuals can be found at http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/LIBRARY Does anyone know of a link to the UNIX flavour DB2 manuals? Mark.

Yes as you have shown the table name can stand in place of the correclation name. DB2 does allow subselects. But I have never coded one as a expression giving a single result column in the select list before. I have only ever coded them in a where or having clause before (a subquery). I'm...