I am using the following code as per your suggesstion now: 
#!/cluster/uapp/perl/bin/perl -w
use KAP;
use strict;
use Date::Manip;
use DBAccess;
use EQ_Misc;
use DBD::CSV;
use MIME::Lite;
use Net::SMTP;

  my $_db_lv_conn_file = "MSLV.eq_script_user";
  my $_read_dbi = undef;

            # Run stored proc
    my $sp = "lv..check_tax_lot";

    KAP::write_log("Preparing $sp");
    $_read_dbi = KAP::opendbi($_db_lv_conn_file) || handle_error_and_e
+xit ("Failed to get a connection to MSLV db server");
    my $_read_sth = $_read_dbi->prepare($sp);
    if($DBI::err) {
        handle_error_and_exit("**ERROR preparing $sp: " . $DBI::errstr
+);
    }
    KAP::write_log("Prepare done, executing $sp");

    $_read_sth->execute();
    if($DBI::err) {
        handle_error_and_exit( "**ERROR executing $sp: " . $DBI::errst
+r);
    }
    KAP::write_log("Execute of $sp done");
    
    
    my $_datafile = KAP::datafile();   
    my $numrecords = 0;
    my @data = undef;
    
    open my $fh, q{>}, $_datafile or die qq{cant open $_datafile to wr
+ite: $!\n};

    my $header_rec = join(",", @{$_read_sth->{NAME}}); 
 
    # print the header to the filehandle
    print $fh $header_rec . "\n"; 
    while (@data = $_read_sth->fetchrow_array) { 

    # lets see what we have
    die @data;

    my @data = EQ_Misc::arr_replace_undef("", @data); 
    my $csv_record = join(",", @data); 
        
    # you're writing the array _and_ the record (and a dot)?
    #print $fh "@data $csv_record .\n";
    
    # did you mean?
    print $fh qq{$csv_record\n};

    }
    #close $datafile;
    close $fh;

[download]
The output is as follows:
nbsda1@vcstest3 $ perl test.pl
Name Age
John 29
Ram 30
at /cluster/uapp/app/bin/sudip.pl line 45.

#It still returns me only only the 1st Results set and discrads the last 6.

nbsda1@vcstest3 $
Please Help...

In reply to Re^2: Writing Multiple Recordsets into a CSV file by sudip_dg77
in thread Writing Multiple Recordsets into a CSV file by sudip_dg77

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.