IBM Optim Development Studio provides a complete development and testing environment for building database objects, queries, database logic, and pureQuery applications. Develops database applications faster with integrated query editor for SQL and XQuery. Optimizes your applications and queries with ease. Builds and tests your stored procedures (Java and SQL) with the interactive routine debugger. Rapidly develops or customizes the SQL inside Java applications. Auto-generates test applications for your pureQuery applications. Provides heterogeneous data server support for IBM DB2 Data Server and Informix Dynamic Server across the platforms.