RDBMK(1)

NAME

     rdbmk - put an Oracle db table into an rdb format file

SYNOPSIS

     rdbmk [-d] [-L] [-Oname] db_table_name rdb_file_name

DESCRIPTION

     rdbmk queries a database for the given db table and converts
     the information into an rdb format file.

     rdbmk calls dsds_svc via a REQSQL request with  the  sql_cmd
     keystring  "select * from db_table_name". The returned keyl-
     ist is then parsed for the number of columns to make an  rdb
     format  header  and  for  the  number of rows to make an rdb
     entry for each row. The rdb entries are output to the  given
     rdb_file_name.

     rdbmk is run as a pvm (Parallel Virtual Machine) task. A pvm
     daemon  will  be  started  on the host if needed. A dsds_svc
     will be started if needed.

     rdbmk also has a conterpart, rdb2db, which puts an rdb  file
     into  a  database  table.  This  is strictly reserved for DB
     Manager use.

OPTIONS

     -d   The debug flag. Runs the dsds_svc in debug mode with  a
          dbx window.

     -L   The local flag. Run local dsds_svc. Don't  use  pe_rpc.
          This  is  for development use only and requires a pass-
          word.

     -Oname
          The Oracle db to query instead of  the  default  mdi_2X
          db.

EXAMPLES

     csh> rdbmk -Omdi_2 partn_avail partn_avail.rdb
     dsds_svc tid=46720 spawned on rumble.Stanford.EDU for db=mdi_2
     Registered with dsds_svc as uid=1567
     If you're converting a large table this is going to take awhile ...
     Deregistered with dsds_svc as uid=1567
     rdbmk Normal Completion
     csh> more partn_avail.rdb
     PARTN_NAME      TOTAL_BYTES     AVAIL_BYTES
     -----------     -----------     -----------
          /PDS1      36207226880      1876837695
          /PDS2      36207226880      2098740059
          /PDS3      36207226880       345845760
          /PDS8      36207226880      1407450316
          /PDS5      36207226880       793129657
          /PDS6      36207226880      1927297105
          /PDS7      36207226880      2021554994
          /PDS4      36207226880     12666067681
     csh>

FILES

     The rdb output file.

BUGS

AUTHOR

     Jim Aloise

HISTORY

     1996-06-14     SOI Version 1.3.0
     1994-12-28     SOI Version 0.9.0