IBMi DB2 PHP Extension - Work with Relational Database Directory Entry

Avatar
Shlomo Vanunu
Follow

This article is now available in our new knowledge base: IBMi DB2 PHP Extension - Work with Relational Database Directory Entry

This article applies to:

IBMi

 

Preface

Work with Relational Database Directory Entry

 

Details

To retrieve your IBMi OS Relational Database name run the OS command Work with Relational Data Base Directory Entry.

From an i5 command line: WRKRDBDIRE

 

The command allows you to work with one or more entries from the relational database (RDB) directory.

With this command, you can do the following with the RDB directory:

  •  Add new entries
  •  Change existing entries
  •  Remove entries
  •  Show the details of an entry
  •  Print an entry
  •  Print a list of all entries

 

Note:
The RDB name that is used with db2_connect function etc.

 

Example:

 

<html>
<Head>
<Title>PHP WRKRDBDIRE </title>
</Head>
<p>PHP running WRKRDBDIRE <br>
<?php
$lsout = `/QOpenSys/usr/bin/system 'WRKRDBDIRE'`;
$line = strtok($lsout," ");
print "<table border CELLSPACING=2 CELLPADDING=0 BGCOLOR="#00FF7F">";
print "<tr ALIGN=LEFT>";
print "<td><pre>";
print $line;
print "</pre></td>";
print "</tr>";
while ($line = strtok(" "))
{
if (preg_match("/Relational databases+./", $line))
{
print "<tr>";
print "<td style="background-color: # FF7F00"><pre>$line</pre></td>";
print "</tr>";
}
else
{
print "<tr>";
print "<td><pre>$line</pre></td>";
print "</tr>";
}}
print "</table>";
print "the end";
?>
</body>
</html>

 

 

For more information on i5/OS commands see IBM Information Center (links below)

 

Work with Relational database directory entry

 

Comments