User-defined value in SDKSequences
Posted: Wed Jan 25, 2006 2:05 pm
Hi, I am creating a job so that it updates the SDKSequences file with the value MAX(my_table_key)+1 for the required sequence which is the argument to KeyMgtGetNextValue(). The SDKSequences file in my project folder only contains one field AT.ID, which contains the names of all the sequences in the project. However, it does not have another column which I expected to hold the current value for the sequences. I am using DS 7.0 on Windows.
Of course, I have been able to use the UPDATE statement against SDKSequences via the Administrator to change the NEXT_VALUE as required, but I wanted to automate the process through a job.
Where is the current value of the sequences located? Any help is appreciated.
Of course, I have been able to use the UPDATE statement against SDKSequences via the Administrator to change the NEXT_VALUE as required, but I wanted to automate the process through a job.
Where is the current value of the sequences located? Any help is appreciated.