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:
- Enter the pdsql command shown as follows to start the interactive SQL execution utility:
$PDDIR/bin/pdsql -u "manager"
- Press the Enter key.
A message is displayed requesting entry of a password.
- Enter manager, then press the Enter key.
- 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
- To terminate pdsql, enter EXIT.
The interactive SQL execution utility is terminated.