in reply to Re: open2 or 3 run command using pty
in thread open2 or 3 run command using pty

with temp file same situation (i guess sql command insert stupid ">")

Replies are listed 'Best First'.
Re^3: open2 or 3 run command using pty
by Corion (Patriarch) on Jul 21, 2014 at 09:38 UTC

    Yes, most likely the sql command inserts the "prompt signs" on its own.

    Maybe you can find in the manual how you can change (or suppress) those signs. Sybase and Oracle use "variables" in their shell which you can use to change the prompt and the output format. Maybe your vendor uses something similar.

    Alternatively, you could mention the vendor of your database then maybe somebody knows either the appropriate DBD to use or how to make the command line shell output data in a way that you can reuse from within Perl.

      No i can't find documentation

      This is McAfee DB (NitroDB). I have no informations about it.

      I can remove this sign by perl, but if this sign will be legal in DB!?