Connectivity Manual - DDCENU - record number next record
DDCENU - record number next record
The table DDCENU contains the first available record_id for each application. When you create a record in the DDCDAT file you must take the record_ID from DDCENU and update the number_value field with old-record_ID + 1.
Application |
Application |
char x(8) |
"'Relapack'", Referenced to DDCAPP.application, same as DDCDAT.application |
number_type |
Number type |
inte >>>>>>>>>9 |
Message = 3001 Data-record = 3002 Transaction = 3003 |
number_value |
Number value |
inte >>>>>>>>>9 |
First available number value to be used to identify DDCDAT records - HOLDS THE NUMBER TO BE USED |
Use the following Progress logic, or an equivalent in another development language, to get number and update:
/* find the number to be used */ |
FIND LAST DDCENU |
|
WHERE DDCENU.application = "RELAPACK":U |
|
AND DDCENU.number_type = 3002 |
NO-ERROR. |
IF NOT AVAILABLE ddcenu THEN DO: |
|
CREATE ddcenu. |
|
ASSIGN |
|
|
DDCENU.application = "Relapack":U |
|
|
DDCENU.number_value = 1 |
|
|
DDCENU.number_type = 3002 /* 3002 is for records, 3001 is for messages, 3003 is for transactions */ |
|
|
. |
END. |
/* already increase the number ddcenu for other data and assign value to be used. */ |
Connectivity Manual >
Contents >
EDIS >
Database structure EDIS >
DDCENU - record number next record
Main Category: |
Support Product Know How |
Document Type: |
Support - On-line help |
Category: |
On-line help files |
Security level: |
All - 0 |
Sub category: |
Details |
Document ID: |
18.326.604 |
Assortment: |
Exact Financials
|
Date: |
05-12-2008 |
Release: |
|
Attachment: |
|
Disclaimer |