WebSphere V5.0 : Applying DDL scripts to a remote database

Applying DDL scripts to a remote database

You can apply the statements defined in an SQL DDL file by running the script against a remote database.

1. Switch to the Data perspective's Data Definition view.

2. Locate the SQL DDL script that you want to apply. The SQL DDL script has the file name extension .sql. If the script is not showing up in the Data Definition view, check your Data Definition filter preference (Menu button in Data Definition view and then click Filters) to make sure it is not being filtered out.

3. From the script's pop-up menu, click Run on Database Server to open the Run Script wizard.

Run on Database Server

 

Ads

.

 

5. Click Next to open the Run Script Options wizard.

.

 

6. Select the options to be used when running the script.

.

 

.

12

Read Next: WebSphere V5.0 : Creating SQL statements

 

This tutorial is part of a WebSphere Tutorials tutorial series. Read it from the beginning and learn yourself.

WebSphere Tutorials

1. WebSphere V5.0 : Building Expressions
2. WebSphere V5.0 : Creating SQL statements
3. WebSphere V5.0 : Applying DDL scripts to a remote database
4. WebSphere V5.0 : Deploying to the database
5. WebSphere V5.0 : Defining a table
6. WebSphere V5.0 : Defining a database
7. Working with Data in WebSphere
8. WebSphere V5.0 : Debugging - JSP debugging
9. WebSphere V5.0 : Debugging - Scrapbook Page
10. WebSphere V5.0 : Debugging - View variables
11. WebSphere V5.0 : Debugging - Step-through code
12. WebSphere V5.0 : Debugging - Set breakpoints
13. WebSphere V5.0 : Running Applications - Export J2EE applications
14. WebSphere V5.0 : Running Applications - Run/operate server
15. WebSphere V5.0 : Running Applications - Understand Session Manager
16. WebSphere V5.0 : Running Applications - Configure data sources
17. WebSphere V5.0 : Running Applications - Create server instance and server configuration
18. WebSphere V5.0 : Web Development - Use Web Page Wizards
19. WebSphere V5.0 : Web Development - Work with Web Application Deployment Descriptor
20. WebSphere V5.0 : Web Development - Use content assist
21. WebSphere V5.0 : Web Development - Use Page Designer to add and modify HTML and JSP content
22. WebSphere V5.0 : Web Development - Understand classpath and module dependencies
23. WebSphere V5.0 : Web Development - Create resources in appropriate J2EE locations
24. WebSphere V5.0 : Web Development - Create a web project
25. WebSphere V5.0 : Java Development - Use property dialogues
26. WebSphere V5.0 : Java Development - Use hierarchy view
27. WebSphere V5.0 : Java Development - Use task view
28. WebSphere V5.0 : Java Development - Use search function
29. WebSphere V5.0 : Java Development - Use content assist function and declarations
30. WebSphere V5.0 : Java Development - Use refactoring features
31. WebSphere V5.0 : Java Development - Use Outline View and Browsing View
32. WebSphere V5.0 : Java Development - Create Java project, packages, classes, methods
33. WebSphere V5.0 : Workbench Basics - Use the Help feature to aid in development activities
34. WebSphere V5.0 : Workbench Basics - Import to and export from the workbench
35. WebSphere V5.0 : Workbench Basics - Work with Perspectives
36. WebSphere V5.0 : Workbench Basics - Set workbench preferences
37. WebSphere V5.0 : Workbench Basics - Create J2EE projects

 

Comments