Perl System Calls Within The Same Session (on Sun box)

From: Jim Boyan (jboyan123_at_comcast.net)
Date: 06/07/05

  • Next message: abhay_raghu_at_yahoo.com: "incorrect siginfo->si_addr value with solaris gdb" 
    Date: Tue, 7 Jun 2005 15:55:03 -0600

    I wrote a perl script that connects to a db2 database and does some
    select statements then disconnects...in essence it does something like
    this:

    $db2Out = `db2 connect to sample`;
    $db2Out = `db2 select tabschema, tabname from syscat.tables`;
    $db2Out = `db2 connect reset`;

    This script runs fine on Windows, and AIX, but when I try to
    run it on Sun, it does not maintain the session information
    between calls - so the first statement establishes a connection,
    and it is immediately lost when the call returns, so that
    when I do the second call "select", I get an error message
    saying that there is no database connection.

    Is there a trick to getting this to work on Sun? I have
    wrestled with this same problem two or three years ago and
    could never figure out how to get the program to run on Sun...

    Please tell me if you have any suggestions....

    Thanks
    Jim

  • Next message: abhay_raghu_at_yahoo.com: "incorrect siginfo->si_addr value with solaris gdb"

    Relevant Pages

    • Perl System Calls Within The Same Session (on Sun box)
      ... I wrote a perl script that connects to a db2 database and does some ... $db2Out = `db2 select tabschema, ...
      (comp.sys.sun.apps)
    • Re: an approach
      ... > i am working on db2 and need a perl script to delete data from a ... There is a column in that table X lets say Xdate. ... > timestamp format so its creating problems for me. ... to solve it is almost surely within DB2 itself. ...
      (comp.lang.perl.misc)
    • Re: Not able to connect - But the db2 client utility is working fine
      ... a Perl script using DBI module and DB2 driver. ... throws the error "Total Environment allocation failure! ... source though the DB2 client utility "db2". ...
      (perl.dbi.users)
    • Re: DBD::DB2 where to get a client library
      ... get DBD::DB2 working on a machine remote to the DB2 database. ... I'd guess that you need to buy a licence for the client from IBM, ...
      (perl.dbi.users)
    • Re: Migrating data from DB2 to SQL Server
      ... I am trying to migrate data from a DB2 database to SQL Server 2005 ... Does anyone know about any migration tool that does that? ...
      (comp.databases.ms-sqlserver)