To verify the ECDA installed objects
Open another command window in the $SYBASE directory of your ECDA installation.
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.