Additional Topics

1
Additional Topics
2
DDM

• Distributed Data Management files Type(File)
  and Attr(DDMF)
• objects that represent files that exist on a
  remote system.
• For instance, if your customer file exists on a
  remote system, you can create a DDM file on the
  local system that specifically points to that
  customer file on the remote system.
• DDM files provide an interface that lets you
  access the remote file just as if it were on your
  local system.
• Can compile programs using the file, read
  records, write records, and update records while
  the system handles the communications

3
(No Transcript)
4
DRDA

• Distributed Relational Database Architecture is
  an architecture that allows you to access data in
  a distributed relational database environment by
  using SQL statements in your applications.
• The architecture has been designed to allow
  distributed data access for systems in like and
  unlike operating environments.
• This means that your applications can access data
  residing on homogeneous or heterogeneous
  platforms.

5
DRDA SQL

• Structured Query Language (SQL) ? the most common
  data access language for relational databases in
  the industry.
• SQL was chosen as part of DRDA because of its
  high degree of standardization and portability.
• Distributed environment, you want to access data
  at remote locations ? the SQL requests are
  routed to the remote systems and they are
  executed remotely.
• Prior to sending the remote SQL request, a DRDA
  application must establish a connection with the
  remote relational database where the data is
  located. This is the purpose of the CONNECT SQL
  statement provided by DRDA