Sybase® WorkSpace Database Development provides database developers with visual tools to create and debug database objects. You can create, edit, save, debug, and execute procedural objects, real-time messaging statements, and SQL files. From stored procedures, you can derive database services to integrate with business process services, message services, or Web services using Sybase WorkSpace Service Development.
See Service Development for more information.
When you develop database objects in Sybase WorkSpace, you have access to the latest Sybase database features from within your visual development environment. This integrated environment can simplify and unify the complete development life cycle for your database applications, starting with data and process modeling, through development, debugging, and deployment.
Wizards help you create the basic structure for procedural objects, SQL files, and messaging constructs. Using SQL Editor you can then edit the SQL files, procedural objects, and messaging constructs created with the wizards, or edit existing files from other sources; you can also create new SQL files and procedural objects. You can generate SQL syntax without writing SQL code, using the Visual SQL dialog, which offers a graphical interface for developing select, insert, update, and delete statements. You can also use Content Assist, which accelerates manual coding by offering content-sensitive syntax suggestions.
You can test SQL files and database objects against different launch environments, and save these launch configurations for iterative testing as you update the application, or migrate to a new database version. Portability checks in the SQL Editor help you develop applications for multiple environments, and port existing applications between Sybase database servers and versions. You can view and save SQL execution results in various formats, and see execution plan details that help you tune query performance.
While debugging in Database Development you can set breakpoints, adjust variables, step through code, suspend and resume execution, and view and edit tables referenced in your queries.
See Using Database Debug for more information.
Using Database Development tooling you can create these objects.
Create database-independent SQL files, and execute them against multiple database environments. SQL files let you organize and save SQL code into projects to be reused later.
See Learn More About SQL Files for more information.
You can develop all of the procedural object types your database supports:
Stored procedures (Adaptive Server Enterprise, Adaptive Server Anywhere, and Sybase IQ)
Triggers (Adaptive Server Enterprise and Adaptive Server Anywhere)
Functions (Adaptive Server Anywhere and Sybase IQ)
Events (Adaptive Server Anywhere and Sybase IQ)
See Developing Procedural Objects and Learn More About Procedural Objects for more information.
Create an Adaptive Server Enterprise, Adaptive Server Anywhere, or Sybase IQ database with development-level capabilities quickly and easily, using default syntax built into the tooling.
See Creating a Simple Database for more information.
Add tables, columns, indexes, keys, relationships, views, and extended attributes, using development-level database management facilities within Sybase WorkSpace. You can add these components to the databases you create in Sybase WorkSpace, or to a wide variety of database management systems (DBMSs).
See Working with Database Components for more information.
Use Real-Time Messaging Services to create messaging statements, send and receive messages by queue, publish and consume messages, register subscriptions for real-time stored procedures, and parse and map messages between XML and SQL.
See Real-Time Messaging Services for more information.
Access Web service methods as Adaptive Server Enterprise tables using ordinary SQL statements.
See Creating an ASE Web Service Consumer for more information.
Use the Replication Server to create, manage, and use replication artifacts, including articles, replication definitions, functions, function strings, publications, and subscriptions.
See Developing a Replication System for more information.
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com