IBM Support

New Generate SQL option for Modernization

News


Abstract

New Generate SQL option for Modernization

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 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

image-20200117131759-1


Figure 2. The default behavior has not changed

image-20200117131807-2


Figure 3. The new, preferred option because you get views and indexes generated

image-20200117131819-3

Figure 4. An "index only" generation option can be used

image-20200117131829-4

[{"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":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
11 April 2021

UID

ibm11168738