I like KeyMgtGetNextValue.
Can you tell me how to reset it?
Numbers Sequence
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
KeyMgtGetNextValue stores values in a hash file named SDKSequences. You could CAREFULLY update the values in this file.
I suggest you start by trying to view the file first. Create a job as follows:
Define two columns in your input hash file stage: KEY which is your key column (a varchar), and VALUE which is the value associated with the KEY (an integer).
Now just VIEW DATA. Get a feel for the file. By updating this file, you can reset the values. Practice writing to a sequential file, and before you make this a production job, include a sequential output file that reports the old and new values, so you have a recovery option.
I suggest you start by trying to view the file first. Create a job as follows:
Code: Select all
HASH ----> XFR ----> SEQ (later add a HASH output, too)
Now just VIEW DATA. Get a feel for the file. By updating this file, you can reset the values. Practice writing to a sequential file, and before you make this a production job, include a sequential output file that reports the old and new values, so you have a recovery option.
Chuck Smith
www.anotheritco.com
www.anotheritco.com