Author |
Message
|
ptazbaz |
Posted: Thu Dec 05, 2002 12:49 pm Post subject: [Solved]DELETE PERSON |
|
|
Apprentice
Joined: 23 May 2002 Posts: 29
|
Does anyone know of a way to do a mass delete on persons using a wildcard? I have 300 persons defined with the prefix 'SUP_'. Is there a way I can say something like:
DELETE PERSON SUP_*
rather than having to write 300 delete statements.
Any input is much appreciated.
Regards,
Paul Tazbaz |
|
Back to top |
|
 |
jmac |
Posted: Thu Dec 05, 2002 3:10 pm Post subject: |
|
|
 Jedi Knight
Joined: 27 Jun 2001 Posts: 3081 Location: EmeriCon, LLC
|
Paul:
I dont believe that can be done. _________________ John McDonald
RETIRED |
|
Back to top |
|
 |
educos |
Posted: Fri Jan 03, 2003 12:37 pm Post subject: |
|
|
 Apprentice
Joined: 18 Jul 2001 Posts: 34 Location: Salt Lake City, UT
|
Paul,
If you have the workflow staffing API (which I believe you do if you're using the User Admin facility), I think you should be able to delete these users programmatically, using a wildcard... _________________ Eric Ducos
EmeriCon, LLC.
Phone: (801) 789-4348
e-Mail: Eric.Ducos@EmeriCon.com
Website: www.EmeriCon.com |
|
Back to top |
|
 |
vennela |
Posted: Fri Jan 03, 2003 1:03 pm Post subject: |
|
|
 Jedi Knight
Joined: 11 Aug 2002 Posts: 4055 Location: Hyderabad, India
|
What is
workflow staffing API
and
User Admin facility
Are these some kind of third party tools or are they native IBM MQWF APIs.
---
Venny |
|
Back to top |
|
 |
praveenchhangani |
Posted: Fri Jan 03, 2003 1:05 pm Post subject: |
|
|
 Disciple
Joined: 20 Sep 2002 Posts: 192 Location: Chicago, IL
|
Ptazbaz, Educos:
I agree with John in that there isn't perhaps a way to achieve this in workflow. Think about from a different perspective though, even if there was such a utility or command, it would be almost a nightmare keeping your buildtime and runtime environment synchronized.
This is probably not a hard thing for IBM to come up with, but I think reasons like the above is why they don't do it.
Praveen _________________ Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
Back to top |
|
 |
educos |
Posted: Fri Jan 03, 2003 1:19 pm Post subject: |
|
|
 Apprentice
Joined: 18 Jul 2001 Posts: 34 Location: Salt Lake City, UT
|
Venny,
Yes, those are 3rd party tools. You can PM me if you'd like more info. _________________ Eric Ducos
EmeriCon, LLC.
Phone: (801) 789-4348
e-Mail: Eric.Ducos@EmeriCon.com
Website: www.EmeriCon.com |
|
Back to top |
|
 |
praveenchhangani |
Posted: Fri Jan 03, 2003 1:21 pm Post subject: |
|
|
 Disciple
Joined: 20 Sep 2002 Posts: 192 Location: Chicago, IL
|
Folks,
I forgot to mention that....if perhaps there is a neat way to achieve this and someone has indeed tried it successfully, please do let me know.
Thanks,Praveen _________________ Praveen K. Chhangani,
IBM Certified Solutions Designer -
MQ Workflow 3.4. |
|
Back to top |
|
 |
|