First you need to be acquainted with DBI (search for it on CPAN). For UDB it is reasonable to equate the term file with table. So you want to count the tables in the database. The SQL command LIST TABLES will be understood by DB2, so you just have to prepare and execute the LIST TABLES statement and fetch the results into an array reference. If the array reference is saved to say $fred, then the perl expression "scalar @$fred" will return a count of the tables in the UDB. This is an overview, of course the real exercise is to understand a whole bunch of methods in the DBI class, documented in CPAN.

One world, one people

In reply to Re: Database files and PERL by anonymized user 468275
in thread Database files and PERL by Perlnoob17

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.