QDB2 CLONE DOES NOT INCLD TEXT1 FOR KEY WITH SCALAR FUNCTION

Products

• Repository

Issue/Introduction

PROBLEM DESCRIPTION:
XTR22776 - Quick DB2 does not include TEXT1 during the CLONE process
which copies information from a source table to a new table.
XTR22777 - DDLDB2 may generate incorrect DDL for INDEX with SCALAR
function if the Index is not the last one in the list.
 
SYMPTOMS:
XTR22776 - The TEXT1 will be empty for the KEY after performing the
CLONE process within QDB2. As a result, we lost syntax for index
w/ SCALAR function introduced with LU10705.
XTR22777 - Repetition of same syntax of index with SCALAR function
for all Indexes.
 
IMPACT:
XTR22776 - Incorrect generated DDL for Index.
XTR22777 - Incorrect DDL generated by DDLDB2.
 
CIRCUMVENTION:
XTR22776 - Manually enter syntax into TEXT1 for KEY w/ SCALAR
function.
XTR22777 - None.
 
 

Environment

Repository for z/OS Release 7.2

Resolution

LU13061 - QDB2 CLONE DOES NOT INCLD TEXT1 FOR KEY WITH SCALAR FUNCTION