CA Datacom SQL - generating an ever increasing and unique number when inserting rows

Products

• Datacom
• Datacom/DB

Issue/Introduction

 Does Datacom have a feature or data type that generates an ever increasing and unique number like IBM DB2 IDENTITY or ORACLE SEQUENCE?

Environment

Release : 15.1

Component : CA DATACOM SQL

Resolution

Dynamic system table SYSADM.SQL_X_SEQUENCE (SQE) provides a way of generating a unique ascending sequence number.

The SQE table consists of one row which when queried includes a column with this ascending sequence number. 

 

The SQL_X_SEQUENCE table consists of one column with the following characteristics:

Column Name	SQL Data Type	Nullable	Description
SEQUENCE_NUMBER	DECIMAL(21,0)	No	A unique ascending sequence number. The number is computed using the current system clock so it does not ascend in increments of one.