News
Abstract
New Generate SQL option for Modernization
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Database Engineer (DBE) Enhancements > New Generate SQL option for Modernization
By default an SQL View is generated for DDS-created keyed physical, keyed logical, or join logical files
With this enhancement, IBM i Navigator will have additional Generate SQL options.
The mutually exclusive options have been added to QSQGNDDL and IBM i Navigator.
This enhancement makes it easier to proceed with DDS to SQL DDL modernization.
Figure 1. The new options explained
Figure 2. The default behavior has not changed
Figure 3. The new, preferred option because you get views and indexes generated
Figure 4. An "index only" generation option can be used
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
11 April 2021
UID
ibm11168738