The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

InfoSphere Data Architect

IBM® InfoSphere® Data Architect (formerly Rational® Data Architect) is a collaborative enterprise data modeling and integration design tool to discover, model, relate, and standardize diverse and distributed data assets.

Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 2

In Part 2 of this article series, use InfoSphere Data Architect 8.5 to modify an existing data model to incorporate changes in requirements for the created global temporary table. More >

Featured content

02 May 2013 — Show descriptions | Hide descriptions

Modeling created global temporary tables for DB2 with InfoSphere Data Architect 8.5, Part 1: Getting Started
Leverage InfoSphere Data Architect to create a physical data model with CGTT (created global temporary tables) and then generate a DDL with CGTT-specific syntax that you can run on a database server.
Best practices for IBM InfoSphere Blueprint Director, Part 2
Use Blueprint Director to create effective blueprints from scratch; learn the benefits for creating and managing blueprints, visualizing the metadata landscape based on best practices; and incorporate the physical deployment landscape into your information blueprint.
Multiple dimensional data modeling using InfoSphere Data Architect, Part 3: Transformations
In Part 3 of this article series, learn how to transform models from a Cognos model to a cubing model, or from a cubing model to a Cognos model, and then update the models for consolidation.
Dimensional modeling with InfoSphere Data Architect, Part 2: Reverse engineering
Follow the workflow outlined in part two of this series to learn how to update existing data models and minimize the impact on the production environment by reverse engineering from an existing data source.
Update: Creating scripts more efficiently in the SQL and XQuery editor
Get on board with new enhancements to the SQL and XQuery editor, a feature of Data Studio, InfoSphere Data Architect, and InfoSphere Optim Query Tuner.
Bitemporal modeling with InfoSphere Data Architect, Part 2: Modeling system period temporal requirement
In Part 2 of this series, learn how to model bitemporal properties within tables by modifying the physical data model that was created in Part 1, or reverse-engineering a database to create and then modify a new model using InfoSphere Data Architect 7.6.
Bitemporal modeling with InfoSphere Data Architect, Part 1: Modeling application period temporal requirement
Create a temporal logical data model, transform it into a physical model for DB2 for z/OS version 10, and then generate DDL with temporal-specific syntax that you can run on a database server.
Dimensional modeling with IBM InfoSphere Data Architect, Part 1
Use this collaborative data design solution to discover, model, relate, and standardize diverse and distributed data assets. Part 1 focuses on using forward engineering to achieve a multidimensional data model.
Integrating Rational Software Architect with InfoSphere Data Architect
Make your application model and data model work together using this article, which is updated for the InfoSphere Data Architect product (formerly the Rational Data Architect product).