I'm aware of both the %ERRORLEVEL% and $? values but do not know if these will work.
Why would you think that $? might not work? It is documented as
The status returned by the last pipe close, backtick (``) command, successful call to wait() or waitpid(), or from the system() operator.
For redirecting your output, the syntax you're using is Unix shellian. It shouldn't work on NT. You can reopen STDOUT and STDERR, though, prior to the system calls, and restore the old file handles as necessary:
open my $oldout, '>&STDOUT' or die "Duping STDOUT: $!\n"; open my $olderr, '>&STDERR' or die "Duping STDERR: $!\n"; open my $log, '>errorlog' or die "Opening errorlog: $!\n"; while(<LISTFILE>) { chomp($FILE=$_); # You do probably want to remove the newline # Let's do it print "Importing $FILE.\n"; open STDOUT, '>&', $log or die "Redirecting STDOUT: $!\n"; open STDERR, '>&', $log or die "Redirecting STDERR: $!\n"; system("mysql < $FILE"); open STDOUT, '>&', $oldout or die "Restoring STDOUT: $!\n"; open STDERR, '>&', $olderr or die "Restoring STDERR: $!\n"; print "Sleeping for 5.\n"; system('sleep 5'); } close $log;

Caution: Contents may have been coded under pressure.

In reply to Re: Need to capture return code by Roy Johnson
in thread Need to capture return code by James_Marcinek

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.