I am trying to start a sequence in Datastage for a new instance. I have a development, integration and model environment, and now that I am moving to the model invironment, I want to start a sequence within SDKSequences table at a specific number. I have tried the following:UPDATE SDKSequences USING DICT VOC SET F1 = '1926541' WHERE @ID = 'Agent_Role_Key'; but I am receiving the following error: Command failed to execute - DataStage/SQL: Table "SDKSequences" does not exist. How do you start a sequence that doesn't exist yet? Thanks for any help.
Mona
Starting sequences
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Fri Feb 27, 2004 7:23 am
- Location: WI, USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Take a look at the SDK routines that manipulate keys, which create the SDKSequences hashed file if it doesn't exist. Mimic that code, or just use one of the routines once!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 26
- Joined: Fri Feb 27, 2004 7:23 am
- Location: WI, USA
-
- Participant
- Posts: 197
- Joined: Mon Feb 17, 2003 11:20 pm
- Location: India
This is because in your new project the file SDKSequences does not exist.
What you did is one way of doing it but by diong this I have faced some issues in the past. A better way would be to use and of the SDK routines to create any Dummy sequence. The routine internally would create the file SDKSequence as it does not already exist. Then you can use your command to update or create a sequence from whatever number you want.
Regards,
Sumit
What you did is one way of doing it but by diong this I have faced some issues in the past. A better way would be to use and of the SDK routines to create any Dummy sequence. The routine internally would create the file SDKSequence as it does not already exist. Then you can use your command to update or create a sequence from whatever number you want.
Regards,
Sumit