Verifying the ECDA installed objects

Set the environment variables by sourcing the $SYBASE/DCO-15_0/DCO_SYBASE.csh file.

Use the isql utility to log in to Oracle through ECDA as maintuser.

• To verify whether the rs_info table has been created successfully:

  isql –Umaintuser –Ppassword –SDCOServer
  select * from rs_info
  go
  

  This is returned:

  RSKEY                RSVAL
  

  -------------------- ----------------
  

  charset_name         iso_1
  

  sortorder_name       bin_iso_1
  

  (2 rows affected)
  

• To verify whether the rs_lastcommit table has been created successfully:

  isql –Umaintuser –Ppassword –SDCOServer
  select * from rs_lastcommit
  go
  

  The following is returned:

  ORIGIN  ORIGIN_QID  SECONDARY_QID  ORIGIN_TIME  DEST_COMMIT_TIME 
  ------  ----------  -------------  -----------  ----------- ----
  (0 rows affected)
  

If the ECDA objects are not installed successfully, no results are displayed, and you encounter an error message.

Exit the isql session with the quit command.