Deploying an SDA
To create a physical representation of the table from the local table definition on a database instance, you must deploy the newly created archive file (SDA). However, before you do this, make sure all the following prerequisites are met:
Prerequisites
|
|
You have made sure that that archive file (SDA) was created successfully. |
|
|
You have made sure that the SAP J2EE Engine has been launched and that you are connected to a database instance of the SAP DB. To do this, refer to Starting and Stopping the SAP J2EE Engine |
|
|
If you want to ensure that your tables were correctly created on the database instance of the SAP DB, you also require the SQL Studio. This must be already installed. However, this prerequisite is optional. |
Procedure
...
1. Select the project node (QuickCarRentalDictionary) in the Dictionary Explorer.
2. Open the context menu and choose Deploy.
If the deployment, which is carried out by the Software Deployment Manager, is successful, the appropriate message is displayed in the Deploy Output View.
Result
The SDA file is deployed and the table is created in the database instance. In so doing, the table definition from the Java Dictionary is converted to a definition of the relevant database – in this case, the SAP DB.
Checking the Result
You do not have to carry out the following check. It is only really necessary if you have installed the SQL Studio.
To make sure that the table was correctly created on the database instance, you can log on to the SQL Studio and view the list of all tables currently deployed on the J2EE Engine. Proceed as follows:
...
1. Call the SQL Studio, for example by choosing Start → Programs → SAP DB → SQL Studio or directly using the start file <drive:>\sapdb\SQLStudio\SQLSto.exe.
2. Choose Connect.
A logon window is displayed.
3. Enter the logon data (Server, Database, User and Password) and choose OK to confirm your entries.
4. In the navigation tree on the left, open the Tables folder and expand the user node (for example SAPC11DB).
The system now displays all tables that belong to the user.
5. Find the table QCR_RESERVATION. You may have to choose Continue to display all tables.
6. Open the table by double-clicking QCR_RESERVATION.
In the right frame, the SQL Studio displays the columns of the table.
|
|
Next step: