Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by markmorgan

  1. markmorgan

    Can't locate loadable object for module error

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

    Can't locate loadable object for module error

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

    Help reading web page via Perl

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

    Help reading web page via Perl

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

    Help reading web page via Perl

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

    Help reading web page via Perl

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

    DB2 V8 Manuals now online

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

    How to find DB2 version?

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

    Index Foreign Keys

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

    Nullable Unique Index

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

    Nullable Unique Index

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

    DB2 UNIX Manuals Online?

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

    linking DB2 to SQL and using the 4 part name for Selects

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

    DB2 UNIX Manuals Online?

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

    Subselect in Select expression allowed?

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

Part and Inventory Search

Back
Top