MS SQL Server Data Types BIGINT, NTEXT, UNIQUEIDENTIFIER not included in Repository DDL generation

Products

• Repository

Issue/Introduction

Symptoms:

The CA Repository for z/OS DDL Generation facility does not generate Microsoft SQL Server data types BIGINT, NTEXT and UNIQUEIDENTIFIER for elements manually entered through Quick Table or via the ELEMENT entity.   

The BIGINT data type is being generated as TINYINT whereas NTEXT and UNIQUEIDENTIFIER are not valid data types in the ELEMENT entity and thus cannot be stored.

 

Environment:

CA Repository for z/OS 7.2 DDL Generation for MS SQL Server

 

Resolution:

For the data types in question, specify a DATA TYPE of USER on the ELEMENT entity and then the corresponding data type in the PICTURE CLAUSE.     

For example,

STORAGE PARAMETERS:                                                 

 SIGN POSITION                    ===> N               SIGNED ELEMENT  ===> N (Y/N)

 MAXIMUM LENGTH               ===> 8                                      

 DECIMAL PLACES                 ===> 0                                      

 DATA TYPE                          ===> USER                ß- Specify USER                     

 PICTURE CLAUSE                  ===> BIGINT             ß- Specify the data type

Environment

Release: DATASH00200-7.2-Repository-Webstation Option
Component: