I'm going to add the reply to your latest node here, Confused -- please add futher responses as a reply, NOT as a new node. Confused asked:

I understand that the output file can be specified when using a filehandle. If you use Print to output a file, how do you specify where the output goes?

There are a couple of ways. The quickest is like this (note that I'm using open, and not use Filehandle): 

        
my $SQLlog = 'SQL.log';
open (SQL_LOG, ">$SQLlog") or warn "Cannot open SQL commands logging a
+t $SQLlog: $!\n";
print SQL_LOG "\n==========SQLCMDLOG===================BEGIN==========
+====================\n";

[download]

To break it down, first, define the name of the file the data is going into. This does not have to be done in a seperate varabile, but it's easier for debugging. Then use the open command to open the file for writing, and then print the data, but put the filehandle you defined before the data. In the code above, I say "print to the filehandle SQL_LOG such-and-such data."

Again, please look at the docs for open and print, and try the code above.

----Asim, known to some as Woodrow.

In reply to Re: Using Filehandles by Asim
in thread Using Filehandles #2 by Confused

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.