Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    Unanswered: powershell vs perl

    Some things cannot be avoided. I am getting involved in a conversion from DB2 to ms-sql

    In the current situation I've got ksh-scripts which produce SQL and this SQL is fed into db2batch. All this on aix.
    I am planning to convert my ksh-scripts into perl and use standard ODBC to communicate with DB2. The scripts will run on windows. Code SQL as agile as possible so in the next phase the ODBC can point to ..... the other database... <sigh> and the conversion is a fact.

    But my hemlock is not empty yet. They would rather see a powershell solution. So I need arguments why perl is much betten than powershell. I do not know powershell and I was not planning to educate myself...
    Is that wise or are powershell skills usefull for a DB2/DBA?
    Please advise.

    O and while we're at it: which is better on windows: activeState or strawberry perl?

  2. #2
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Personally I'm happily using ActiveState on MS-Windows, but other distributions are equally well, certainly if you don't heavily rely on Perl modules (apart from the DBI).

    Cannot say anything about Powershell, but imho Perl is certainly a good choice, especially in terms of stability. I know large companies which adopted perl as their standard (unix and Windows) scripting tool. And the DBI is fairly stable, and supported by IBM for DB2. For MS SQL-Server you'll have to use the ODBC driver of DBI.
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  3. #3
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by Peter.Vanroose View Post
    and supported by IBM for DB2.
    and maintained?? the IBM documentation is not valid anymore. I do not have in depth knowledge of perl so it is hard for me to analyse and solve the problems:

    on windows . A clean install of express-C, active state perl and then the DB2 DBD does not work as described. The IBM documentation is too old (looks sloppy to me).

    on linux I had it working, but an upgrade of perl (arch linux) broke my db2 connection and I am not able to fix that. Guess I'll have to use debian-stable for such a configuration.

  4. #4
    Join Date
    Sep 2004
    Location
    Belgium
    Posts
    1,126
    Perl (DB2 DBD) is certainly not high on the priority list of IBM, unfortunately :-(
    --_Peter Vanroose,
    __IBM Certified Database Administrator, DB2 9 for z/OS
    __IBM Certified Application Developer
    __ABIS Training and Consulting
    __http://www.abis.be/

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •