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

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

book

Article ID: 138006

calendar_today

Updated On:

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.