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

Products

• Repository

Issue/Introduction

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

 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