22.7.1 Using the interactive SQL execution utility to retrieve from manual's SGML documents

The interactive SQL execution utility can be used to retrieve SGML document data from the manual database.

To retrieve SGML document data, use the following procedure:

  1. Enter the pdsql command shown as follows to start the interactive SQL execution utility:

    $PDDIR/bin/pdsql -u "manager"

  2. Press the Enter key.
    A message is displayed requesting entry of a password.
  3. Enter manager, then press the Enter key.
  4. Execute the SELECT statement, which is a data manipulation SQL, to retrieve SGML document data. Enter the following SQL statement, which checks the section headings in manual to obtain the number of instances of the keyword plug-in:

    select count(*) from manual where contains(doc,'MAN[*[H2{"plug-in"}]]') is true;

    Retrieval result:

      COUNT(*)
    ------------
               2
    KFPX27010-I            1 rows selected

  5. To terminate pdsql, enter EXIT.
    The interactive SQL execution utility is terminated.