Documentation Center

Importing the apiguide database

You can import the apiguide database dump file that is supplied with these reference materials to test your code.

Procedure

  1. Copy the apiguide.dmp file onto your database server or a client/workstation that has been installed with the SDL Contenta client administration software.

    It is recommended that you copy the file to a directory under the SDL Contenta home path.

  2. On the SDL Contenta client administration system, at a command prompt, go to the SDL Contenta home > bin directory then type:
    OSCommand
    UNIX systemsource /pdm/bin/pdm.cshrc dbimport.pl -dbase apiguide -i “path/apiguide”
    Windows systemdbimport.pl -dbase apiguide -i “path\apiguide
    where path is the directory path where the apiguide.dmp file is located.

Troubleshooting

Troubleshooting dbimport.pl for Oracle only.

About this task

If the XYE_PDM_DATABASE_SID is not defined, the import may fail with the message:

Variable XYE_PDM_DATABASE_SID not declared ABORTED

Procedure

  1. If you do not know what your database SID is, obtain this information.
    To display the value for the XYE_PDM_DATABASE_SID variable:
    OptionDescription
    WindowsLook in the registry under HKEY_CURRENT_USER > SOFTWARE > XyEnterprise > Content@ > 3.0
    UNIXAt the command prompt type:

    env | grep XYE_PDM_DATABASE_SID

  2. To resolve the problem you can either include the Oracle SID with the database name in the command or set the XYE_PDM_DATABASE_SID variable to the Oracle SID.
    OptionFor example:
    Include the Oracle SID with the database name in the commandAssuming that SDL is the SID, type:

    dbimport.pl -dbase -i "path/apiguide@SDL"

    Set the XYE_PDM_DATABASE_SID variable to the Oracle SIDIn the window from which you are issuing the import command, and assuming that SDL is the SID, type:

    Windows: set XYE_PDM_DATABASE_SID=SDL

    UNIX: setenv XYE_PDM_DATABASE_SID SDL