enzzo77 has asked for the wisdom of the Perl Monks concerning the following question:

Hello I need a small script to open a solsql connection a ran a query. How do I do that? Normal command to access for prompt is "solsql user password". For isql I used something like: use IPC::Open2; local (*Reader,*Writer); my $pid=open2(\*Reader,\*Writer," isql -Uuser -Ppassword -SHost")... But for some reason donīt work with solsql (solidDB) Thanks a lot

Replies are listed 'Best First'.
Re: solsql script
by Discipulus (Canon) on Feb 09, 2019 at 20:21 UTC
    Welcome to the monastery enzzo77 and to the wonderful world of Perl!

    I see there is a connection module to use within DBI: DBD::Solid and even if it has not the best promising tester matrix reports it can be worth to play with.

    Are you able to install it and to connect using it to your db?

    L*

    There are no rules, there are no thumbs..
    Reinvent the wheel, then learn The Wheel; may be one day you reinvent one of THE WHEELS.
      Hello, thanks for the reply. I am not admin, I donīt think I can install further modules :-(
        Yes, even you can use CPAN

        and do not mess your system perl: use perlbrew!

        L*

        There are no rules, there are no thumbs..
        Reinvent the wheel, then learn The Wheel; may be one day you reinvent one of THE WHEELS.