Using Cache' Post RDBMS From Mathematica By Telnet

Junzo SATO

Copyright (c) 2001, Junzo SATO. All rights reserved.

June 6th 2001

Cache' Post RDBMS from InterSystems is an OODB. It possesses data and functions in classes. Cache' Terminal is a handy telnet client application to control database by Cache' ObjectScript. By adding Mathematica the functionality of telnet communication, it becomes possible for Mathematica to take a role of Cache' Terminal.

Configurations

The author developed a Java class MathSocketTerminal to enable Mathematica to be able to send and receive data via TCP/IP socket. This class is loaded by Mathematica. Cache' database runs on a remote computer. The Java application package RelayStationArgs were built too. It runs on the remote computer so that it can relay packets between MathSocketTerminal's socket and Cache' telnet port.

Load J/Link

J/Link is loaded and installed.

Load MathSocketTerminal

The communication tool MathSocketTerminal is loaded. An object of this class is constructed.

Create SocketListener

SocketListener is a class which can receive TCP/IP packets. Incoming data is read and transferred to Mathematica by evaluating pre-installed handler.

The handler simply prints received string in this example.

Start Session

To RelayStation with Cache' PRDBMS

Login

RelayStation's server port on a remote computer is opened.
Because GUI for RelayStation was omitted for efficiency, RelayStation in RelayStationArgs is launched by command: java RelayStation.RelayStation

Connection to the RelayStation is established.

Cache' telnet server requests login password at the very first of the session.

Unicode And Command : s, w

A word "Tokyo Prefecture" in Japanese is set.

Inside Cache' unicode version, the word is stored as three unicode characters.

ZIP Database And Query

The namespace is changed from USER to ZIP by command:
zn "ZIP"

The command:
do ##class(%Library.ResultSet).RunQuery("Zip.ZipTable","getTown","1940032")
runs query method getTown(zip7) in the class Zip.ZipTable with a string argument zip7 = "1940032"
It returnes prefecture, city, and town in database.

The command:
do ##class(%Library.ResultSet).RunQuery("Zip.ZipTable","getZipCode","“Œ‹ž“s","’¬“cŽs")
runs query getZipCode(kanjiPref, kanjiCity) in the class Zip.ZipTable with string arguments: kanjiPref  = "“Œ‹ž“s", kanjiCity = "’¬“cŽs". It returns town names.

Closing Connection

Quit